stdevif() (aggregation function)

Calculates the stdev of Expr across the group for which Predicate evaluates to true.

  • Can be used only in context of aggregation inside summarize

Syntax

stdevif (Expr, Predicate)

Arguments

  • Expr: Expression that will be used for aggregation calculation.
  • Predicate: predicate that if true, the Expr calculated value will be added to the standard deviation.

Returns

The standard deviation value of Expr across the group where Predicate evaluates to true.

Examples

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

stdevif_x
29.1547594742265