Top | Previous | Next |
Aggregates / median |
median(dataset, column OR number, number...) 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. If there are no rows in the dataset, zero is returned.
For example, suppose you had a table with this dataset in it:
median({Root Container.Table.data}, "Weight") ... would return 5.566
median(1,2,3,3,10) ... would return 3 |