count() (aggregation function)

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().

Syntax

count()

Returns

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

Example

The following example returns a count of events in states:

StormEvents
| summarize Count=count() by State

Output

Related content

• Aggregation function types at a glance
• countof()
• countif() (aggregation function)
• count_distinct() (aggregation function)
• bin_at()