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

• Calculated fields
• Looker Studio function list