count() (aggregation function)
Returns a count of the records per summarization group (or in total, if summarization is done without grouping).
- Can be used only in context of aggregation inside summarize
- Use the countif aggregation function
to count only records for which some predicate returns
true
.
Syntax
count
(
)
Returns
Returns a count of the records per summarization group (or in total, if summarization is done without grouping).
Example
Counting events in states starting with letter W
:
StormEvents
| where State startswith "W"
| summarize Count=count() by State
State | Count |
---|---|
WEST VIRGINIA | 757 |
WYOMING | 396 |
WASHINGTON | 261 |
WISCONSIN | 1850 |