Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this article
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns statistics for a series in a dynamic object.
series_stats_dynamic(
series [,
ignore_nonfinite ])
Learn more about syntax conventions.
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. |
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.
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} |