Reference

Groupby

The groupby pipe helps organize data in groups and calculate aggregate statistics for those groups.

Updated 2026-08-17


Groupby

The groupby pipe will help you organize data in groups and calculate some kind of aggregate statistics for these mentioned groups. It basically groups rows with the same value into one group or bucket. Let's see how it works.

The following syntax shows the position of the Groupby Clause in a query.

stream=firewall | groupby dstcn

The above query will group the results as per destination country for each event where the stream is firewall as shown below:

Related

Was this page helpful?

We use cookies to provide essential site functionality and, with your consent, to analyze site usage and enhance your experience. View our Privacy Policy