avgif() (aggregation function)

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

Note

This function is used in conjunction with the summarize operator.

Syntax

avgif (Expr, Predicate)

Name	Type	Required	Description
Expr	string	✓	Expression used for aggregation calculation. Records with `null` values are ignored and not included in the calculation.
Predicate	string	✓	Predicate that if true, the Expr calculated value will be added to the average.

Returns the average value of Expr across the group where Predicate evaluates to true.

This example calculates the average damage by state in cases where there was any damage.

StormEvents
| summarize Averagedamage=tolong(avg( DamageCrops)),AverageWhenDamage=tolong(avgif(DamageCrops,DamageCrops >0)) by State

Results

The results table shown includes only the first 10 rows.