Pie chart not showing actually percent complete
@Paul Newcome Hi Paul - I found your solution for displaying appropriate percentage for pie charts in Dashboard. You had suggested entering a "helper column" =1 - [Percent Complete]@row.
Your recommendation worked for one of my pies....but not for the others.....I am only referencing the two percentages so I am confused why it would show 100 percent complete when in fact it is 0?! Any suggestions on this one?
Best Answer
-
Happy to help. 👍️
Answers
-
The second column is the % Remaining. If the % Complete is 0% then the % Remaining is going to be 100%.
-
Got - so silly question....how do I flip it to show % complete....I am missing something super easy here I think.
-
You would need to set it so that your actual % Complete is never actually 0. You would need to add maybe 0.0001 to it so it shows both on the chart.
-
Ha! Thanks. I just updated color and changed title to include not started yet. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!