Forum Discussion
Pie chart calcuation incorrect
Hi EaglesTony
The issue is with how you set up the Values field, right now you’re using Count of Domain, which counts distinct domain values, not the number of applications and that’s why the percentages are off.In order to fix it follow these steps:
Put ApplicationValidated in the Legend.
In Values, use Count of ApplicationValidated (or another unique application ID/row count).
Leave Details blank.
This way the pie chart will count each application correctly and show 8 “Yes” vs 1 “No,” giving you 89% vs 11%.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Hi EaglesTony
The issue is with how you set up the Values field, right now you’re using Count of Domain, which counts distinct domain values, not the number of applications and that’s why the percentages are off.
In order to fix it follow these steps:
Put ApplicationValidated in the Legend.
In Values, use Count of ApplicationValidated (or another unique application ID/row count).
Leave Details blank.
This way the pie chart will count each application correctly and show 8 “Yes” vs 1 “No,” giving you 89% vs 11%.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡