Group & Aggregate

Group rows and compute aggregates

What It Does

Group & Aggregate collapses rows into summaries by one or more grouping columns. For each group it computes aggregates like SUM, AVG, COUNT, MIN, MAX over the columns you choose.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Group & Aggregate". It's in the Aggregate group.

Configuration

Field	Type	Required	Description
`Group by`	Multi-select	Yes	Columns to group rows by
`Aggregations`	List	Yes	Source column, function (SUM/AVG/COUNT/MIN/MAX), and output name

SQL generated under the hood

SELECT region, SUM(revenue) AS total_revenue, COUNT(*) AS order_count FROM data GROUP BY region

Try this operation →

Related Operations

Pivot - Pivot table (rows to columns)
Window Function - Rank, row number, lead, lag
Smallest - Get nth smallest value as a column