variance() (aggregation function)
Calculates the variance of expr across the group, considering the group as a sample.
Null values are ignored and don't factor into the calculation.
The following formula is used:
This function is used in conjunction with the summarize operator.
Learn more about syntax conventions.
|expr||real||✓||The expression used for the variance calculation.|
Returns the variance value of expr across the group.
range x from 1 to 5 step 1 | summarize make_list(x), variance(x)
|[ 1, 2, 3, 4, 5]||2.5|