Go to example tasks
Monthly Report from an Apify Dataset - Date Bucket Group By
Created by
Adam Pearce
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.
Dataset Aggregate, Group By & Pivotnerolabs/dataset-aggregate-pivot
Region
Orders
Total amount
Avg amount
TextNumberBooleanListObject
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
Sign up on Apify01
Create your Apify account to access the Dataset Aggregate, Group By & Pivot.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
