I have a donut chart in which I would like to display both values and percentages. However, when applying percentages the numbers don’t add up.
In the demonstration video found here (Using donut charts - Amazon QuickSight), we see a demo various minerals distributed by sales. The total sales equals $36,755K. Adding values and percentages gives, for Iron Ore, 13,378 and 36%. The 36% of 36,755 equals 13,231 … not 13,378. I suspect QuickSight for miscalculating the percentages. Can you confirm?
Hi @Christian_Soerup , nothing like than we can add both numbers and percentage in the donut chart in QuickSight.
Please need follow some steps to achieve the required results.
If you see the above picture I have the donut chart and added both the number and percentage for this chart.
Go to format visuals .
Go to Data Labels dropdown menu from the left sides & select the Metric label style as value & percent.
Hi @Biswajit_1993 ,
Thanks for your reply. I have done exactly as you suggest. Here’s the example where there is a mismatch between values and percentages:
hi @Christian_Soerup I think the value & percentage both are correct if you required decimal point instead of round number we can do that but the percentage is ok if you see dividing with the respective category value with total value then we got the same percentage.
I’m glad that we agree on the method and I do see your point about the rounding of numbers. Here’s a different example where the percentages are off. For the largest ‘piece’, the numbers are 17,652 divided by 38,213. That gives me about 46% and not 39%. Agree?
Hi @Christian_Soerup Thanx for your detailed query. I think in this case some data issues at your end nothing to do with QuickSight.
Can you check once with your data source level.
Hi @Christian_Soerup ,
You can also validate the % calculation using a pivot table. Below is a screenshot
In Pivot table, I am using a table calculation Percent of total ( Functions for pivot table calculations - Amazon QuickSight ) with the calculation being Table Down ( Ways to apply pivot table calculations - Amazon QuickSight )
I’ll do a check and get back to this thread. Thanks for your help, @Biswajit_1993 and @Koushik_Muthanna