How to calculate P95 on report?

[dhanashreemore]

Hi,

I want to calculate P95(percentile) based on days aging on report. Is there any way to do so.

I have the algorithm to calculate P95 but not sure how to use it in report.

Regards,

Dhanashree More

[Uncle Rob]

Base reporting is very WYSIWYG, and only good for displaying or summarizing live data.  It is not good at analyzing the data by formulating / transforming it.  Meaning you can't get a report that says, calculate what percentile X things are in and display only those as a condition.

Options:

If you don't have Performance Analytics

You could create a summary table that runs your calculation periodically and stores the results.  TBH I hate these kinds of solution because it straps you to tech debt for a single report.

If you have Performance Analytics

Bingo.  Simple as building an automatic or calculated indicator.

[dhanashreemore · Accepted solution]

Hi,

I have done it with the help of ui page as we can't modify reports.

regards,

Dhanashree