Percentile Rank
28 February, 2013
I am trying to figure out how to get a percentile rank in Yellowfin. Here is an example data set. You can see that i need to rank each entity as well as see what percentile they are in according to all other entities. Yellowfin has the built in Decile and Quartile function, but this goes beyond that. Any help would be greatly appreciated.
Entity Score Rank Percentil Rank
A 78 4 43%
B 96 1 86%
C 47 5 29%
D 79 3 57%
E 81 2 71%
F 32 6 14%
Entity Score Rank Percentil Rank
A 78 4 43%
B 96 1 86%
C 47 5 29%
D 79 3 57%
E 81 2 71%
F 32 6 14%
Hi,
It sounds like you would need to drag in the 'score' field 3 times into your report.
One will be the normal score, no conversion applied.
The 2nd will have the advanced function 'Top N Rank' applied.
However we do not have a percentil analytic function for the 3rd column.
But you can create your own custom function to do this.
An example of creating a custom function can be found here;
How to compute number of minutes from current time
Please let us know how you go, if I have misunderstood what you were after.
Regards,
David
It sounds like you would need to drag in the 'score' field 3 times into your report.
One will be the normal score, no conversion applied.
The 2nd will have the advanced function 'Top N Rank' applied.
However we do not have a percentil analytic function for the 3rd column.
But you can create your own custom function to do this.
An example of creating a custom function can be found here;
How to compute number of minutes from current time
Please let us know how you go, if I have misunderstood what you were after.
Regards,
David