count() (aggregation function)

Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Counts the number of records per summarization group, or total if summarization is done without grouping.

To only count records for which a predicate returns true, use countif().

Note

This function is used in conjunction with the summarize operator.

Syntax

count()

Returns a count of the records per summarization group, or in total if summarization is done without grouping.

The following example returns a count of events in states:

StormEvents
| summarize Count=count() by State

Output