View Navigation
Product Overview
Account Overview
Integrations
Transforms
Security
Transforms   ->

Find minimum by group

The Find minimum by group step calculates the minimum value in a column or a group of columns. This step is similar to the MIN function in Excel.

Input/output

Our input data is order information showing us the quantity sold, the food type, the customer username, and their payment type.

After connecting it into this step, our output data is a column called "Quantity Sold (min)" showing the minimum quantity sold per food type.

Custom settings

First, connect your most recent flow step to it.

Then, select the column (data type) you'd like to find the minimum value in by going under Find the minimum value in... and clicking on select from menu. If preferred, you can leave the second settings blank to find the minimum across the entire table.

After that, select the column(s) with the data type group(s) that you'd like to identify these minimum values by. You'd do this by going under Create a new row for each unique value... and clicking select from menu. Save your selection by clicking Show Updated Results.

When choosing columns, you can pick the exact columns to operate on, or you can use the all columns except option to specify that you want to exclude certain columns from this operation.

You're now done setting up this step! Your columns will be grouped as instructed and the value you wanted to calculate will have "(min)" appended to its column header.