ES|QL MEDIAN function
number-
Expression that outputs values to calculate the median of.
The value that is greater than half of all values and less than half of all values, also known as the 50% PERCENTILE.
Note
Like PERCENTILE, MEDIAN is usually approximate.
| number | result |
|---|---|
| double | double |
| exponential_histogram
|
double |
| integer | double |
| long | double |
| tdigest
|
double |
FROM employees
| STATS MEDIAN(salary), PERCENTILE(salary, 50)
| MEDIAN(salary):double | PERCENTILE(salary, 50):double |
|---|---|
| 47003 | 47003 |
The expression can use inline functions. For example, to calculate the median of the maximum values of a multivalued column, first use MV_MAX to get the maximum value per row, and use the result with the MEDIAN function
FROM employees
| STATS median_max_salary_change = MEDIAN(MV_MAX(salary_change))
| median_max_salary_change:double |
|---|
| 7.69 |
Warning
MEDIAN is also non-deterministic.
This means you can get slightly different results using the same data.