Show total of groups in stacked bar chart tooltip

Is there anyway to show the total of all of the groups in a stacked bar chart tooltip?

See the following image for an example:

1 Like

Hi,

try this one.

1 Like

Hi Naveed, thanks for the quick response. The Show aggregations checkbox doesn’t change anything. My goal is to show the “Total” row in my mock up image. Currently, that doesn’t seem to be available in QS.

Hi,

do you see the fields in the tooltip menu?

There you can add fields. You can create a calculated field, where you calculate your total and then you can add this calculated field with the button “Add field”.

1 Like

I can see that. I’m not trying to add another field, I’m looking to get the sum of the entries in the amount_usd field. Basically, what would the sum be if I removed the Group/Color variable.

The way to do that is to create a calculated field that calculates the sum and to add that field to your tooltip. There’s currently no other way.

1 Like

Hi,

yes, i understand.

image

with sumOver(sum(amount_usd),[PARTITION]) you get the sum of your values and can insert it as a field.

its not the best solution, but this way you get the sum in the tooltip

1 Like

Is there any way to submit this as a feature request?

Hi Zach, This feature has been noted as a feature request. I will add it to the backlog

6 Likes

Hi, For stacked bar chart, How can I view percent of total for each value in the chart.

Hi

Is there any update on this? I’m currently looking to do somehting similar and all the suggestions on this post are not really satisfactory from a UX standpoint.

thanks,
Brett

Hi, has there been any updates on this?

Hi @Bchadha do you have any updates on this?

1 Like