Hello!
I have created a vary simple Stacked 100% bar chart but it is not showing the right calculation, can you please, guide me to find the issue?
The right % is 29,4%, not 22.73% as the chart is calculating
Source Data: the intention is to get the percentage of the drops compared to the totalcli.
Thank you!
Hi @celia.borges,
Is 5 not the correct value in the row that you highlighted? 5/22 is 22.73%.
Thanks for your quick response! I have a question: Where is the 22 coming from? The percentage is supposed to be 5/17 (dropcount/totalclis*100) which is 29.4%
Hi @celia.borges,
The percentage is based on the sum of totalclis and dropcount. For Power Cycle, that’s 17 + 5 = 22. If you want 5/17 instead, you need to create a calculated field for the difference between totalclis and dropcount, and add that to the bar chart instead of totalclis.
Thank you! It worked!
