Calculating percentiles
Hi.
I'm trying to get some percentiles (10,25,50,75,90) from my data.
First, I tried with the percentile PQL function, but it has the restriction of being attached to the Dimension provided in the list.
Then, I tried with the percentileRank PQL function, but I couldn't findo out how to get my measure in the numeric list parameter.
Is there a way to calculate my percentiles without regards on what dimensions I use?
Thanks a lot
Jair
3 replies
-
Hi
In what context are wanting to calculate the percentile?
The Percentile function returns the defined percentile from a list of values of a Measure. In a dimensional semantic model as Pyramid uses, the list and the values are defined by a set of members from a dimension. Measures do not exist independently as they would in a column in a relational table for example. They are defined by the dimensional view you are taking, for example the sales values for a set of products sold in the US in 2023.
The PercentileRank function is designed to be used in Dynamic Text calculations, i.e. operating on a row or column of data from a grid generated by a query. and used in a Present dashboard of a Publish publication. The column or row is defined by the grid co-ordinates, there is no concept of a Measure in this context, hence you can't pass one to the function.
Can you provide an example of what you are trying to achieve and we'll endeavour to help you get there.
Thanks,
Ian
-
Hi
Actually we are migrating our BI tool from Whitelight to Pyramid and in WL we showed the percentiles like columns since there was no other way to do it (something like the first image) and they were calculated over a measure and as many dimensions the user wanted to add. I was thinking in Pyramid we could use KPI's in a Present to show them, hopefully being calculated with the filters the user may want to use (something like the second image).
-
Hi
I would also appreciate if you could show an example of how to use the PercentileRank function the way you describe it.
Thanks!
-
