avg() (aggregation function)

Calculates the average (arithmetic mean) of Expr across the group.

Note

This function is used in conjunction with the summarize operator.

Syntax

avg (Expr)

Name	Type	Required	Description
Expr	string	✓	Expression used for aggregation calculation. Records with `null` values are ignored and not included in the calculation.

Returns the average value of Expr across the group.

This example returns the average number of damaged crops per state.

StormEvents
| summarize AvgDamageToCrops = avg(DamageCrops) by State

Results

The results table shown includes only the first 10 rows.