Aggregate FunctionsStatistical
stdevif
Calculates the sample standard deviation of values for which the predicate is true.
Syntax
stdevif(val, predicate)Parameters
Prop
Type
Returns: real
Examples
Example 1
datatable(warrior:string, voyages:long, elite:bool)[
"Ragnar", 42, true,
"Bjorn", 31, true,
"Floki", 12, false,
"Ivar", 35, true,
"Harald", 25, false
]
| summarize stdevif(voyages, elite)| stdevif_voyages (real) |
|---|
| 5.5677643628300215 |