Absolute and percentage change aggregations

Configure absolute change, percentage change, and market share change aggregations to compare values across dimensions and analyze performance shifts over time.

For measures, you can set Absolute change, Percentage change, Marketshare absolute change and Marketshare percentage change aggregations.

Absolute change

The Absolute Change calculates the exact increase or decrease between two data points. This is essential for identifying trends, shifts, and changes in your data over time.

Absolute change window

• Dimension: Select the dimension that the absolute change will be calculated over.

• Value 1 and Value 2: Specify the two points between which the absolute change will be calculated. They define the scope of the comparison.

• Calculation formula: measure @Value 1 - measure @Value 2. This represents the subtraction of one measure's value from another, showing the net change.

• Click on Create to apply the absolute change aggregation to the selected measure.

Percentage change

The fields for the calculating percentage change is the same as that of the absolute change. However, the formula is different because it provides the change as a proportion of the initial value, which is expressed as a percentage.

Percentage change window

The following formula calculates the change relative to the original value (Value 1).

$(Value 2−Value 1)/Value 1×100(Value 2−Value 1)/Value 1×100$

Percentage change is a standard metric for performance analysis, and it also helps in identifying trends in data over time, regardless of dataset size.

Marketshare absolute change

Marketshare Absolute Change can be used for assessing the direct change in market share over specific periods and comparing market share between different market segments or product lines.

Marketshare absolute change window

• Dimension: Select the relevant dimension.

• Choose the specific data points for comparison.

  • Value 1: Select the initial point of comparison, such as the beginning of a quarter or year.

  • Value 2: Choose the endpoint for comparison, such as the end of a quarter or year.

• Calculation formula: measure @Value 1 - measure @Value 2. This represents the subtraction of one measure's value from another, showing the net change.

• After setting up the absolute change calculation, you are prompted to also add a Market Share Target filter, allowing for a targeted analysis of market share changes.

• Click on Create to apply the marketshare absolute change aggregation to the selected measure.

Marketshare percentage change

The fields for the calculating marketshare percentage change is the same as that of the absolute change. However, the formula is different because it provides the change as a proportion of the initial value, which is expressed as a percentage.

Marketshare percent change

The following formula calculates the change relative to the original value (Value 1).

$(Value 2−Value 1)/Value 1×100(Value 2−Value 1)/Value 1×100$

Market share percentage change helps businesses understand their performance in the context of the market relative to competitors."