CYBER MONDAY OFFER: Flat 40% Off with Free Self Learning Course | Use Coupon CYBERMONDAY40

- Tableau Blogs -

What is set in Tableau and When to use Set-in Tableau?

Introduction

In this article, we are going to talk about what a Tableau set is and how to use the Tableau set in a report. We will also talk about the different features we have in the set and what are the differences from a Tableau group. Lastly, we will talk about how you can combine the set and application of Tableau sets. Keep reading to get an insight into the Tableau set and why you should use that while creating a report.

What is a Set in Tableau?

Have you ever thought of comparing and asking insights from a part of your data?

If yes then Tableau set is a perfect answer for you. It is a custom field used to store the subset of data based on some condition. For example, let’s say you have a column called a category. In that column, We have around 20 different categories. Now, if you want to select the column category and you want to make that column subset and want to select only a few or required number of categories, you can accomplish this with the help of a set in Tableau. You can also create a Tableau set in real-time. Create a set by just selecting the member from the list for the view and right-click on it and select to create the set. You will find a separate section that has been created in the data pane with the name sets and inside that, you will be having the set created with the name you have provided while creating the set.

Tableau set helps you and your audience to interact directly with the dashboard oratory on the Tableau Server or Tableau Online. When you select marks in the view, the set action can change the value of the set. Another way to create a set is just by writing the condition for selecting some top-level records or some bottom level records from a given measure or dimension.

The best thing about the set is you can even create a dynamic and interactive with the help of set actions. This helps your audience interact directly with the visualization on the server and do the analysis as per the requirement. In the next section, we will talk about how you can create a dynamic set.

How to create a dynamic Set in Tableau?

Dynamic sets are those sets where the members of the set can change as data changes. The limitation is, you can create a dynamic set based on just a single dimension. To create a dynamic set in Tableau you can follow the below steps-

1. Right-click on any dimension and select create followed by a set

2. You will get a dialogue box there where you can configure yourself. In this dialogue box, you will be having three tabs-
            a. General
            b. Condition
            c. Top

Read: How to create a parameter and use it?

3. In the general tab also, you will be having three radio buttons-
            a. Select from list
            b. Custom value list
            c. Use all

4. All these options work in the same way, a filter works in Tableau. If you are not sure about how a filter works, you can check our previous articles. In the select from the list option, you can select one option on multiple options for all the options. In the case of a custom value list, you can search for the value and select the desired result. While in the last radio button use all, all the options will get by default selected. The best thing about using all radio buttons is, whenever a new record will get added in that column or removed from the column it will get automatically updated. While for the rest of the two options, you will have to update this manually.

5. The next tab is called a condition. Here you can create a set based on the conditions given. By default, none will be selected but if you want to apply some condition based on the field, you can select by a field radio button. Later you can write about your conditions. These conditions may be a total profit greater than 5000 or sales less than 50000 or similar. The best thing is you can even provide the range of the value. For example, if I want only those members in my set where the cells should lie between 10000 to 20000. Then for such cases, you can use a range of values option. If you are not sure what the minimum and maximum value of a particular major is, you can use the Load button to load the minimum and maximum value of that particular measure. At last, if the field option is not working great for your requirement, you are always independent to write your custom code. For that, you can select by a formula radio button. Here, you can write the code in the same way you write a calculated field.

6. The last time on this dialogue box is for the top selection. Again, by default, none will be selected in this tab but if you want to select some top-level members for some bottom level members, you can select by a field radio button. Here, there is a dropdown box which has two values -

           a. Top - if you want to select the top members of that particular dimension based upon some measures you can select top which is the default selection in this dropdown box. For example, if you want to select the top 5 categories based upon the sales you can keep the top option in this dropdown.
           b. Bottom - if you want to select bottom members of that particular dimension based on some major you can select bottom from the dropdown box. For example, if you want to have the bottom 10 members of a given dimension in the set, you can select the bottom from the dropdown and add the conditions further.

Tableau Online Training & Certification

Read: How to Interact with the Content on the Tableau Server?
  • No cost for a Demo Class
  • Industry Expert as your Trainer
  • Available as per your schedule
  • Customer Support Available

In the next dropdown, you need to put how many top-level members for or how many bottom level members you want to select or add into the set. Later you have to select the major name and aggregate functions. For example, if you want to select the top 10 members of the state based on the total sales. This means we are looking for those States where we have got the top 10 sales. In such a case, you need to select top from the first dropdown, need to type, 10 in the second dropdown, sales in the third dropdown, and sum in 4th dropdown.

This way, you will be able to create a set with 10 members and ocean members will be the highest sales state. For that, you can also apply the formula here if the first option is not working for you. Again, you can write the formula the way you write a calculated field.

7. Once done, just click ok and you will find and you said getting created in the sets section. You can use this set anywhere as per your requirement.

Use the Set in the Report

In the last section, we have talked about how you can create. So, once you have created the set, you can use that set in the report. For Example, let’s say you have created a set with some top categories based upon the sales. Now you want to use that set to show the profit. To do that you can, drag that set into the row shelf.

When you will drag the set into the row shelf or into the filter shelf, you will find two options being shown over there-

Read: Introduction to Data Visualization with Tableau
  • In - This contains all the members which are a part of the set. For example, the set shown in the above image contains the top 10 products. There are hundreds of products out of which we have selected 10 products in the set. So, all those 10 products will be the part of in
  • Out - Out of a hundred products we have selected 10 products in the set. Rest all the 90 products will be showing you in the out option.

If you want to see the members of the set just click on the set and select so members in the set -

This way, you can use the set in the report and can get your work done. Apart from using the set in the report, you can also use this as a filter. There can be multiple requirements where you don't want to show all the products in the filter and want to show only 10 or 15 products to the user. Whenever you have this kind of requirement you can create a set and use that set as a filter. Further, you can combine two separate sets as well. To do that, just right click on both the sets and select create a combined set. Resolving the functions will be the same.

Tableau Online Training & Certification

  • Personalized Free Consultation
  • Access to Our Learning Management System
  • Access to Our Course Curriculum
  • Be a Part of Our Free Demo Class

Conclusion

This was all about the set in Tableau. Here, we have talked about what is a set, when to use set, and how to create a set. Later, we have also talked about how to use that set in the report and as a filter. You can try creating the set and let us know if you face any difficulty. 




    Janbask Training

    A dynamic, highly professional, and a global online training course provider committed to propelling the next generation of technology learners with a whole new way of training experience.


Comments

Trending Courses

AWS

  • AWS & Fundamentals of Linux
  • Amazon Simple Storage Service
  • Elastic Compute Cloud
  • Databases Overview & Amazon Route 53

Upcoming Class

2 days 04 Dec 2020

DevOps

  • Intro to DevOps
  • GIT and Maven
  • Jenkins & Ansible
  • Docker and Cloud Computing

Upcoming Class

10 days 12 Dec 2020

Data Science

  • Data Science Introduction
  • Hadoop and Spark Overview
  • Python & Intro to R Programming
  • Machine Learning

Upcoming Class

7 days 09 Dec 2020

Hadoop

  • Architecture, HDFS & MapReduce
  • Unix Shell & Apache Pig Installation
  • HIVE Installation & User-Defined Functions
  • SQOOP & Hbase Installation

Upcoming Class

9 days 11 Dec 2020

Salesforce

  • Salesforce Configuration Introduction
  • Security & Automation Process
  • Sales & Service Cloud
  • Apex Programming, SOQL & SOSL

Upcoming Class

2 days 04 Dec 2020

QA

  • Introduction and Software Testing
  • Software Test Life Cycle
  • Automation Testing and API Testing
  • Selenium framework development using Testing

Upcoming Class

3 days 05 Dec 2020

Business Analyst

  • BA & Stakeholders Overview
  • BPMN, Requirement Elicitation
  • BA Tools & Design Documents
  • Enterprise Analysis, Agile & Scrum

Upcoming Class

2 days 04 Dec 2020

MS SQL Server

  • Introduction & Database Query
  • Programming, Indexes & System Functions
  • SSIS Package Development Procedures
  • SSRS Report Design

Upcoming Class

2 days 04 Dec 2020

Python

  • Features of Python
  • Python Editors and IDEs
  • Data types and Variables
  • Python File Operation

Upcoming Class

-1 day 01 Dec 2020

Artificial Intelligence

  • Components of AI
  • Categories of Machine Learning
  • Recurrent Neural Networks
  • Recurrent Neural Networks

Upcoming Class

3 days 05 Dec 2020

Machine Learning

  • Introduction to Machine Learning & Python
  • Machine Learning: Supervised Learning
  • Machine Learning: Unsupervised Learning

Upcoming Class

18 days 20 Dec 2020

Tableau

  • Introduction to Tableau Desktop
  • Data Transformation Methods
  • Configuring tableau server
  • Integration with R & Hadoop

Upcoming Class

17 days 19 Dec 2020

Search Posts

Reset

Receive Latest Materials and Offers on Tableau Course

Interviews