Scalar FunctionsOther Functions
percentile_tdigest
Calculate the percentile from a t-digest representation.
Syntax
percentile_tdigest(tdigest, percentile)Parameters
Prop
Type
Returns: real
Examples
Example 1
datatable(raid_loot:real)[
10.0,
25.0,
50.0,
75.0,
100.0
]
| summarize sketch = tdigest(raid_loot)
| project percentile_tdigest(sketch, 50)| percentile_tdigest_sketch (real) |
|---|
| 50.91619319361955 |
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.
row_number
Returns the current row number in the serialized row set.