The summarize tool allows you to perform a range of summary calculations such as grouping, summing count and string concatenation. In this example, we'll calculate the total number of employees per department. As per the illustration on our slide. The first picture shows our employee data set. The second shows our workflow when we add the summarize tool, and the third shows the total count of each employee per department. Let's start a new workflow and import our 5.1 spreadsheet.

We'll go to the Insert tab, drag in the input data tool and connect to 5.1. Summarize. In here, again, we have our employee details and which department they belong to. So we'll now go to the transform tab and drag in the summarize tool and in the configuration pane on the left side From the top, we have the option here of adding fields to summarize. So since we want to count the employees by department, let's start by grouping them by department ID. So we'll select department ID here at the bottom, click on group by in the middle.

And next we want to count the number of employees. For this, we can select any column to count since all our fields have been populated, but logically, we use employee ID. So again, we'll click on that, click on the button in the middle and select count. Let's go back to our workflow and add a browse tool with Ctrl Shift B, and then run our workflow with Ctrl R. As you can see in the results pane, we have now summarize our data which shows the total number of employees by department ID