median

This function is used by Ignition's Expression language.

Description

Calculates the median for the numbers in the given column of the given dataset or the median of a series of numbers specified as arguments. When looking up the median in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored.

Syntax (index)

median(dataset, columnIndex)

• Parameters

  • DataSet dataset - The dataset to search through.

  • Integer columnIndex - The index of the column to search through. Must be a column index of the provided dataset.

• Returns

  • Integer/Float - The median value in that column.

Syntax (name)

median(dataset, columnName)

• Parameters

  • DataSet dataset - The dataset to search through.

  • String columnName - The name of the column to search through. Must match a column name in the provided dataset.

• Returns

  • Integer/Float - The median value in that column.

Syntax (value)

median(value[, value...])

• Parameters

  • Integer/Float value - A number. Can be as many values as needed. Can be either a float or an integer.

• Returns

  • Integer/Float - The median value in the list of values.

Syntax (sequence)

New in 8.1.8

The following overload was added in 8.1.8:

median(sequence)

• Parameters

  • Sequence sequence - A list, tuple, array, or set of numerical values.

• Returns

  • Integer/Float - The median value in the list of values.

Examples

For example, suppose you had a table with this dataset in it:

ProductCode	Quantity	Weight
BAN_002	380	3.243
BAN_010	120	9.928
APL_000	125	1.287
FWL_220	322	7.889

Code Snippet

median({Root Container.Table.data}, "Weight") //... would return 5.566
median(1,2,3,3,10) //... would return 3