PA Indicator for 90th percentil of data

[sam_bart]

Hello everyone,

Recently, I was requested to create a special report that involves calculating the 90th percentile average (AVG) of task resolution time each month. There are some specific requirements for developing this indicator:

1. The average resolution time should be calculated based on the 90th percentile of the collected data. This means that only tasks resolved in less time than the longest 10% of resolved tasks should be included.

2. The AVG should be calculated based on historical data, so a metric cannot be used since it does not contain past data.

3. An additional filter needs to be applied to the tasks, and this filter may change in the future. Using a metric with dotwalking to apply the filter is not feasible.

To meet these requirements, I implemented two indicators. The first indicator collects and uses a script to calculate the resolution time for each task, mapped by breakdown. The second indicator creates an AVG by calculating the 90th percentile value and then computing the AVG for the collection period using the pa_scores that have a value below the 90th percentile.

Fortunately, the indicator is functioning correctly and calculating the averages accurately. However, there is an issue regarding user access to the underlying data (pa_scores) required to view the records behind the indicator. Even though users have access to tasks, accessing pa_scores requires additional roles to be granted to the user. My question is whether there is a better approach to define such a report, so that users can see the records behind the indicator.

Thank you in advance!

Regards,
Samuel

[Nishant Kharat4]

Hi @sam_bart ,

Can you please share the indicators and its type you used to calculate the 90th percentile?

Thanks,

Nishant.