Group By and Sum an Apify Dataset - Count, Total, Average

Created by

Adam Pearce

Actor

Dataset Aggregate, Group By & Pivot

Group any scraped dataset by a field and get counts, totals and averages per group, with currency-text prices parsed and a CSV/Excel download.

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

Group by field(s):region

Aggregations

function:count+2

alias:orders+2

Export file formats:csv+1

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 "Group By and Sum an Apify Dataset - Count, Total, Average". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Group By and Sum an Apify Dataset - Count, Total, Average" 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), group by field(s), and more, to match your specific use case.

Receive the "Group By and Sum an Apify Dataset - Count, Total, Average" 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.