Hi PA Experts,
Need your valuable inputs on below requirement.
REQ:→
1)List of monthly Resolved Cases → We already have.
---------------- Need to achieve below points------------------------------------------------
2) Covert Resolved time to Days (T/60/60/24)
3) Sort the data in ascending order.(Monthly)
4) Then look for below values
P = Percentile
N = Count of Incident in a particular month.
n = (P*N)/100
Percentile is nth position in shorted list of duration.
if n=10 then look for the 10 position in sorted list.
5) Count for 50%/75%/90%/95%/99%
Need to accommodate in single formula indicator
