ES|QL PERCENTILE_OVER_TIME function
field- the metric field to calculate the value for
percentile-
the percentile value to compute (between 0 and 100)
Calculates the percentile over time of a field.
| field | percentile | result |
|---|---|---|
| double | double | double |
| double | integer | double |
| double | long | double |
| exponential_histogram
|
double | double |
| exponential_histogram
|
integer | double |
| exponential_histogram
|
long | double |
| integer | double | double |
| integer | integer | double |
| integer | long | double |
| long | double | double |
| long | integer | double |
| long | long | double |
| tdigest
|
double | double |
| tdigest
|
integer | double |
| tdigest
|
long | double |
TS k8s
| STATS p95_cost=MAX(PERCENTILE_OVER_TIME(network.cost, 95)), p99_cost=MAX(PERCENTILE_OVER_TIME(network.cost, 99)) BY cluster, time_bucket = TBUCKET(1minute)