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

Example formula Input Output
MEDIAN(Page Views)
  • 95
  • 100
  • 92
 95
MEDIAN(Page Views)
  • 100
  • 95
 97.5

Notes

For BigQuery data sources, MEDIAN is implemented using the BigQuery APPROX_QUANTILES function. Applying MEDIAN to data coming from BigQuery may return slightly different results than applying MEDIAN to the same data coming from other data source types.