Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Help > 
Design Views and Analyze Data > Build Data Views > Sets
Applies to: Tableau Desktop, Tableau Online, Tableau Server

Sets

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:

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.

Create a Set

Use Sets

Combine Sets

Examples of Sets

Create Sets for Top N and Others