Sets are Boolean fields that classify dimension members as either In or Out. The ability to isolate dimension members into sets allows the author to treat them in different ways. This chapter shows you two ways to make sets. You’ll then learn how to use them as a filter, as a dimension, within calculated fields, and as a highlighter.
How to Create Sets
For a use case, let’s return to the scatter plot created in Chapter 9 that revealed we have 10 states that are generating below $0 in average profit. We can use sets to isolate these dimension members for further investigation.
In Figure 13-1, I have returned to the scatter plot worksheet, this time changing the mark type to Circle instead of Shape and began creating a set. The easiest way to create a set is to draw a box around any dimension members on a chart, hover over any of the selected dimension members, click the Set icon, and choose Create Set.
This will open a dialog where you can give the set a name and refine the dimension members included (or optionally excluded) in the set, as shown in Figure 13-2.
Figure 13-1. Creating a static set
Figure 13-2. Create Set dialog
After clicking the OK button, you will see a new field appear along with other dimensions on the Data pane. If you are using a version of ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
