Returns the median value from a set of numbers.
Sample usage
MEDIAN(Page Views)
Syntax
MEDIAN(X)
Parameters
X
- a numeric field or expression.
Notes
X
cannot be an aggregated field or the result of an aggregation function.MEDIAN
returns the center value ifX
contains an odd number of values. IfX
contains an even number of values,MEDIAN
will interpolate between the two center values.
Examples
Example formula | Input | Output |
---|---|---|
MEDIAN(Page Views) |
|
95 |
MEDIAN(Page Views) |
|
97.5 |