stdev() (aggregation function)
Null values are ignored and don't factor into the calculation.
For a large dataset that is representative of the population, use stdevp() (aggregation function).
This function is used in conjunction with the summarize operator.
This function uses the following formula.
Learn more about syntax conventions.
|expr||string||✓||The expression used for the standard deviation aggregation calculation.|
Returns the standard deviation value of expr across the group.
The following example shows the standard deviation for the group.
range x from 1 to 5 step 1 | summarize make_list(x), stdev(x)
|[ 1, 2, 3, 4, 5]||1.58113883008419|