Aggregate FunctionsStatistical
avg
Calculates the average of values in the group.
Syntax
avg(val)Parameters
Prop
Type
Returns: real
Syntax
avg(val)Parameters
Prop
Type
Returns: timespan
Syntax
avg(val)Parameters
Prop
Type
Returns: datetime
Examples
Example 1 — Average voyages per clan
datatable(clan:string, warrior:string, voyages:long)[
"Lothbrok", "Ragnar", 42,
"Lothbrok", "Bjorn", 31,
"Fairhair", "Harald", 25,
"Fairhair", "Halfdan", 12
]
| summarize avg(voyages) by clan| clan (string) | avg_voyages (real) |
|---|---|
| Fairhair | 18.5 |
| Lothbrok | 36.5 |
Example 2 — Average across real values
datatable(ship:string, speed:real)[
"Naglfar", 8.5,
"Wave Rider", 12.3,
"Storm Bear", 6.7
]
| summarize avg(speed)| avg_speed (real) |
|---|
| 9.166666666666666 |