Cognos Analytics with Watson

 View Only
  • 1.  Interquartile range

    Posted Tue July 05, 2022 01:04 PM
    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
    ------------------------------


  • 2.  RE: Interquartile range

    Posted Wed July 06, 2022 04:41 PM

    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
    ------------------------------



  • 3.  RE: Interquartile range

    Posted Fri July 08, 2022 11:43 AM
    Thanks Nigel, unfortunately I do not have access to SQL Statements.

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