RangeMode - script and chart function

RangeMode() finds the most commonly occurring value (mode value) in the expression or field.

Syntax:  

RangeMode(first_expr {, Expression})

Return data type: numeric

Arguments:  

The argument expressions of this function may contain inter-record functions with a third optional parameter, which in themselves return a range of values.

Limitations:  

If more than one value shares the highest frequency, NULL is returned.

Examples and results:  

Example with expression:

RangeMode (Above(Sum(Temperature),0,3))

Returns the most commonly occurring value in the three results of the Sum(Temperature) function evaluated on the current row and two rows above the current row.

Data used in example:

Example with expression on a single field with Sum():

RangeMode (Above(Sum(MyField),0,3))

Returns the most commonly occurring value in the three results of the Sum(MyField) function evaluated on the current row and two rows above the current row.

Data used in example:

angeTemp:

LOAD * INLINE [

Region|City|Temperature

A|A|18

A|B|17

A|C|16

A|D|18

A|E|16

A|F|20

A|G|22

A|H|20

] (delimiter is '|');