Median

The Median function finds the mathematical median of a column or group.

Syntax

Median(numbers)

Function arguments:

• column (required) - The column of numbers to be evaluated.

📘If there is an even number of values, Median interpolates between the middle values.

Example

Median([Temperature])

Find the median temperature value. If the column values are 3, 5, 7 and 20, the result is 6.