Forum Discussion

mork's avatar
mork
Helper V
10 years ago
Solved

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 ...
Need Help
  • Sean's avatar
    Sean
    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.

mork's avatar
mork
Helper V
10 years ago

Sean

 

Also anotehr thing that I noticed is that none of the two percentages add up to 100%. Though the default percentage from the pie chart comes closer at 99.84% while my measure's percentage is around 50%. I don't remember having that issue with my measure before the latest update.

Sean's avatar
Sean
Community Champion
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.

  • mork's avatar
    mork
    Helper V
    10 years ago

    Sean

     

    You are correct that was the problem