ES|QL MV_PERCENTILE function

×

number

Multivalue expression.

percentile

The percentile to calculate. Must be a number between 0 and 100. Numbers out of range will return a null instead.

Converts a multivalued field into a single valued field containing the value at which a certain percentage of observed values occur.

ROW values = [5, 5, 10, 12, 5000]
| EVAL p50 = MV_PERCENTILE(values, 50), median = MV_MEDIAN(values)