Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-02-06 UTC."],[],[]]