Heatmap tooltip : automatically aggregates based on hovering on the cell value and not give the whole total value
Heatmap tooltip : automatically aggregates based on hovering on the cell value and not give the whole total value
Heatmap tooltip : automatically aggregates based on hovering on the cell value and not give the whole total value
Hi Binu
Thanks for your feedback, could you provide some more detail and maybe a screenshot of the actual result vs the desired result?
Sure. I have my 2 dimensions as dim1 and dim2. I have my measure as sum(meas1) and sum(meas2). So, currently if I hover on the cells in heatmap, the tooltip shows – dim1 , dim2, meas1 and meas2 Values.
Now I would like to add another Measure "meas C" in the tooltip. Since the Heatmap can only take 2 measures at a time, we have an option to use the customize tooltip. So , when I add the expression as sum(measC), it gives a total value. So, when I hover on each cell, it still remains the same as a total value. I have also tried aggregating by dimension,
it doesn’t work either. Is there a way that is automatically aggregates based on hovering on the cell value and not give the whole total value.
Thanks,
Karthik
Hi Piers,
I like the idea that it automatically appends at the bottom once we add the third measure expression. But the value is displayed as a total which is "1" as you see above in the screenshot attached.
The desired result of measure C would be 0.4 for the Drug4 and Payor4 when we hover on that particular cell.
Thanks,
Karthik Burra
Data Scientist - Visualization/UI/UX
Mercy