agg_avg

The agg_avg function calculates the average (arithmetic mean) of numeric values within each group during aggregation.

Spec

agg_avg(column)

Parameters

column - A numeric column to average.

Return Value

The arithmetic mean as a float64 value.

Example

datatable(Group:string, Score:int64)
[
    "A", 80,
    "A", 90,
    "B", 70,
    "B", 60
]
| summarize agg_avg(Score) by Group

Group	avg_Score
A	85
B	65