series_stats()

Learn how to use the series_stats() function to calculate the statistics for a numerical series using multiple columns.

Returns statistics for a numerical series in a table with a column for each statistic.

Syntax

... | extend ( Name, … ) = series_stats ( series [, ignore_nonfinite] )

Name	Type	Required	Description
Name	`string`		The column labels for the output table. If not provided, the system will generate them. If you provide a limited number of names, the table will show only those columns.
series	`dynamic`	✔️	An array of numeric values.
ignore_nonfinite	`bool`		Determines if the calculation includes non-finite values like `null`, `NaN`, `inf`, and so on. The default is `false`, which will result in `null` if non-finite values are present.

A table with a column for each of the statistics displayed in the following table.

Statistic	Description
`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.

print x=dynamic([23, 46, 23, 87, 4, 8, 3, 75, 2, 56, 13, 75, 32, 16, 29]) 
| project series_stats(x)

Output

series_stats_x_min	series_stats_x_min_idx	series_stats_x_max	series_stats_x_max_idx	series_stats_x_avg	series_stats_x_stdev	series_stats_x_variance
2	8	87	3	32.8	28.5036338535483	812.457142857143

Was this page helpful?

Sorry to hear that. Please tell us how we can improve.