If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Percentile calculation

Started by asr, 28 Jun 2010 03:57:18 PM

Previous topic - Next topic

asr

How can I calculate percentile? I need to get the 80%,90% etc

I am using this
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..

DustPanMan

With your calculation, it's only going to show the percentile value if it equals 90.  Are you simply wanting to display the percentile?  If so, try starting with percentile([Time]).  From there, you will see every percentile.  To lump these together, you can round to the nearest 10's place.

Best regards,

Dustin
Best,

D

asr

Thanks , but I actually 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 need to get mean median 80th & 90th percentile, so I did not understand when there were zeroes when I was trying to calculate median/percentiles for some values.
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.

blom0344

With an array of 10 values it is possible to just show the value for the related object based on:

CASE
[Perc]
WHEN 0.9 THEN
[SR]
ELSE
NULL
END

where [Perc]  is defined as percentile([SR])

You will need to associate [Perc] with the list (through properties) but remove it from the list layout for this to work..

asr

Thanks very much, but the array of numbers is not 10. This is a dynamic count for each record. I just used that as an example. When I was trying to get the 80th percentile, some records showed no values. I did not understand how there cannot be an 80th percentile for any given list of numbers. Please help.

mvjcognos

To calculate percentile u have option in the properties like click on the particular dataitem and go to the properties and select percentage and select the symbol it will automatically calculate the percentage of that dat item and show the symbol..............

holsy1982

I'm also trying to work out percentile.  I've a large data set which has got a measure detailing the length of time from one stage to another for each sale, this data is also split by a channel hierarchy and a product hierarchy (albeit not dimensionally modelled). 

I'd like to know for any split of channel and product the 80th percentile for this. Anyone managed to do anything like this.