How to show 'Percentage of numbers above 4'?

[Anonymous]

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

[vkish16161]

if(column(1) > 4, Num(Column(1),'#%'), Column(1))

// - Column(1) is the measure.

[swuehl]

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)

[Anonymous]

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.

[swuehl · Accepted solution]

Should be possible.

Try a line chart with dimension Quarter and as expression

Num(Count({<Score = {">4"}>} Score) /Count(Score),'0%')

[Anonymous]

Thanks Stefan. That worked perfectly! Marked your answer as correct.