6 Replies Latest reply: Sep 24, 2017 4:19 PM by Stefan Wühl RSS

    Pie chart, count scores - lower, middle, upper

    Kristan Sears

      This is a simple question, but I'm struggling with the mechanics.  I have scores for student, with fields "Attained" and "Possible".  Scores are calculated in % as Sum(Attained)/Sum(Possible).  I want to Count the number > 50%, number = 50%, and number < 50%. 

       

      Then, I want to show this in a pie chart, so that I only have three groups.  I'm not sure if I should be counting the number of scores, or the number of students.  Either way, my expressions get complicated, and I'm not seeing a straightforward solution.

       

      Should I create variables and use a ValueList?  Not quire sure how that would work.  I appreciate any guidance you can offer.

       

      Thank you in advance,