
Re: How to show 'Percentage of numbers above 4'?
Vishnu Chakravaram Oct 18, 2017 2:59 PM (in response to Jordan Hertl)if(column(1) > 4, Num(Column(1),'#%'), Column(1))
//  Column(1) is the measure.

Re: How to show 'Percentage of numbers above 4'?
Stefan Wühl Oct 18, 2017 3:30 PM (in response to Vishnu Chakravaram)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)

Re: How to show 'Percentage of numbers above 4'?
Jordan Hertl Oct 18, 2017 3:51 PM (in response to Stefan Wühl )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 15 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.

Re: How to show 'Percentage of numbers above 4'?
Stefan Wühl Oct 18, 2017 3:59 PM (in response to Jordan Hertl)Should be possible.
Try a line chart with dimension Quarter and as expression
Num(Count({<Score = {">4"}>} Score) /Count(Score),'0%')

Re: How to show 'Percentage of numbers above 4'?
Jordan Hertl Oct 19, 2017 11:50 AM (in response to Stefan Wühl )Thanks Stefan. That worked perfectly! Marked your answer as correct.



