Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I am hoping to get some help with calculating percentiles. I have a detail data file containing the following items to date level (with many entries per each individual date):
Date
Week number
Customer
Modality
Number of Days Waiting
I want to calculate the 90th percentile of the above data set. In order to achieve this I will need summary file of each individual waiting time (by week number) in order from lowest to highest, and then find the single value which has 90% of all values below it. A slider would also be useful here to allow flexibility on selection of percentile calculation.
Has anyone any experience of doing this or suggestions on the best way to approach the problem?
Cheers,
Steve.
Hi Steve,
Have you found a solution to the above problem?
Fractile(aggr(sum([Numbers of Days Waiting], WeekNumber, Customer), 0.9)
You can use a variable instead of the harcdoded 0.9.
HTH,
Michael.