Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Calculates the standard deviation of expr in records for which predicate evaluates to true.
Null values are ignored and don't factor into the calculation.
Note
This function is used in conjunction with the summarize operator.
stdevif(expr,predicate)
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| expr | string |
✔️ | The expression used for the standards deviation aggregation calculation. |
| predicate | string |
✔️ | The predicate that has to evaluate to true in order for expr to be added to the result. |
Returns the standard deviation value of expr in records for which predicate evaluates to true.
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 |