I'm sure you all had this - You add a breakdown bar report with percentages, and when the underlying values are 1 and 7 you end up getting 13% and 88%...
This means, when you add the displayed percentages, you get 101%!
!
How do you deal with these?
Best answer by BruceK
I second the suggestion for a pie chart - your readers will know that a pie chart shows percentages of the whole and sum to 100%, and will often realize on their own there is rounding. When you see a stacked bar chart, you aren't going to necessarily know it is supposed to sum to 100%
Hi @alitokmen , Ideally it should add to 100%, Here in your case data may be correct and its adding to 101% or sometimes 99% is due to rounding off. Can you try adding decimal places (this can solve your problem) while +- 1% if due to rounding off doesn't affect.
@alitokmen if this display is the most appropriate, but you are worried about confusing your readers, you could always add a textbox/footer that reads something like - due to rounding percentages may not add up to 100%.
This was common practice when I worked at a full service market research firm.
@alitokmen - I do understand your query. I did face this with few of my clients and the best possible options to tackle them are as follows:
1. As there is no option to change decimal points, you can just add a note "[Data is currently rounded up]" and along with this widget add an simple table widget below the breakdown bar.
2. It would be better to change the view to Pie Chart where you have options to change the decimal places and this would also look visually nice in the reports.
I second the suggestion for a pie chart - your readers will know that a pie chart shows percentages of the whole and sum to 100%, and will often realize on their own there is rounding. When you see a stacked bar chart, you aren't going to necessarily know it is supposed to sum to 100%