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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives