MEDIAN

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 if X contains an odd number of values. If X contains an even number of values, MEDIAN will interpolate between the two center values.

Examples

Formula Input Output
MEDIAN(Page Views) Page Views : 95
Page Views : 100
Page Views : 92
95
MEDIAN(Page Views) Page Views :100
Page Views : 95
97.5

Related resources

Was this helpful?
How can we improve it?