Create a five-number summary

Pentaho Business Analytics
Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17

Perform the following steps to create a five-number summary of data points for a Boxplot chart:

  1. Create a new or open an existing Analyzer report and select Boxplot from the chart dropdown.
  2. Right-click any Measures field and choose User Defined Measure > Create Calculated Measure.
    The Calculated Measure dialog box displays. See Creating a calculated measure in a report.
  3. Create a calculated measure that returns the median value.
    1. Enter the following MDX query In the Create Calculated Measure formula panel: Median(<Set>, <Numeric Expression>)
    2. Enter an appropriate name and click OK to create the median calculated measure.
    You can return a set of descendants of a set member at a specified level, optionally including or excluding descendants in other levels with the following code: Descendants(<Member>, <Level>)

    See Mondrian documentation.

  4. Create a calculated measure that returns the lower quartile value.
    1. Enter the following MDX query In the Create Calculated Measure formula panel: FirstQ(<Set>, <Numeric Expression>).
    2. Enter an appropriate name and click OK to create the lower calculated measure.
  5. Create a calculated measure that returns the upper quartile value.
    1. Enter the following MDX query In the Create Calculated Measure formula panel: ThirdQ(<Set>, <Numeric Expression>).
    2. Enter an appropriate name and click OK to create the upper quartile calculated measure.
  6. Create a calculated measure that returns the minimum value.
    1. Enter the following MDX query In the Create Calculated Measure formula panel: Min(<Set>, <Numeric Expression>).
    2. Enter an appropriate name and click OK to create the minimum calculated measure.
  7. Create a calculated measure that returns the maximum value.
    1. Enter the following MDX query In the Create Calculated Measure formula panel: Max(<Set>, <Numeric Expression>).
    2. Enter an appropriate name and click OK to create the maximum calculated measure.