Aggregate FunctionsStatistical
sum
Calculates the sum of values in the group.
An integer or timespan total that does not fit in 64 bits wraps around, as long
arithmetic does. Any total that fits is exact, whatever order the rows arrive in.
Syntax
sum(val)Parameters
Prop
Type
Returns: long
Syntax
sum(val)Parameters
Prop
Type
Returns: long
Syntax
sum(val)Parameters
Prop
Type
Returns: real
Syntax
sum(val)Parameters
Prop
Type
Returns: timespan
Examples
Example 1 — Sum long values grouped by region
datatable(region:string, raid:string, silver:long)[
"England", "Lindisfarne", 500,
"Francia", "Paris", 7000,
"England", "York", 1200,
"Francia", "Rouen", 3000
]
| summarize sum(silver) by region| region (string) | sum_silver (long) |
|---|---|
| England | 1700 |
| Francia | 10000 |
Example 2 — Sum real values
datatable(ship:string, speed:real)[
"Naglfar", 8.5,
"Wave Rider", 12.3,
"Storm Bear", 6.7
]
| summarize sum(speed)| sum_speed (real) |
|---|
| 27.5 |
Example 3 — Sum int values
datatable(ship:string, crew:int)[
"Naglfar", int(35),
"Wave Rider", int(28),
"Storm Bear", int(42)
]
| summarize sum(crew)| sum_crew (long) |
|---|
| 105 |