You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

This summary provides overview of all formulas that can be used in reports or data sets (predefined indicators).
If you are searching for transformation scripting during data import, see Developer documentation.

Indicators and codes

Each dataset indicator is specified by its unique code starting with M_ (M as Measure). Accessing the calculated indicator's value is possible by typing this code directly into the formula. For example:

M_NAME_1 + M_NAME_2

Another way how to get the value of the indicator is to use the value() function:

value('M_NAME_1') + value('M_NAME_2')

Strings must be always enclosed by apostrophes: 'L_NAME'.

Both examples have the same result.

On this page:

Drill-down (members) aggregation

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

@SUM

Calculates the sum of all values for the selected drill-down attribute

M_NAME@SUM

@MIN

Calculates the minimum of all values for the selected drill-down attribute

M_NAME@MIN

@MAX

Calculates the maximum of all values for the selected drill-down attribute

M_NAME@MAX

@AVG

Calculates the average of all values for the selected drill-down attribute

M_NAME@AVG

@DC

Calculates the distinct count of all values for the selected drill-down attribute

M_NAME@DC

Date-Time aggregation

The date-time aggregation specifies the way, how to count values in the case that you display indicator values in higher time units (lower granularity data) than the time units in which are data stored in the system (higher granularity data).

Suffix

Description

Example

@SUMT

Calculates the sum of all values for the selected time interval

M_NAME@SUMT

@MINT

Calculates the minimum of all values for the selected time interval

M_NAME@MINT

@MAXT

Calculates the maximum of all values for the selected time interval

M_NAME@MAXT

@AVGT

Calculates the average of all values for the selected time interval

M_NAME@AVGT

@DCT

Calculates the distinct count of all values for the selected time interval

M_NAME@DCT

Drill-down and date-time aggregation

Both drill-down and date-time aggregation can be specified simultaneously.

M_NAME@SUM@SUMT

Both aggregation methods can be used in any other formulas when relevant.

Counting of level members

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

Next Steps

  • No labels