How are percentiles calculated in Cognos? (when compared to SQL/Excel etc) I am trying to calculate 80th percentile, but see that some records have no 80th percentile? How can this be possible? Please help.
I need to show the [Time] value where percentile = 90%.
Something like this:
80th percentile of 10 SRs closed in .46, 1.12, 1.13, 1.67, 1.72, 1.88, 2.24, 4.32, 6.22, 9.19 days would be 4.32. 90th percentile would be 6.22. Median would be 1.88 (or possibly 1.80 since there is no exact middle...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.