avg() (aggregation function)

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

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`	✔️	The 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

The results table shown includes only the first 10 rows.