How to show percentage of total on every bar in the histogram?

Question & Answer
, , , , ,
1

Hi,

image
image723×477 24.4 KB

This chart is a histogram that displays preparation time in minutes on the X-axis and the count of orders with that preparation time.

Initially, I used the histogram visual, but I found it limiting. I wanted to display the count of orders on each bar and/or the percentage of the total that each bar represents.

So, I switched to a bar chart, where I have the Order Preparation Time field on the X-axis and the distinct count of the OrderKey field as the value/measure.

How can I show the percentage of the total?

2

Hi @Ali_B ,

I am facing the same scenario in my project, but after checking, I found that it’s not possible to add the percentage in the histogram.

Any comments from our experts on this topic would be greatly appreciated.

Thanks & Regards
Biswajit Dash

3

hi- indeed our histogram widget only supports counts.

Only way i could think would leverage bar chart and calculated field to calculate % of total.

This post has example for % of total formula. How to write Percent of Total calculation , excluding dashboard filters in denominator? or you might be able to use percent of total. percentOfTotal - Amazon QuickSight

thanks
RL

1 Like
4

Hi @Ali_B,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!