Skip to main content
The Average by group step calculates the average of all values in one or more columns. This step is similar to the AVERAGEIF function in Excel.

​
Input/output

Our input data has 11 rows of order information showing how much of a particular food item was sold to a given customer.
Input data showing 11 rows of order information with food items and quantities sold per customer
After we run our dataset through the Average by group step, we find the average number of each food item sold per order.
Output data showing the average quantity sold per food item after grouping

​
Default settings

When a data source is first connected, this step will auto-select a numeric column (like ‘Quantity Sold’) and a data-type column to take a first pass at averaging by group.
Default settings panel auto-selecting a numeric column and a grouping column

​
Custom settings

You may choose any column to average, and group the average according to any one column, or multiple columns, in your data set.
Custom settings panel selecting a column to average and one or more columns to group by
You can optionally apply this to only the selected columns or apply to ‘all columns except’. We’d recommend using the option that requires fewer column selections to save yourself time.
Settings panel showing the 'apply to selected columns' versus 'all columns except' toggle
Last modified on June 2, 2026