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.
Re: Pie chart, count scores - lower, middle, upper
This worked perfectly. I created a Field called "Score" instead of students. How can I modify this calculated dimension, to filter the scores by Subject, i.e. Mathematics? If I put a selection filter in the App, it yields the correct results, but I want the pie chart to be static for each subject.
Here's my calculated dimension, which is working.
If( Score < 0.5, dual('< 50%',1),
If( Score > 0.5, dual('>50%',3),dual('=50%',2)
Here's my MODIFIED calculated dimension, which is working.