← All features

Canvas nodes

Date Bucket

Group dates by week, month, quarter, or year.

How it works

Choose a date field and a week, month, quarter, or year. The node adds a bucket column that you can use to group rows.

Click Date Bucket on Canvas, then change Bucket in the inspector. Order Month groups the dates by month.

Simple example

Connect orders with an Order Date column and choose Month in Date Bucket. The output adds a month label to each order that you can group on in Aggregate.

Date Bucket 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

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

Complex workflow

Choose Quarter for Order Date and name the new field Reporting Quarter. Group by Reporting Quarter and Region in Aggregate to compare regional results across quarters. The labels include the year, so the same quarter in two different years stays separate.

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

Input

First 5 of 6 rows
Order IDOrder DateRegionAmount
Q1012025-10-18West130
Q1022025-11-06East115
Q1032026-07-11West160
Q1042026-09-08East105
Q1052026-10-12West175

Node output

First 5 of 6 rows
Order IDOrder DateRegionAmountReporting Quarter
Q1012025-10-18West1302025 Q4
Q1022025-11-06East1152025 Q4
Q1032026-07-11West1602026 Q3
Q1042026-09-08East1052026 Q3
Q1052026-10-12West1752026 Q4

Workflow result

First 5 of 6 rows
Reporting QuarterRegionsum_Amount
2025 Q4West130
2025 Q4East115
2026 Q3West160
2026 Q3East105
2026 Q4West175