Sets are, in a sense, the opposite of groups. We use them to slice our data: subset our data based on a condition, and explore it on a more granular level. In the following recipe, we will create a set that makes a distinction between years that had above average employment, and years that had below average employment.
Creating and using sets
Getting ready
Connect to the Unemployment_rates_1990-2016.csv dataset, and open a blank worksheet.
How to do it...
- Right-click on the Year field under Dimensions.
- In the drop-down menu, navigate to Create | Set… as shown in...