Are you wondering How to create Sets in Tableau? Sure! You will get the answer in this blog. Tableau is one of the popular data visualization tools used to analyze data. This tool allows you to see analyses in visual form. In this blog post, you can find what is set in Tableau, how to create sets in Tableau, how to use sets, and many more in detail. The step-by-step procedure discussed in the blog will help you create sets in Tableau easily.
Before jumping into Tableau sets and creating sets, we will briefly go through what Tableau is and why it is.
Tableau is one of the popular data visualization tools widely used by data scientists and analysts. It is an easy-to-use tool with which we can convert raw data into valuable visuals. Using this tool, we can analyze the raw data and create charts, diagrams, and maps. As a result, you can closely track your business processes and identify patterns in customer behavior.
Tableau provides an interactive dashboard where we can view the visuals of data analyses. Besides, we can get the analyses in the report format as workbooks.
No programming knowledge or any specific expertise is required to use this tool. The important thing is that we can easily install Tableau on any device in no time. Not only that, Tableau is one of the highly secure applications.
Moreover, we can create sets in Tableau. A set is nothing but a selected list of members. A set is made based on the conditions defined by users.
In this article, we will look into what is set in Tableau, how to create sets in Tableau, what set actions are, combining sets, and much more in detail.
|How to Create Sets in Tableau - Table of Contents|
In its basic form, sets in Tableau are nothing but data subsets created based on conditions. In other words, sets are custom fields, and we use conditions to select the members of a set. The main thing about a set is that users can decide the members of a set by defining conditions. Apart from using conditions, we can use filters to include members in a set.
Generally, sets are dynamic as well as interactive. We can compare two sets and form a new set. ‘Set Actions’ is one of the critical features of Tableau that support users to interact effectively with the dashboard. ‘Set Control’ is another vital feature of Tableau that we can use to change the members of a set.
There are two types of sets in Tableau
In this type, changes in the underlying data change the members of a set. Dynamic sets are usually created based on a single dimension of the data.
In this type, changes in the underlying data don’t change the members of a set. Besides, it is based on both a single dimension as well as many dimensions of the data.
|If you want to enrich your career and become a professional in Tableau, then enroll in "Tableau Training" - This course will help you to achieve excellence in this domain.|
Tableau allows you to add or delete data points from a set. As you know, Tableau enables users to create sets based on their requirements. We can create either a dynamic set or a fixed set.
Now, let’s go through the procedure on how to create sets in Tableau step by step and how to add/delete data points in the following.
You must follow the following steps to create a dynamic set in Tableau.
1. First, right-click a dimension in the data pane, and then choose ‘create’ and ‘set’.
2. Now, you will see the opening of the ‘create set’ dialog box. In this box, you will configure the set.
3. This dialog box contains three tabs: General, Top, and Condition.
4. Now, click the ‘General’ tab and click ‘Select from list’ to select specific members from a list.
5. To select all members of a list, click the ‘Use all’ button under the ‘General’ tab.
6. To select members of a set based on conditions, use the ‘Condition’ tab to select members from a list.
7. You can use the ‘Top’ tab to fix limits to the set. For example, if you want to add just five members to the set, then you can enter as 5 using the ‘Top’ tab.
8. Finally, click the ‘OK’ button to complete creating a dynamic set.
You must follow the following steps to create a Fixed Set in Tableau.
1. First, select more than one mark in the Tableau visualization.
2. Then, right-click on any one of the chosen marks and then select the ‘Create Set’ option.
3. A dialog box will open where you can enter a name for the fixed set
4. After that, use the ‘exclude’ option to add the non-selected members to the set and then remove the selected members,
5. You need to click the ‘x‘ icon to remove any dimension.
6. If you don’t want to add rows to the set, you can remove the rows.
7. Suppose there is more than one dimension, you can separate members by entering characters of choice.
8. Now, select ‘Add to filters shelf’ to move the set to the ‘filters shelf automatically'.
9. Finally, click the ‘OK’ button to complete creating a fixed set.
So far, we have gone through how to create sets in Tableau. Next, we will see how to add or remove data points from sets.
If a set is made using data points, then you can add more data to the set. Similarly, you can subtract data from the set.
1. In the Tableau visualization, find the data that you want to add or remove
2. Now, you can see that the ‘tooltip’ opens. Once it is opened, click the drop-down menu.
3. Finally, choose ‘Add to’ if you want to add the data to a set. Or else, choose ‘Remove from’ to remove the data from a set.
Once the set is created, you can see the set in the ‘sets section’ at the bottom of the data pane. Tableau allows dragging sets into the visualization. So you can view the members of the set. Or, you can aggregate the members based on the ‘In’ and ‘Out’ categories.
It is essential to note that ‘In’ is the list of members of a set, and ‘Out’ is the list of members that are not part of the set. Tableau aggregates only the members of a set into ‘In’ and ‘Out’ categories.
[ Related Article: What is Data Visualization?]
When you drag a set into the visualization on the Tableau Desktop, it shows the set members in the ‘In’ and ‘Out’ modes. This mode supports comparing members in a set with others.
If you want to show the ‘In’ and ‘Out’ members of a set in the visualization, we can perform the following steps.
Alternatively, you have another option available on the Tableau desktop to list the members of a set. To do so, you must right-click the set and then choose ‘show members in set’.
Tableau Desktop offers an excellent feature, 'Set actions', to its users. ‘Set actions’ allow users to control the Tableau visualization. By doing this, users can perform analyses as per their demands. Also, you can update the values in a set using set actions. Note that you can create ‘Set actions’ in any platform, whether it is Tableau Desktop, Tableau Cloud, or Tableau Server.
1. In Tableau Desktop, choose the dashboard and then open ‘Actions’
2. Similarly, find the ‘Workbook’ and then open ‘Actions’
3. After that, click the ‘Add Action’ button in the ‘Actions’ dialog box. Then, you can select the ‘Change set values’.
4. The ‘Add set action’ dialog box will open. Now you can provide a name for the ‘Action’.
5. After that, you can select a data source. Note that when you select a data source, you need to choose an individual sheet from the dialog box.
6. Next, you need to select how users need to run the ‘Actions’ whether to ‘hover’ or ‘use the menu’ or ‘select’.
7. Now, you can select the data set from the data source
8. And specify the ‘Actions’ that need to be done when they are running
9. You can perform the actions such as ‘Assign values to set’, ‘Remove values from the set’ or ‘Add values to set’
10. You also need to specify what needs to be done when the selected data set is cleared.
11. You can perform the actions such as 'Keep set values', 'Add all values to set', or 'Remove all values from the set'.
12. Save the changes by clicking the ‘OK’ button. So you can return to the view section.
13. Finally, interact with the Tableau Desktop visualization. So, you can test the performance of ‘Set Actions’.
Following are the areas where you can use ‘Set actions’ widely.
1. Proportional Brushing
2. Asymmetric drill down
3. Color Scaling
Tableau allows combining two sets. It means that we can combine the members of two sets.
Know that we can combine sets in many ways. For example, we can combine two sets by creating a new set where you can list all the members of the two sets. Similarly, we can combine two sets by creating a new set where we can list all the members that are common to the two sets.
The question is, why do we must combine sets?
The answer is simple. By combining two sets, we can quickly solve complex problems in data analysis. For instance, consider two sets of customers who purchased products in the current and last years. If we want to list only the customers who bought products in both years, then we can combine the two sets with the condition. As a result, the new set will contain the list of customers who purchased products in the two years.
It is essential to note that we can only combine sets based on the exact dimensions. For example, we can combine a product set only with another. Similarly, we can combine a customer set only with another customer set. Note that we cannot combine a customer set with a product set.
To combine two sets, we can follow the procedures below.
Let’s list out the applications of Tableau sets in the following.
We usually create sets to build the subsets of data. We can achieve this with the help of conditions or filters. Once it is created, you can use the sets to analyze the data in multiple ways.
If we use the Tableau Dashboard, we establish set actions on the dashboard. If we use the Tableau Workbook, we select set actions in the worksheet. After that, we will configure values to complete creating set actions.
Sets in Tableau is the data subset built based on the conditions. The conditions are usually defined by users. Another one, groups, only include members of a single dimension.
Parameters in Tableau are nothing but variables such as date, number, etc. Sets are the data subsets created based on conditions.
We can identify sets in the ‘Sets Section’ in the Tableau Desktop. Particularly, we can identify them in the bottom portion of the data pane.
|Related Article: Tableau Interview Questions|
It’s a wrap! This blog might have helped you to set in Tableau the types of sets and their applications in greater detail. You might have understood how to create sets in Tableau as well as how to use sets in a step-by-step procedure. Moreover, this blog has taught you about combining sets in different ways. If you wish to learn more about Tableau, sets, and other concepts, you may enroll in MindMajix Tableau Course and achieve certification.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Tableau Training||Jun 10 to Jun 25|
|Tableau Training||Jun 13 to Jun 28|
|Tableau Training||Jun 17 to Jul 02|
|Tableau Training||Jun 20 to Jul 05|
Madhuri is a Senior Content Creator at MindMajix. She has written about a range of different topics on various technologies, which include, Splunk, Tensorflow, Selenium, and CEH. She spends most of her time researching on technology, and startups. Connect with her via LinkedIn and Twitter .
Copyright © 2013 - 2023 MindMajix Technologies