stdevif() (aggregation function)

Learn how to use the stdevif() function to calculate the standard deviation of an expression where the predicate evaluates to true.

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

Syntax

stdevif(expr,predicate)

Parameters

NameTypeRequiredDescription
exprstring✔️The expression used for the standards deviation aggregation calculation.
predicatestring✔️The predicate that has to evaluate to true in order for expr to be added to the result.

Returns

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

Example

The following example shows the standard deviation in a range of 1 to 100.

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

Output

stdevif_x
29.1547594742265