How it works...

In this recipe, we have created a set based on a condition: the value of Employment. We have set the condition so that all the data points that have the value of Employment equal to or higher than 297027 (which is the average value of Employment across the entire dataset) are included in the set, and all the other data points are excluded from it. This created a new field—our set, which we then used in the visualization. The set field now works as a discrete dimension with two values: In and Out that denote the data points that are in/out of the set. We used these values in our visualization to color the year with average or above average employment.

If you want the set members to appear in your visualization, right-click on the Set pill that you have included in your view, and in the drop-down menu switch from Show In/Out of Set to Show Members in Set.