Forum Discussion
mork
10 years agoHelper V
Pie Chart Issue
I have created a measure that shows the work distibution of my resources in precentage. I use this measure in a pie chart and it shows up fine. But after the latest updated they added percentage ...
- 10 years ago
mork Your Numerator uses COUNTA (which ignores blanks) while your Denominator uses COUNTROWS (which counts ALL)
This is will definitely make the % not add up to 100% (if you have blanks) Convert your pie chart to a Table and Check
You have to be consistent either use COUNTA for both or COUNTROWS for both
Let me know if this takes care of it.
Sean
10 years agoCommunity Champion
mork Your Numerator uses COUNTA (which ignores blanks) while your Denominator uses COUNTROWS (which counts ALL)
This is will definitely make the % not add up to 100% (if you have blanks) Convert your pie chart to a Table and Check
You have to be consistent either use COUNTA for both or COUNTROWS for both
Let me know if this takes care of it.