Aggregate FunctionsPercentile & Sketch
tdigest
Creates a T-Digest sketch from numeric values.
Syntax
tdigest(expr)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
datatable(route:string, crossing_hours:real)[
"North Sea", 48.0,
"North Sea", 72.0,
"Baltic", 36.5,
"Baltic", 55.0
]
| summarize tdigest(crossing_hours) by route| route (string) | tdigest_crossing_hours (dynamic) |
|---|---|
| Baltic | {"gamma":1.02020202020202,"max":55.0,"max_num_bins":2048,"min":36.5,"min_value":0.000000001,"negative_store":{"bin_limit":2048,"bins":[],"count":0,"max_key":-2147483648,"min_key":2147483647,"offset":0},"store":{"bin_limit":2048,"bins":[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"count":2,"max_key":1238,"min_key":1217,"offset":1217},"sum":91.5,"zero_count":0} |
| North Sea | {"gamma":1.02020202020202,"max":72.0,"max_num_bins":2048,"min":48.0,"min_value":0.000000001,"negative_store":{"bin_limit":2048,"bins":[],"count":0,"max_key":-2147483648,"min_key":2147483647,"offset":0},"store":{"bin_limit":2048,"bins":[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"count":2,"max_key":1251,"min_key":1231,"offset":1231},"sum":120.0,"zero_count":0} |