My Half-Donut is not reflecting the correct percentages
I have several half-donut charts that show a goal progression that are reflecting correctly. Two of the charts are not reflecting the correct percentages of completion. What am I doing wrong?
Answers
-
Are you able to provide screenshots of the source data?
-
I agree that it would be helpful to see the source data as well!
Based on your images, it looks like your widget is configured to show "Percent" versus showing "Value". What this does is it reads your values and compares them to create a percent.
However in your instance, it looks like your values are percents themselves. You'll want to ensure that when you combine the two values together it = 100:
It looks like perhaps the formula that's calculating the "% remaining" in your source may be giving you an incorrect remaining value.
-
Here is the data source
-
How are you getting the "% Remaining"? Are you subtracting the linked value from the Goal?
Currently the Grand Total actually equals 109% (36% + 73%) not 100% (which would be 36% + 64%)
-
I was averaging the other percent completes. Thank you! I think it's fixed now.
-
Glad to hear it's working now! 🙂
