Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I am trying to set a rank value as a column in a straigt table but I am unsure the exact expression. My data set is as follows:
Location | Exceptions | Rank |
A | 5 | |
B | 8 | |
C | 3 | |
D | 6 | |
E | 9 | |
F | 5 | |
G | 2 | |
H | 4 |
I want the expression in "Rank" column to return a value A(<.25), B(.25 to .50), C(.50 to .75), D(>.75) based on quartile value of exception against total exceptions.
There are multiple dimensions so i would need this to aggregate.
Thanks
Try this as your expression.
=If(Exception < Fractile(TOTAL Exception, 0.25), 'A', If(Exception < Fractile(TOTAL Exception, 0.5), 'B', If(Exception < Fractile(TOTAL Exception, 0.75), 'C', 'D')))
Also please find atttached a qvw file.
Best,
S