Window Calculations Overview
- 2 min to read
Window calculations provide the capability to apply specific computations to measure values and allow you to perform different analytical tasks such as to compute running totals, percentages of totals, differences, etc.
The Dashboard Designer allows you to apply window calculations to values of the specified measure. The following calculation types are supported.
Running Total - Allows you to calculate a cumulative total for a set of measure values.
Moving Calculation - Allows you to apply a moving calculation, which uses neighboring values to calculate a total. Note that neighboring values are specified using offsets from the currently processed value.
Expression: WindowSum(Sum([Sales]), -1, 1)
Difference - Allows you to compute differences between measure values.
Expression: Sum([Sales]) - Lookup(Sum([Sales]), -1)
Percent of Total - Allows you to calculate a contribution of individual measure values to a total.
Expression: Sum([Sales])) / Total(Sum([Sales]))
Rank - Allows you to rank values of the specified measure.
Expression: RankCompetition(Sum([Sales]), 'asc')
Note that the computing of window calculations depends on two factors.
The type of the dashboard item.
In this case, you need to specify a calculation direction that depends on the dashboard item type. For instance, the Pivot dashboard item provides the capability to apply calculations along its columns or rows.
The set of dimensions that are used to calculate measure values.
In this case, a calculation direction depends on the dimensions' order.
In both cases, measure values participating in a calculation fall into a specified window. To learn more, see Window Definition.
To learn how to create a window calculation in the Dashboard Designer, see Creating Window Calculations.