Scalar FunctionsOther Functions

percentile_tdigest

Calculate the percentile from a t-digest representation.

Syntax

percentile_tdigest(tdigest, percentile)

Prop

Type

Returns: real

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

dcount_hll

Calculate the distinct count from an HLL representation.

row_number

Returns the current row number in the serialized row set.