Aggregate functions

Median

View as Markdown

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

The Median function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

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.