Mean (Simple Average)

Contents[Hide]

The Average function computes the mean (or simple average) of a set of input values by calculating the total (sum) and deviding it by the number of values.

Mean (Simple Average)
Mean (Simple Average)

1. Syntax

AVG(d0,Alignments...)

2. Input

The Average function requires the following input:

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

3. Parameters

The Average function accepts the following parameters:

  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis. Input values are grouped by the specified hierarchy values, and averages calculated for each group: e.g., AVG($Quantity$, $Country$) calculates the average quantity for each country.

Tip
When using alignment parameters in a formula visualization, you can choose to display these averages grouped by only the alignment hierarchy values, for example to display just the average for each country without the original input values.

4. Output

The Average function generates the following output:

  • A single value representing the mean of the input data values (or for each group when using alignment parameters).

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri