My pie chart doesn't show correct percentages

KristenBuezo

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?

SS3.JPG

SS2.JPG

SS1.JPG

SS.JPG

Lidiya S.

@KristenBuezo

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

Lidiya S.

@KristenBuezo

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

KristenBuezo

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?

Lidiya S.

@KristenBuezo

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

KristenBuezo

You are fantastic! Thank you so much!

gampong

My pie chart doesn't show correct percentages

Genevieve P.

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