Show Table of Contents
Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view. You can use sets to compare and ask questions about a subset of data. For example, in a scatter plot showing product sales, you may select the products with the most sales and add them to a set. You may then create another set that contains the products with the highest return rates. With these two sets you can ask questions like "What percent of my total sales is from high returned products?" Or you may go further and compare the two sets to each other to create a new set that contains only high sales products that are also returned frequently.
Note: You can view and use sets in Tableau Server and Tableau Online, but you can create and edit sets only in Tableau Desktop.
Tableau displays sets at the bottom of the Data pane and labels them with the set icon .
When you drag a set to the view, members are aggregated in one of the following ways:
In Tableau Desktop, you can choose to aggregate the members using In/Out mode or to list all of the individual members of the set.
In Tableau Server or Tableau Online, members are aggregated using In/Out mode only.
See Using Sets to learn more about these modes.
If you are connected to a multidimensional data source, you may see additional sets that were created in your data source. These sets are also listed in the Sets area of the Data pane but are indicated with the server named set icon . A server named set can be used in the same way as any other sets you create in Tableau.
Sets can be automatically generated as a result of an action. These sets are indicated by the action set icon . See Actions.
Finally, when working with workbooks connected to Tableau Server or Tableau Online, User Filters display in the Sets area of the Data pane using the user filter set icon user. See Restrict Access at the Data Row Level.
If you are connected to a relational data source, creating a set that is based on a continuous date field will use the exact dates instead.