Computes the most common value of all numeric values found in input array. Input can be an array literal, a column of arrays, or a function returning an array. Input values must be of Integer or Decimal type.

When this function is invoked, all of the values in the input array are passed to the corresponding columnar function. Some restrictions may apply. See MODE Function.

Literal example:

listmode([0,0,2,4,6,8,10,12,14,16,18,20])

Output: Returns most common of all values in the literal array: 0.

Column example:

listmode(myArray)

Output: Generates an output column containing the mode of all values in the arrays of the myArray column.

listmode(array_ref)


ArgumentRequired?Data TypeDescription
array_refYArrayArray literal, reference to column containing arrays, or function returning an array

array_ref

Reference to an array can be an array literal, function returning an array, or a single column containing arrays.

Required?Data TypeExample Value
Yes

Array

myArray

Example - Math functions for lists (arrays)