Count by group

The Count by group step counts the number of rows that exist for each unique value in one or more columns. This step is similar to the COUNTIF function in Excel.

Input/output

Our input data is a list of Sales.

We want to know how many sales we have available at different product. After connecting the data to this step and setting it up, it gives us the output data of the unique product name per number of time sold.

Settings

This step will count every row as unique and display a "Count Products" column with the same value as the number of rows in your input table.

To customize these settings, you'll first Pick the dataset, then specify a column or multiple columns you'd like to count unique values for. Then, you'll provide a name for that new column that will display the count of unique values. In the example above, we wanted to count unique product name per number of time sold, so we specified ProductName in the Group by column(s) and named the new column "Count Products".

We can add multiple columns if we want to count unique values for the combinations of those column values.