Vizlib Home
Welcome
Login

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?

  • image

    image



    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

    heatmapviz.PNG
    (47.1 KB)
  • 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

Login to post a comment