Group By

Group By

Summarizes the data by one or more column values, and gives a count, sum, average, min, max

Inputs

1 data source

What it does

Summarizes the data by one or more column values. Gives a count, sum, average, min, max, or groups by concat. Works similarly to a pivot table.

Why use it

Use this object similarly to how you would a pivot table. Summarize data by one or more columns, or create groupings according to available unique attributes. When working with large data sets, it can be useful to use this object to peak at a summary of the data.

How to use it

Example

With a list of Sales Records, containing columns: Rep Name, Rep Location, Sale ID, and Sale Price, apply the Group By Object to find the average sales number by region.

Operation: Average. Data Fields: Sale Price Group by Columns: Rep Location

Start automating with Parabola

Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.