percentile_array_tdigest()
Calculates the percentile result from the tdigest results (which was generated by tdigest() or tdigest_merge())
Syntax
percentiles_array_tdigest(Expr, Percentile1 [, Percentile2] ...[, PercentileN])
percentiles_array_tdigest(Expr, Dynamic array)
Arguments
- Expr: Expression that was generated by
tdigestor tdigest_merge(). - Percentile is a double constant that specifies the percentile.
- Dynamic array: list of percentiles in a dynamic array of integer or floating point numbers.
- typeLiteral: An optional type literal (for example,
typeof(long)). If provided, the result set will be of this type.
Returns
The percentile/percentiles value of each value in Expr.
Tips
The function must receive at least one percent (and maybe more, see the syntax above: Percentile1 [
,Percentile2] ...[,PercentileN]) and the result will be a dynamic array that includes the results. (such likepercentiles())If only one percent was provided, and the type was provided also, then the result will be a column of the same type provided with the results of that percent. In this case, all
tdigestfunctions must be of that type.If
Exprincludestdigestfunctions of different types, don't provide the type. The result will be of type dynamic. See below examples.
Examples
StormEvents
| summarize tdigestRes = tdigest(DamageProperty) by State
| project percentiles_array_tdigest(tdigestRes, range(0, 100, 50), typeof(int))
| percentile_tdigest_tdigestRes |
|---|
| [0,0,0] |
| [0,0,62000000] |
| [0,0,110000000] |
| [0,0,1200000] |
| [0,0,250000] |