Manage measure calculations

You can add, clone, rename, configure, and delete measure calculations.

There are two types of measure calculations:

• Aggregates

  You can configure aggregate calculations to execute a single operation on a single field. Aggregate calculations serve as the base variables within a measure. You can use aggregate calculations as input for expressions.

  An aggregate calculates a summary function, such as average, minimum, and sum on the data set retrieved from the source.

• Expression

  You can build an arithmetic expression using the configured aggregates.

  An example for a simple calculation created from an expression is (AggregateA + AggregateB)/AggregateC.

Measure calculations are each represented by separate columns in the resulting measure table.

The column names are the same as the calculation names defined in the measure object.

You must define at least one measure calculation in a measure.