variancep() (aggregation function)

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Calculates the variance of expr across the group, considering the group as a population.

The following formula is used:

Image showing a variance sample formula.

Note

This function is used in conjunction with the summarize operator.

Syntax

variancep(expr)

Learn more about syntax conventions.

Parameters

Name Type Required Description
expr string ✔️ The expression to use for the variance calculation.

Returns

Returns the variance value of expr across the group.

Example

range x from 1 to 5 step 1
| summarize make_list(x), variancep(x) 

Output

list_x variance_x
[ 1, 2, 3, 4, 5] 2