Skip to main content
Pentaho Documentation

Creating Measures on a Column

Overview

 As part of the Annotate Stream step, you can create a measure or series of measures to further refine your data model.

A measure is a property that is used to make very specific calculations, such as  SUM, AVERAGE, COUNT, COUNT_DISTINCT, MINIMUM, or MAXIMUM. As part of the Annotate Stream step, you can create a measure or series of measures to further refine your data model.

These steps guide you through creating a measure on a column using the Annotate Stream step.

  1. Double click to open up the Annotate Stream dialog.
  2. Click on the Select Fields... button to choose a field to create a measure on.
  3. Double click on that field in the list of Annotations.
  4. Select Create Measure from the Actions menu. The Name - Value columns auto populate with a list of annotation components for the measure.
    1. Enter a name for the measure.
    2. Click to choose an aggregation type .
    3. Choose a format for the measure.
    4. Optionally, enter a brief description of this measure.
  5. Click OK to finish the measure or click Cancel to exit.

This is an example of the Annotate - Create Measure dialog box, along with a table that has more details about each field.

CreateMeasure.png

Options Description
Name - Value Displays the name of the annotation component in the Name column. Click in the Value column next to the item that you want to work with.
Measure Name Type a name for your annotation.
Aggregation Type

Specify a Format String or choose from a list of aggregation types:
SUM, AVERAGE, COUNT, COUNT_DISTINCT, MINIMUM, or MAXIMUM.

COUNT and COUNT-DISTINCT are only available for non-numeric fields.

Format String Choose how this field should be formatted, such as currency, general number, or percentage.
Description Enter a description for the annotation. This description will be available on the BA Server.
Help Provides a link to the Help documentation.
Previous Scrolls back through the list of created annotations on the model.
Next Scrolls forward through a list of created annotations on the model.
OK Click OK to save.
Cancel Click Cancel to close the window.