Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if there is a way for a chart to display the percentage of numbers above a certain score. For this example lets say 4. So the percentage of all of the scores on this test that were above 4.
Is there a way to do this?
Thanks,
Jordan
Should be possible.
Try a line chart with dimension Quarter and as expression
Num(Count({<Score = {">4"}>} Score) /Count(Score),'0%')
if(column(1) > 4, Num(Column(1),'#%'), Column(1))
// - Column(1) is the measure.
What's the context of your expression, I mean are you using dimension(s) in your chart? And how are your numbers related to the dimensions?
Would be best if you could post some sample lines of records, a description of the context and your expected result.
As a guess, it could look like
=Count(If(Value>4,Value)) / Count(Value)
or using set analysis
=Count({<Value = {">4"}>} Value) / Count(Value)
I have 3 columns....
Column 1 is the groups of people that took the test
Column 2 is the Quarter in which it was taken (Quarter 1, Quarter 2, Quarter 3, Quarter 4)
Column 3 is the score of the test on a 1-5 point scale
My hope would be a line graph (possible?) to show how many scored in a "Good" range (above 4) each quarter
So basically a line graph with Q1 (30%) Q2 (43%) Q3 (41%) Q4 (48%)
If this sort of thing is not possible on a line graph, which type of visualization would it be possible with?
Let me know if you need more information.
Should be possible.
Try a line chart with dimension Quarter and as expression
Num(Count({<Score = {">4"}>} Score) /Count(Score),'0%')
Thanks Stefan. That worked perfectly! Marked your answer as correct.