Tableau Sets

Tableau Sets What are Sets in Tableau And How To Create Them Back Home Categories Online Courses Mock Interviews Webinars NEW Community Write for Us Categories Artificial Intelligence AI vs Machine Learning vs Deep LearningMachine Learning AlgorithmsArtificial Intelligence TutorialWhat is Deep LearningDeep Learning TutorialInstall TensorFlowDeep Learning with PythonBackpropagationTensorFlow TutorialConvolutional Neural Network TutorialVIEW ALL BI and Visualization What is TableauTableau TutorialTableau Interview QuestionsWhat is InformaticaInformatica Interview QuestionsPower BI TutorialPower BI Interview QuestionsOLTP vs OLAPQlikView TutorialAdvanced Excel Formulas TutorialVIEW ALL Big Data What is HadoopHadoop ArchitectureHadoop TutorialHadoop Interview QuestionsHadoop EcosystemData Science vs Big Data vs Data AnalyticsWhat is Big DataMapReduce TutorialPig TutorialSpark TutorialSpark Interview QuestionsBig Data TutorialHive TutorialVIEW ALL Blockchain Blockchain TutorialWhat is BlockchainHyperledger FabricWhat Is EthereumEthereum TutorialB lockchain ApplicationsSolidity TutorialBlockchain ProgrammingHow Blockchain WorksVIEW ALL Cloud Computing What is AWSAWS TutorialAWS CertificationAzure Interview QuestionsAzure TutorialWhat Is Cloud ComputingWhat Is SalesforceIoT TutorialSalesforce TutorialSalesforce Interview QuestionsVIEW ALL Cyber Security Cloud SecurityWhat is CryptographyNmap TutorialSQL Injection AttacksHow To Install Kali LinuxHow to become an Ethical Hacker?Footprinting in Ethical HackingNetwork Scanning for Ethical HackingARP SpoofingApplication SecurityVIEW ALL Data Science Python Pandas TutorialWhat is Machine LearningMachine Learning TutorialMachine Learning ProjectsMachine Learning Interview QuestionsWhat Is Data ScienceSAS TutorialR TutorialData Science ProjectsHow to become a data scientistData Science Interview QuestionsData Scientist SalaryVIEW ALL Data Warehousing and ETL What is Data WarehouseDimension Table in Data WarehousingData Warehousing Interview QuestionsData warehouse architectureTalend T utorialTalend ETL ToolTalend Interview QuestionsFact Table and its TypesInformatica TransformationsInformatica TutorialVIEW ALL Databases What is MySQLMySQL Data TypesSQL JoinsSQL Data TypesWhat is MongoDBMongoDB Interview QuestionsMySQL TutorialSQL Interview QuestionsSQL CommandsMySQL Interview QuestionsVIEW ALL DevOps What is DevOpsDevOps vs AgileDevOps ToolsDevOps TutorialHow To Become A DevOps EngineerDevOps Interview QuestionsWhat Is DockerDocker TutorialDocker Interview QuestionsWhat Is ChefWhat Is KubernetesKubernetes TutorialVIEW ALL Front End Web Development What is JavaScript â€" All You Need To Know About JavaScriptJavaScript TutorialJavaScript Interview QuestionsJavaScript FrameworksAngular TutorialAngular Interview QuestionsWhat is REST API?React TutorialReact vs AngularjQuery TutorialNode TutorialReact Interview QuestionsVIEW ALL Mobile Development Android TutorialAndroid Interview QuestionsAndroid ArchitectureAndroid SQLite DatabaseProgramming Data Science... Researc h Analyst, Tech Enthusiast, Currently working on Azure IoT Data Science with previous experience in Data Analytics Business Intelligence. Bookmark 6 / 9 Blog from Understanding Data Visualization with Tableau Become a Certified Professional Wouldnt it be great if you could compare and ask questions to your data? Tableau Sets let your audience interact directly with a visualisation or dashboard to control aspects of their analysis. When you select marks in the view, set actions can change the values in a set.It, hence, makes an integral part of Tableau, and more importantly, of Tableau Training curricula.This article is written with the intention to impart enough information for you, the reader, to be able to start using Tableau sets in no time. Heres an outline;What are Tableau Sets?How to Create Tableau Sets?How To Use Sets in a Visualisation?Set ActionsHow To Combine Sets?Applications of Tableau SetsNow, lets begin by knowing what Tableau Sets exactly are. Shall we?What are T ableau Sets?Tableau Sets are custom fields used to hold the subset of data based on a given condition. In real-time, you can create a set by selecting members from the list or a visualisation. You can also do the same by writing custom Conditions or Selecting Top/Bottom few records in a Measure.How to Create Tableau Sets?Dynamic SetsThe members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.To create a dynamic setNavigate to the Data pane, under Dimensions, right-click a field and selectCreateSet.In the Create Set dialogue box, configure your set. You can configure your set using the following tabs;Use the General tab to select one or more values that will be considered when computing the set.Alternatively, you could even select theUse alloption to always consider all members even when new members are added or removed.Use the Condition tab to define rules that determine what members to include in the set.For example, yo u might specify a condition that is based on total sales that only includes products with sales of over $100,000.Note: Set conditions work the same as filter conditions.Make use of the Top tab to define limits on what members to include in the set. For example, you might specify a limit that is based on total sales that only includes the top 5 products based on their sales.NoteSet limits work the same as Filter limits.When finished, clickOK.The new set is added to the bottom of the Data pane, under the Sets section. A set icon (the two intersecting bubbles)indicates the field is a set.Fixed SetsThe members of a fixed set do not change. A fixed set can be based on a single dimension or multiple dimensions.To create a fixed set;In the visualisation, select one or more marks (or headers) in the view.Right-click the marks and selectCreate Set.In the Create Set dialogue box, type a name for the set.Optionally complete any of the following:By default, the set includes the members listed i n the dialogue box. You can select the option toExcludethese members instead. When you exclude, the set will include all of the members you didnt select.Remove any dimensions that you dont want to be considered by clicking the red x icon that appears when you hover over a column heading.Remove any specific rows that you dont want to include in the set by clicking the red x icon that appears when you hover over the row.If the marks you selected represent multiple dimensions, each member of the set will be a combination of those dimensions. You can specify the character that separates the dimension values. To do so, forSeparate members by, enter a character of your choice.SelectAdd to Filters shelfto automatically move the set to the Filters shelf once it is created.5. When finished, clickOK.Note: If you created a set using specific data points, you can add more data to or subtract data from the set using the tooltip that appears. All you have to do is click the Sets drop-down icon an d select the Add/Remove option.How To Use Sets in a Visualisation?After you create a set, you could see it at the bottom of the Data pane in the Sets section. You can drag it into any visualisation like you would with any other field.When you drag a set to the visualisation into Tableau Desktop, you can choose to show the members of the set or aggregate the members into In/Out categories.In Tableau Server, one can only aggregate the members of the set into In/Out categories.You can use set actions to give your audience more control over their analysis of your visualisation.Set ActionsSet actions take an existing set and update the values contained in that set based on a users action in the visualisation. As the author, you can use a set or sets that you have already created to define the scope of the set action.You could use set actions to let your audience interact directly with your visualisation, even your dashboard. It gives them more control over aspects of their analysis.Now, you can define the set action to include the following:the source sheet or sheets it applies to.the user behaviour that runs the action (hover, select, or menu).the target set (the data source and set to be used).what happens when the selection is cleared.How To Create Set Actions?Go to a worksheet, selectWorksheet Actions. In a dashboard, selectDashboard Actions.In the Actions dialogue box, clickAdd Actionand then selectChange Set Values.Specify a meaningful name for the action in theAdd/Edit Set Actiondialogue box.Select a source sheet or data source. The current sheet is selected by default. If you select a data source or dashboard you can select individual sheets within it.Select how users will run the action.Hover runs when a user hovers the mouse cursor over a mark in the view.Select runs when a user clicks a mark in the view. This option works well for set actions.Menu runs when a user right-clicks a selected mark in the view, then selects an option on the context menu.Specif y the target set. First, select the data source, and then select the set.The sets available in the Target Set lists are determined by the data source that you select and the sets that you have created in the workbook that are associated with that data source.In this example, the target set is usingWorld Cup Squads and Groups Extractas the data source andTeam Setas the set.Specify what happens when the selection is cleared in the view:Keep set values makes current values in the set remain in the set.Add all values to setadds all possible values to the set.Remove all values from the setremoves previously selected values from the set.ClickOKto save your changes and return to the view.Test the set action by interacting with the visualisation. Tweak some of the settings for the action to adjust the selection behaviour as needed.The following examples show just a few of the ways you can use set actions.Proportional BrushingAsymmetric Drill DownsColour ScalingRelative DatesHow To Combine S ets?Combining sets allows you to answer complex questions and compare cohorts of your data. You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.Note: To combine two sets, they must be based on the same dimensions (this means, you can combine a set containing the top customers with another set containing the customers from last year but you cannot combine the top customers set with the top products set).To combine setsIn the Data pane, under Sets, select the two sets you want to combine.Right-click the sets and selectCreate Combined Set.In the Create Set dialogue box, type a name for the new combined set.Verify that the two sets you want to combine are selected in the two drop-down menus.Select one of the following options for how to combine the sets:All Members in Both Sets enablesthe combined set will conta in all of the members from both sets.Shared Members in Both Sets enables the combined set to only contain members that exist in both sets.Except Shared Members enables the combined set to contain all members from the specified set that dont exist in the second set.These options are equivalent to subtracting one set from another. For example, if the first set contains Red, Orange, and Green Marbles and the second set contains Green and Yellow Marbles; combining the first set except the shared members would contain just Red and Orange. The Green Marbles are removed because they exist in the second set.Optionally specify a character that will separate the members if the sets represent multiple dimensions.When finished, clickOK.Applications of Tableau SetsThere are many ways you can use sets to answer complex questions and compare cohorts of data.How do members of a set contribute to the total?You may have all kinds of questions surrounding how the members in a set contribute to the ove rall total. For example, what per cent of total sales come from repeat customers? You can answer these types of questions using the IN/OUT mode for a set.How many members of a set exist in another set?Another common use of sets is to compare subsets of data or cohorts. For example, you may wonder how many customers that purchased last year also purchased this year. Or if a customer purchased a specific product, what other products did they buy? You can answer these types of questions by creating multiple sets and combining them.Hierarchical sets and descendantsA hierarchical set filters data to the selected members and all of their descendants. They are unique to multidimensional (cube) data sources and are defined within the data source prior to connecting to Tableau Desktop.When you create sets in Tableau from a cube data source, descendants and any hierarchical structures are automatically included with the selected members.Sets are dynamic and useful elements for you to add inte ractivity and flexibility to a report. It is a versatile weapon in your arsenal and can be used in calculations and visualisations, equally well!Want to know more about Sets in Tableau? Or maybe other concepts? EdurekasTableau 10 Certification trainingis the one for you. It aligned with the Tableau Qualified Associate Level Examination and specially curated to help analytics and data professionals create insightful visuals, dashboards, perform scripting, and create Network Diagrams on Tableau to present the data in a much better and insightful manner.Recommended videos for you Visual Analytics with Tableau Watch Now Data Visualization-How to Make Sense of Data Watch Now QlikView â€" Whats Your Business Question? Watch Now Introduction to Pentaho BI Watch NowRecommended blogs for you Power BI Desktop: Visualize Data Like Never Before Read Article Needs and Benefits of Data Visualization Read Article OLTP vs OLAP Read Article Step By Step Guide To Learn Tableau Public Read Article Sta rting out with DAX in Power BI Read Article Data Visualization using MS Excel: All you need to know Read Article Tableau Developer Salary : Everything You Need To Know Read Article How To Build Tables Transform Data With Tableau Read Article How do LOD Expressions work in Tableau? Read Article How to Implement Context Filters in Tableau Read Article Why Do You Need Actions In Tableau? Read Article Power BI Developer Salary: Insights and Trends you Need to Know Read Article Tableau Dashboard â€" Redefining Data Visualization Read Article All You Need to Know About Power BI Visuals Read Article Pentaho Tutorial for Beginners Read Article How Much Would You Make As A Tableau Developer? Read Article Understanding Pentaho Architecture Read Article 3 Ways To Use Dual Axes Charts in Tableau Read Article Top Microsoft Business Intelligence Interview Questions To Prepare In 2020 Read Article Do Magic With Tableau! Read Article Comments 0 Comments Trending Courses in BI and Visualization Tableau Training and Certification26k Enrolled LearnersWeekend/WeekdayLive Class Reviews 5 (10300)