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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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%)
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I was averaging the other percent completes. Thank you! I think it's fixed now.
-
Glad to hear it's working now! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives