EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Sets in Tableau
Secondary Sidebar
Tableau Tutorial
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Interview Questions
    • Tableau Interview Questions

Sets in Tableau

By Priya PedamkarPriya Pedamkar

sets in tableau

Introduction to Sets in Tableau

In Tableau, when we intend to group certain dimension values in the context of a particular problem, we use the concept of Sets. The concept of Sets allows us to drive analysis by creating meaningful groups that actually conveys us some actionable insights. Some of the common examples are: Sales professionals want to identify which are the best and the worst-performing regions. Supply chain teams in retail are always concerned about and need to keep track of the highest and lowest selling products in order to make efficient inventory planning. So through visual analytics using sets, we can accomplish this.

How to Create and Use Sets in Tableau?

In the following section, we are going to see how sets are created in Tableau. For this demonstration, we are going to use Regional Sales dataset. It contains sales for various sales units across India. Sales Unit is an important dimension while Sales is the measure that we are going to use in our analysis.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Let us proceed to understand the step-by-step procedure to create sets in Tableau:

Step 1: Load the Regional Sales dataset into Tableau. For that click on “New Data Source” under the Data menu. Alternatively, click on “Connect to Data”.

New Data Source

Step 2: Select the requisite data source type from the section that pops-up. In this case, it is an MS Excel file. So we selected Microsoft Excel.

selected Microsoft Excel

Step 3: We can see the loaded data into the “Data Source” tab. Examine the data prior to proceeding to the analysis. This is important to ensure that data is intact and doesn’t impact the analysis.

Data Source

Step 4: Moving to the sheet tab, we can find the dimensions and the measures present in the requisite sections.

Sets in Tableau

Step 5: As a first step, we brought dimensions Sales unit into the Columns region and measure Sales into Rows region. These steps generated a vertical graph as shown below.

Sales unit

Step 6: Now, we intend to visualize Sales Units in the West region separately. The Sales Units that belong to the West region are Ahmedabad, Mumbai, Nasik, Pune, Surat, and Rajkot. We may separate them from the Set in the analysis. So, we will create a set of these cities belonging to the West region. Let’s see how this is done.

Step 7: Click on the drop-down menu of the dimension Sales Unit. In “Create”, select “Set” and click over it. This is as illustrated in the below screenshot.

drop-down menu

Step 8: Following the above steps generates the “Create Set” dialogue box as shown in the below screenshot. As we can see there are various options. Let’s explore them one-by-one. First, in the “General” tab, we can select the desired dimension values to form a set. We intend to have a set of cities representing the West region, so as can be seen in the dialogue box, in the “General” tab, we selected all such cities. Finally, Click on OK to generate the set.

Create Set

Step 9: We named the set as “West”, and it can be seen under the “Sets” section in the below screenshot.

West

Step 10: Now, we brought the newly created set “West” into columns region. As shown in the below screenshot, the set appears in IN/OUT form. This essentially means that the set has been considered as IN while OUT represents those not in the set. This is how we can separate certain dimension values of our interest from other dimension values.

Sets in Tableau

Step 11: We can make the dimension values in the set visible. For that just click on the drop-down menu of the Set variable, and click on the “Show Members in Set” option. This is as illustrated in the below screenshot.

Sets in Tableau

Step 12: As we can be seen in the below screenshot, now, cities in the West only appear in the visualization.

Sets in Tableau

Step 13: In the above part, we created a simple set. However, in real life, we may require to create sets based on certain conditions. For that in the “Create Set” dialogue box, in the “Condition” tab, select the “By field” section. In this section, we will try to obtain those sales units where the sale is greater than 100,000. This is illustrated as follows.

Sets in Tableau

Step 14: We named this set “Very High Sales” as can be seen in the Sets section. We brought it into the analysis which is as shown by the following screenshot which shows the set in the form of IN/OUT. Then using the approach described in the preceding part, we brought the dimension values in the set into the visualization. So, in the screenshot subsequent to the below one, we can find that there are only two regions viz. Mumbai and Nagpur where the Sale is greater than 100,000. This is how we can use sets for quick insight generations.

Sets in Tableau

Sets in Tableau

Step 15: The third option is Top using which we can create sets containing dimension values that have the highest or lowest values of a certain measure. Like in this case, we will create two sets that will contain the top 3 and bottom 3 sales units in terms of sales.

Step 16: In the “By field” section, make the selections as highlighted in the following screenshot.

By field

Step 17: The newly created “Top 3” set can be seen in the Sets section. Just bring it into the Columns region and it appears in IN/OUT form. Using the approach described in the preceding part, show its members in the visualizations. The In/Out, in this case, allows us to understand the top 3 vs other sales unit’s performance.

Sets in Tableau

Step 18: The following screenshot shows the top three performing sales units in terms of sales. These are Mumbai, Nagpur, and Nasik.

Sets in Tableau

Step 19: Now, in order to create a set of bottom 3 performing sales units, make the selections as highlighted in the below screenshot.

Sets in Tableau

Step 20: We can see in the below screenshot, when brought into the analysis, as IN/OUT, Bottom 3 set very well tells that the sales contribution of bottom three sales unit is very negligible.

Sets in Tableau

Step 21: We brought the bottom three sales units into the analysis, which are Jaipur, Varanasi, and Bengaluru. This is as shown below.

Sets in Tableau

Conclusion

A set is a very powerful concept and a useful functionality provided by Tableau. It enables beautiful view-level analysis without actually affecting the original data. Moreover, the functionality of the sets allows the user to compare set vs non-set variables along with analysis of dimension values amongst the set itself.

Recommended Articles

This is a guide to Sets in Tableau. Here we discuss how to create and use sets in Tableau, using the Regional Sales dataset in the step by step manner. You can also go through our other related articles to learn more –

  1. Dashboard in Tableau
  2. Concatenate in Tableau
  3. Tableau Data Sets
  4. Tableau New Features
  5. Tableau Fixed Function | How to Use?
  6. Guide to Custom SQL in Tableau
Popular Course in this category
Tableau Training (8 Courses, 8+ Projects)
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more