Aggregate FunctionsStatistical
count
Returns a count of the records in the input record set.
Syntax
count()Returns: long
Syntax
count(val)Parameters
Prop
Type
Returns: long
Examples
Example 1
datatable(weapon:string, warrior:string)[
"axe", "Ragnar",
"sword", "Bjorn",
"axe", "Ivar",
"spear", "Lagertha",
"axe", "Floki"
]
| summarize count() by weapon| weapon (string) | count_ (long) |
|---|---|
| axe | 3 |
| spear | 1 |
| sword | 1 |
Example 2
datatable(region:string, raid:string)[
"England", "Lindisfarne",
"Francia", "Paris",
"England", "York"
]
| summarize count()| count_ (long) |
|---|
| 3 |