Variance

This applies to: Managed Dashboards, Managed Reports

The Variance function calculates the volatility of a set of input data values, such as stock prices over a period of time.

Syntax

VARIANCE(d0,Alignments...)

Input

The Variance function requires the following input:

• d0 - Input data values - The set of data values for which the Variance is calculated.

Parameters

The Variance function requires the following parameters:

• Alignments (One or More, Optional) - Hierarchy placeholders to be used as the alignment axis.

Output

The Variance function generates the following output:

• Variance - A single value representing the variance of the input values.