My pie chart doesn't show correct percentages
I have a chart and created a summary sheet. Then I have a report based on the summary sheets. These are all shown on my dashboard. All numbers and configured correctly. I have a total of 2759 lines and 1412 are complete. I can create a pie chart base on this information but if I choose percentage the percent is incorrect. It is saying that 1412 is 34% of 2759 which is incorrect. It is 51%. What am I missing?
Best Answer
-
Yes, there is! In your report you are using the total articles and the completed articles for the pie chart. You should use completed articles and not-completed articles in the report for the pie chart.
Your non completed articles should always be (total-completed).
Below I used:
Completed = 5 Not Completed = 10 Total = 15
Best,
Lidiya Shutaya
Answers
-
Hope your Friday is going well!
I've had this issue before and it's because the pie chart is looking at the values cumulatively not 1412 out of 2759
but
1412 out of 4171 (2759+1412). Which is = 34%
If you can I would just change the Total Articles to Total Incomplete Articles.
Hope this helps!
Lidiya Shutaya
-
So if I want the total to be 2759 and it to show we are half complete with 1412 done, is there a way to do that?
-
Yes, there is! In your report you are using the total articles and the completed articles for the pie chart. You should use completed articles and not-completed articles in the report for the pie chart.
Your non completed articles should always be (total-completed).
Below I used:
Completed = 5 Not Completed = 10 Total = 15
Best,
Lidiya Shutaya
-
You are fantastic! Thank you so much!
-
My pie chart doesn't show correct percentages
-
Hi @gampong
Are you displaying the Amount of the cells you're referencing or the Percentage of those values? It would be helpful to see a screen capture on this part of your chart:
You'll want to ensure "Percentage (%)" is set as the Value label.
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives