|
Members aggregation determines the way how to count values in the case that exists more records for one selected member in a single time unit. Aggregation type is specified by adding the appropriate suffix to the indicator's code. When not specified, the SUM
aggregation is applied.
Suffix | Description | Example |
---|---|---|
| Calculates the sum of all values for the selected drill-down attribute |
|
| Calculates the minimum of all values for the selected drill-down attribute |
|
| Calculates the maximum of all values for the selected drill-down attribute |
|
| Calculates the average of all values for the selected drill-down attribute |
|
@MEDIAN | Calculates median of all values for the selected drill-down attribute | M_NAME@MEDIAN |
| Calculates the distinct count of all values for the selected drill-down attribute |
|
Each drill-down level is represented by particular members, for example the level City
contains members like Berlin
, Paris
, New York
etc. To get the count of these members, use the following syntax:
L_NAME_COUNT //L_NAME represents the level code (prefix L like level) L_NAME_DCOUNT //to get the unique count use the _DCOUNT suffix instead |