PowerAdd
Description
PowerAdd pre-aggregates a measure by the current dimensions plus additional classification dimensions and optional filters.
Syntax
PowerAdd(aggregate_expression[, dimension1[, dimension2...]][, filter1[, filter2...]][, RemoveFilter(...)])
Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
aggregate_expression |
Yes | Expression | Aggregation expression. It must contain an aggregate function. |
dimension |
No | Field | Additional classification dimension. |
filter |
No | Expression | Filter applied before aggregation. |
RemoveFilter |
No | Expression | Removes filters from the current calculation context. |
Notes
Pre-aggregation functions must be used inside supported metric expressions and cannot be nested inside other pre-aggregation functions unless explicitly supported.
Example
The expression returns the calculated result according to the current query context.