Dynamic aggregation in documents

Before you begin

This topic assumes that you understand the levels of metric calculation on a report. For background information, see About metrics.

Dynamic aggregation is the rollup of metric values that occurs when a metric is placed in any document section other than the Detail section. It does not matter whether the metric is placed in a text fieldor aGrid/Graph. The function used in this aggregation is set in the metric definition, as defined by the following rules:

• If the metric function is SUM, MIN, or MAX and the dynamic aggregation function is set to default, the document aggregates the metric correctly using SUM, MIN, or MAX accordingly.

  If you do not want SUM, MIN, or MAX to be used as the dynamic aggregation, change the metric definition. Specify the new function to be used as the dynamic aggregation function.

• If a metric function other than SUM, MIN, or MAX is used and the dynamic aggregation function is set to default, dynamic aggregation does not occur. Instead of a value, dashes (--) are displayed, unless you have changed the replacement text. If you want to use a particular function, change the metric definition, specifying the function to use as the dynamic aggregation function.

Compound metrics follow the same rules for aggregation. If a compound metric does not use a SUM, MIN, or MAX function, and the dynamic aggregation function is set to default, a null value is generated when the compound metric is placed in any section other than the Detail section. To trigger dynamic aggregation, specify the function to use for calculation.

In the case of user-defined metrics (calculated expressions and derived metrics), the function specified in their definition is used as the aggregation function if the function is SUM, MIN, or MAX. For details on user-defined metrics, see Creating metrics in documents.

For instructions on changing the dynamic aggregation function, refer to Specifying dynamic aggregation functions. For more information on dynamic aggregation in metrics, see Dynamic Aggregation in the In-memory Analytics Help.

Related Topics

• Calculating metrics at the dataset level: Detail section

• Calculating metrics at the group level: Group Headers and Group Footers

• Calculating grand totals for metrics: header and footer sections

• Calculating metrics at the level of a Grid/Graph

• Calculating metrics at the level of a Grid/Graph and a group: Group Headers and Group Footers

• About metrics

• Specifying dynamic aggregation functions