Reporting on Median Time To Remediate using PA indicator?

[GRACHELLEI]

In Vulnerability Response OOB there's Mean Time To Remediate formula indicator calculated as Summed duration of VI / Total Count of VI. PA Aggregate options only include Sum, Count, Minimum, Maximum but no Median.

Looking for a less complicated way to calculate the Median score for a set of durations/age?

[agross4]

Having the same issue and there seems nowhere an easy answer

[GRACHELLEI]

I did use manual PA indicator to achieve this, but it's not straight forward.