Aggregate FunctionsStatistical
sum
Calculates the sum of values in the group.
Syntax
sum(val)Parameters
Prop
Type
Returns: long
Syntax
sum(val)Parameters
Prop
Type
Returns: long
Syntax
sum(val)Parameters
Prop
Type
Returns: real
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 |