Monthly Report from an Apify Dataset - Date Bucket Group By

Created by

Adam Pearce

Actor

Dataset Aggregate, Group By & Pivot

Turn any dataset with a date field into a month-by-month (or day, week, quarter, year) summary: counts and sums per period, sorted, with CSV export.

Try for free

Dataset Aggregate, Group By & Pivotnerolabs/dataset-aggregate-pivot

Region

Orders

Total amount

Avg amount

Input

Data (inline)

orderId:1001+7

region:North+7

product:Widget+7

amount:$1,200.00+7

orderedAt:2026-07-03+7

Date bucket field (optional):orderedAt

Date bucket size:month

Aggregations

function:count+1

alias:orders+1

Sort by column:orderedAt_month

Export file formats:csv

Output fields

Region

Orders

Total amount

Avg amount

How it works

Sign up on Apify or log in

The Dataset Aggregate, Group By & Pivot Actor is ready to run with the inputs already set for "Monthly Report from an Apify Dataset - Date Bucket Group By". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Monthly Report from an Apify Dataset - Date Bucket Group By" task

The Dataset Aggregate, Group By & Pivot Actor will start running based on the input automatically. You can also change all the input fields, like data (inline), date bucket field (optional), and more, to match your specific use case.

Receive the "Monthly Report from an Apify Dataset - Date Bucket Group By" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as region, orders, total amount, and more.