varianceif() (aggregation function)

Learn how to use the varianceif() function to calculate the variance in an expression where the predicate evaluates to true.

Calculates the variance of expr in records for which predicate evaluates to true.

Syntax

varianceif(expr, predicate)

Parameters

NameTypeRequiredDescription
exprstring✔️The expression to use for the variance calculation.
predicatestring✔️If predicate evaluates to true, the expr calculated value will be added to the variance.

Returns

Returns the variance value of expr in records for which predicate evaluates to true.

Example

range x from 1 to 100 step 1
| summarize varianceif(x, x%2 == 0)

Output

varianceif_x
850