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

Related resources

• Calculated fields
• Looker Studio function list