variance() (aggregation function)

Applies to: ✅ Microsoft Fabric ✅ 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:

Image showing a variance sample formula.

Note

This function is used in conjunction with the summarize operator.

Syntax

variance(expr)

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

Var den här sidan till hjälp?