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
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:
Note
This function is used in conjunction with the summarize operator.
variance(
expr)
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
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)
Output
list_x | variance_x |
---|---|
[ 1, 2, 3, 4, 5] | 2.5 |