Moving Average

This applies to: Managed Dashboards, Managed Reports

The Moving Average (MA) function computes the average of a set of input values over a specified number of periods. The smaller the number of periods, the faster the moving average responds to changes in the input values.

The mathematical expression being calculated is as follows:

Where N is the number of time periods and Y is the value. You can find further details about the calculation of a moving average from Wolfram MathWorld.

Syntax

MOVAVG(d0,s0,Alignment)

Input

The Moving Average function requires the following input:

Parameters

The Moving Average function requires the following parameters.

• s0 - The number of periods to use in the calculation. The default value is 10.

• Alignment (Optional) - Hierarchy placeholder to be used as the alignment axis.

Output

The Moving Average function generates the following output

For more information, see:

• Adding Formulas

• Using a Formula Visualization

• Weighted Moving Average

• Exponential Moving Average