Skip to content

stats

Statistics functions.

mode_last (UDF)

Returns the most frequently occuring element in an array.

In the case of multiple values tied for the highest count, it returns the value that appears latest in the array. Nulls are ignored. See also: stats.mode_last_retain_nulls, which retains nulls.

Parameters

INPUTS

list ANY TYPE

Source | Edit

mode_last_retain_nulls (UDF)

Returns the most frequently occuring element in an array. In the case of multiple values tied for the highest count, it returns the value that appears latest in the array. Nulls are retained. See also: `stats.mode_last, which ignores nulls.

Parameters

INPUTS

list ANY TYPE

OUTPUTS

STRING

Source | Edit