Mode

Returns the most frequently occurring or repeated value in a given list. This is a group-value function.

Syntax

Mode <FactID, IsRemovable>(Argument)

Where:

• FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.

• IsRemovable is a parameter that determines whether the Mode of a single value returns that value or a NULL value, as described below:

• IsRemovable=True returns the single value as the result of the Mode function. For example, Mode<IsRemovable=True>(4) would return the value 4.

• IsRemovable=False returns a NULL value as the results of the Mode function when a single value is supplied. For example, Mode<IsRemovable=False>(4) would return NULL.

  • If multiple values are supplied to the Mode function, the IsRemovable parameter has no effect on the result of the Mode function.

• Argument is an attribute, fact, or metric representing a list of numbers.

Usage notes

• This function provides a location measure: the value returned has a relative position with regard to other values in the list. Median is another function that provides a location measure.

• Returns a NULL if there are no recurring values in the range or list.

For additional information on and an example of this function, refer to the Functions Reference.