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 number). Mean is 3.00.
I am using this clause:
if ( percentile([Time]) =0.90)
then ( [Time])
But I see that some of the records do not have a percentile value - how is this possible? Please help..
I need to get mean median 80th & 90th percentile, so I don't understand when there were zeroes when I was trying to calculate median/percentiles for some values. There should be some value for the median/90th percentile - isn't it? Why am I getting a Zero?
I have been unable to figure this out since past few days, it will be of great help if you could answer my question. Thanks very much.
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 number). Mean is 3.00.
I am using this clause:
if ( percentile([Time]) =0.90)
then ( [Time])
But I see that some of the records do not have a percentile value - how is this possible? Please help..
I need to get mean median 80th & 90th percentile, so I don't understand when there were zeroes when I was trying to calculate median/percentiles for some values. There should be some value for the median/90th percentile - isn't it? Why am I getting a Zero?
I have been unable to figure this out since past few days, it will be of great help if you could answer my question. Thanks very much.