maxif() (aggregation function)
Returns the maximum value across the group for which Predicate evaluates to true.
- Can be used only in context of aggregation inside summarize
See also - max() function, which returns the maximum value across the group without predicate expression.
Syntax
maxif (Expr,Predicate)
Arguments
- Expr: Expression that will be used for aggregation calculation.
- Predicate: predicate that if true, the Expr calculated value will be checked for maximum.
Returns
The maximum value of Expr across the group for which Predicate evaluates to true.
Examples
range x from 1 to 100 step 1
| summarize maxif(x, x < 50)
| maxif_x |
|---|
| 49 |