series_stats_dynamic()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns statistics for a series in a dynamic object.
Syntax
series_stats_dynamic(series [, ignore_nonfinite ])
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| series | dynamic |
✔️ | An array of numeric values. |
| ignore_nonfinite | bool |
Indicates whether to calculate the statistics while ignoring non-finite values, such as null, NaN, inf, and so on. The default is false, which returns null if non-finite values are present in the array. |
Returns
A dynamic property bag object with the following content:
min: The minimum value in the input array.min_idx: The first position of the minimum value in the input array.max: The maximum value in the input array.max_idx: The first position of the maximum value in the input array.avg: The average value of the input array.variance: The sample variance of input array.stdev: The sample standard deviation of the input array.sum: The sum of the values in the input array.len: The length of the input array.
Example
print x=dynamic([23, 46, 23, 87, 4, 8, 3, 75, 2, 56, 13, 75, 32, 16, 29])
| project stats=series_stats_dynamic(x)
Output
| stats |
|---|
| {"min": 2.0, "min_idx": 8, "max": 87.0, "max_idx": 3, "avg": 32.8, "stdev": 28.503633853548269, "variance": 812.45714285714291, "sum": 492.0, "len": 15} |
The following query creates a series of the average taxi fare per minute, and then calculates statistics on these average fares:
nyc_taxi
| make-series Series=avg(fare_amount) on pickup_datetime step 1min
| project Stats=series_stats_dynamic(Series)
Output
| Stats |
|---|
| {"min":0,"min_idx":96600,"max":"31.779069767441861","max_idx":481260,"avg":"13.062685479531414","stdev":"1.7730590207741219","variance":"3.1437382911484884","sum":"6865747.488041711","len":525600} |