Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation

Creating measures on stream fields

Parent article

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

Create a measure on a stream field

These steps guide you through creating a measure for a field in the stream using the Annotate Stream step.


  1. If you have not done so already, complete steps 1-7 in the Use the Annotate Stream step.

  2. Select Create Measure from the Actions menu.

    The Name - Value table auto-populates with a list of annotation properties for the measure. Annotate dialog box
  3. Enter or edit the values for each annotation component.

    Measure NameEnter a name for your annotation.
    Aggregation TypeSpecify a format string or choose from a list of aggregation types:
    • SUM
    • COUNT
    Note that COUNT and COUNT-DISTINCT are only available for non-numeric fields.
    Format StringChoose how this field should be formatted, such as currency, general number, or percentage.
    DescriptionEnter a brief description for the annotation. This description will be available on the Pentaho Server.
    HiddenSet to True to prevent this annotation from displaying as an available measure in Analyzer. When set to True, this annotation is included in the model, but it is not visible to users when the model is published and opened in Analyzer. Set to False to allow this annotation to display as an available measure in Analyzer. When set to False, this annotation is visible to users when the model is published and opened in Analyzer. The Hidden property is useful for annotations needed to build a proper data model, but not needed for analytic purposes. For example, if you are in a multi-tenant environment, you may want to hide the Tenant ID annotation while still including it in the data model.
  4. Use the Previous and Next buttons to navigate through the fields.

  5. When finished, click OK to save your changes and close the dialog box, or Cancel to close the dialog box without saving your annotations.