Hi,

Cognos Analytics 11.5

I would like to get the interquartile range of a dataset.

The "quartile" function gives me the number of the quartile where the data is (1 to 4) but not the interquartile range.

Any idea ?

Thanks,

Alex


------------------------------
Alexandre COURJARET
------------------------------

#CognosAnalyticswithWatson

Assuming the Box Plot viz isn't what you need.

Using SQL statement, you would define calculations such as

PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY ... ) OVER (PARTITION BY ...)
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY ... ) OVER (PARTITION BY ...)
PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY ... ) OVER (PARTITION BY ...)

------------------------------
NIGEL CAMPBELL
------------------------------

Thanks Nigel, unfortunately I do not have access to SQL Statements.

------------------------------
Alexandre COURJARET
------------------------------

Original Message:
Sent: Wed July 06, 2022 04:41 PM
From: NIGEL CAMPBELL
Subject: Interquartile range

Assuming the Box Plot viz isn't what you need.

Using SQL statement, you would define calculations such as

PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY ... ) OVER (PARTITION BY ...)PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY ... ) OVER (PARTITION BY ...)PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY ... ) OVER (PARTITION BY ...)

------------------------------
NIGEL CAMPBELL
------------------------------