Aggregate FunctionsPercentile & Sketch
merge_tdigest
Merges multiple T-Digest sketches.
Syntax
merge_tdigest(sketch)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
datatable(crossing_hours:real, route:string)[
48.0, "North Sea",
72.0, "Baltic",
36.5, "North Sea"
]
| summarize sketch = tdigest(crossing_hours) by route
| summarize merge_tdigest(sketch)| merge_tdigest_sketch (dynamic) |
|---|
| {"gamma":1.02020202020202,"max":72.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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"count":3,"max_key":1251,"min_key":1217,"offset":1217},"sum":156.5,"zero_count":0} |