Analysts get a lot of use of group by when aggregating data to derive deeper insights from data. With Data Prep, shaping your data using a group by is very simple.
Consider a dataset, like the one shown below:
The goal is to compute the Sum, Minimum, Maximum, and Average Annual Tax revenue per state, per year.
Use the following steps to compute these four aggregations:
Step 1: Use the Shape tool to invoke the Shaping editor.
Step 2: At the top of the Shaping editor, choose Group By.
Step 4: Save the Data Prep Project
Now that you know how powerful a group by can be, happy data prepping!