← All features

Canvas nodes

Aggregate

Group rows by category and calculate summaries.

How it works

Choose one or more grouping columns and add calculations such as sum, average, or count. Each group becomes one summary row.

Click Aggregate on Canvas to open its settings and output. The output totals Amount by Region.

Simple example

Connect an orders table to Aggregate. In Group by, select Region, then add Sum as the measure for Amount. The output has one row per region with its total order amount.

Aggregate selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDRegionAmountStatusCustomer IDReference
A101West140ShippedC1Retail
A102East85PendingC2Outlet
A103West220ShippedC3Retail
A104North38CancelledC9Retail
A105East126ShippedC2Outlet

Node output

3 rows
Regionsum_Amount
West459
East211
North38

Complex workflow

Use Date Bucket to add Order Month to the orders table. Group by Order Month and Region in Aggregate, then add Sum of Amount, Average of Amount, and Count as measures. Send the monthly totals, average order amounts, and order counts to a dashboard or export.

Aggregate selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDRegionAmountStatusReferenceOrder Month
A101West140ShippedRetail2026-10
A102East85PendingOutlet2026-10
A103West220ShippedRetail2026-11
A104North38CancelledRetail2026-11
A105East126ShippedOutlet2026-11

Node output

5 rows
Order MonthRegionsum_Amountavg_Amountcount_rows
2026-10West1401401
2026-10East85851
2026-11West319159.52
2026-11North38381
2026-11East1261261

Related research