Mode

Contents[Hide]

The Mode function finds the value (or values) repeated more often than any other in a value series.

Mode
Mode

1. Syntax

MODE(d0,Alignments...)

2. Input

The Mode function requires the following input:

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

3. Parameters

The Mode 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 the mode calculated for each group: e.g., MODE($Quantity$, $Country$) calculates the mode for each country.

4. Output

The Mode function generates the following output:

  • Mode - One or more values representing the mode of the input values (for each group when using alignment parameters).

This can include multiple values if they each occur the same number of times, and mode values are therefore not repeated in every row when used in a formula measure.

Important
When used in a formula visualization where there are multiple mode values, they will be aggregated according to the aggregator setting of the measure, which is Sum by default. You can change the aggregator to Minimum or Maximum instead, for example, to choose which mode to display.

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

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