100% stacked bar chart: How to show the sum of 100% in each bar

User_OBCXC

Hi everyone,

In a 100% stacked bar chart, the values shown do not sum up to 100% due to rounding issues.
Is there a possibility in Oracle BI to get a sum of 100% in every bar without having to modify the data or show the decimals?

Thank you in advance for your support.

Best Regards.

Gianni Ceresa

Hi,

The numbers do sum up to 100%, it's the format not showing decimals that make you believe they don't, as you said yourself.

You could display 1 decimal, but still it will not solve the issue because you would still have rounding happening in the not visible digits of your values.

There isn't a checkbox or a setting to force your numbers to sum to 100 perfectly.

But it's the expected behavior, everybody seeing that chart should understand that there is rounding going on, otherwise they are anyway reading the numbers wrongly.

Your only way to not lose anything in a rounding is to not display % but the actual values, that should have a limited number of decimals (because of the source data having a limit), and that's anyway not a solution.

Keeping it short: nothing that you can do. Try displaying an decimal number, but the issue will maybe still be there, it all depends on you numbers…

User_OBCXC

Hi Gianni,

thank you for your response.
This sentence truly made my day: "But it's the expected behavior, everybody seeing that chart should understand that there is rounding going on, otherwise they are anyway reading the numbers wrongly".
Yes, I do agree with you.
Some people are hard to convince but we will keep the numbers as they are and just add a small note a the bottom of the chart.

Best regards