Returns the median of all the values in a column.
Compute the median of the values in the data column AMOUNT_SOLD.
Compute the median of AMOUNT_SOLD by QUARTER_NUMBER.
median(double expr, [groupBy(...)])
- expr : expression evaluating to
groupBy: optional grouping function
doublerepresenting the median of the values in the column. If
medianreturns the median for each group.
You must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. See Aggregation with Level Based Measure in Aggregating Functions.