Calculations Overview

<< Click to Display Table of Contents >>

Navigation:  Version 6 Enhancements > Dashboard Designer > Calculations >

Calculations Overview

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.

img123477

The Dashboard Designer allows you to apply 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.

img123490

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.

img123491

Difference - Allows you to compute differences between measure values.

img123492

Percent of Total - Allows you to calculate a contribution of individual measure values to a total.

img123493

Rank - Allows you to rank values of the specified measure.

img123494

Note that the computing of 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 with 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 .

To learn how to create a calculation in the Dashboard Designer, see Creating Calculations.