How to show different tooltips in one Small Multiples?

#1

We are developing a dashboard that contains quite a few indicators, and these indicators are grouped into different areas. Currently we allow users to select a certain area and then see trends for all indicators within this area. This is done using small multiples.

Everything worked well except one thing - not all indicators within an area share the same value type (i.e. Counts, Percentage, etc.). Users have asked for showing Numerator and Denominator in tooltips for Percentage indicators and just the number for Counts indicator.

We didn’t find where we could add a separate cell within the small multiples (the same concept where scorecard allows us to add a separate group), and the tooltip text itself seems not open to customization. Would anyone know how to implement this? The best we got so far is as below and the users are not satisfied with it…

45
Screenshot 2019-06-28 14.08.45.png1360×746 66.7 KB

55
Screenshot 2019-06-28 14.08.55.png1344×722 65.9 KB

#2

Hard to say a concrete answer because i don’t understand your setup and how the small multiples are setup too.

It sounds to me like you have a column denoting the data type and a single measure being used for all values. If this is the case, you are correct that there is no hierarchy-member based formatting. If you want to do this, you will have to script the change on each of these charts. Or… use four separate charts so that you can customize each of these independently.

#3

Hi Jian,

As per my understanding of your use case, you want to show different values in the tooltip based on one of your hierarchies. For example, if the value of the hierarchy for one row is “percentage” you want to show “%” in the tooltip and so on. If this is something that you are looking for, then, in this case, you can use States.

For example, in the below chart I am setting up a different tooltip for the bar with “Territory ID” 1:
image
And for the remaining bars:
image

You can apply states based on the hierarchical value:
image

And once you have applied the states, you can go to the series property, and then within the state styles you have an option to set up the tooltip text for the bars to which the state is applying for:
image

I hope this helps in your use case. Please let me know in case you have any questions in this.

1 Like
#4

Hi Pankaj,

Thanks for your reply! I added a value type flag for each indicator and followed the approach you recommended - States worked perfectly in this case.

Best,
Jian