otel_histogram_percentile
Extract a percentile from a merged OpenTelemetry histogram (output of otel_histogram_merge). Returns NaN for null, empty, or invalid histogram input, and for percentile values outside 0-100. For explicit histograms, uses linear interpolation within the target bucket. For exponential histograms, uses the geometric midpoint of the target bucket.
Syntax
otel_histogram_percentile(histogram, percentile)Parameters
Prop
Type
Returns: real
Examples
Example 1
OtelMetrics
| where metric_type == "histogram" and metric_name == "http.request.duration"
| summarize merged = otel_histogram_merge($raw) by bin(timestamp, 1h)
| project otel_histogram_percentile(merged, 50)| otel_histogram_percentile_merged (real) |
|---|
| 83.55263157894737 |
next
Returns the value of a column from a row at a given offset after the current row in a serialized row set. A row set is serialized by the sort, top, top-hitters, or serialize operators; order-preserving operators (extend, project, where, ...) keep that property. Only valid in a serialized context.
percentile_array_tdigest
Extract a dynamic array of percentiles from a sketch aggregate produced