Context Filters in Tableau
Meet the Author : Mr. Bharani Kumar
Bharani Kumar Depuru is a well known IT personality from Hyderabad. He is the Founder and Director of AiSPRY and 360DigiTMG. Bharani Kumar is an IIT and ISB alumni with more than 18+ years of experience, he held prominent positions in the IT elites like HSBC, ITC Infotech, Infosys, and Deloitte. He is a prevalent IT consultant specializing in Industrial Revolution 4.0 implementation, Data Analytics practice setup, Artificial Intelligence, Big Data Analytics, Industrial IoT, Business Intelligence and Business Management. Bharani Kumar is also the chief trainer at 360DigiTMG with more than Ten years of experience and has been making the IT transition journey easy for his students. 360DigiTMG is at the forefront of delivering quality education, thereby bridging the gap between academia and industry.
Tableau's Context Filter is the first filter to be applied to a worksheet after any other filters. The data that is obtained by the Context filter will be subject to all other filters because it is an independent filter. This will greatly enhance Tableau's efficiency, particularly when there are several filters set to the worksheet and while working with extremely large amounts of data.
360DigiTMG offers the Best Tableau Training in Hyderabad to start a career in Tableau. Enroll now!
.png)
Let's use an illustration to better grasp this.
The demand is to retrieve the Top 5 Superstore Profitable States for the Region chosen on the active filter.
Steps Involved:
The "Top 5 States" will be updated on the chart.
The "Superstore" data source allows us to view the Top 5 States for the whole dataset. We see that of the "Top 5" States, 2 are from the 'West' area and 1 from each of the other regions.
The "Top 5 States" from the region that is chosen on the Region Filter must, nevertheless, be displayed.
-
Create a Text Table (or any chart of your choice) showing the Profits from different States, nested inside the Region dimension. This way we can see the name of the Region to which the State belongs.
Tableau is a promising career option. Enroll in the Tableau Online Training offered by 360DigiTMG to become a successful Tableau expert.
Show the "Top 5 Profitable" States over here. In order to see just the "Top 5 Customers" by Sum((Profit), construct a Filter on the State dimension.
-
Drag the State field from the Data Pane and place it on the “Filters” Shelf. Go to the “Top” tab on the filters window and set up the condition to fetch “Top 5”.
-
Create an Interactive filter on the Region dimension.
To display the filter, right-click on the "Region" dimension and select the appropriate choice. Remove the "All" option and show the filter as a "Single Value List." On this basis, it is assured that users may only choose one "Region" at a time.
Observe how Tableau displays the state from the Top 5 list that is part of the "Central" Region when the filter option for the region is set to "Central." The 'Top 5 States' from the chosen area must be retrieved and shown on the chart, though.
Become a Tableau expert with 360DigiTMG Best Tableau Training in Bangalore. Get trained by the alumni from IIT, IIM, and ISB.
-
For this, the “Region” filter is supposed to be added to “Context”. By doing so, Region filter will get applied first, Tableau will take the data for that region and apply the “State” filter on that data. Thereby, giving us the Top 5 from the ‘Selected Region’.
-
Click on the drop-down icon on the ‘Region Pill’ present on Filters Shelf and choose the option “Add to Context”.
Being a Tableau expert is just a step away. Check out the Best Tableau Training in Chennai at 360DigiTMG and get certified today.
As the interactive filter is selected for a region, you can see how the text table on the canvas is changed to display the "Top 5 Customer" for that region.
Contextual filters "Add Context" to the data, which will then be subject to all other filters in the worksheet.
From the Tableau Public Software, you can view the worksheet with further examples on Context Filters.
Becoming a Tabeau expert is possible now with the 360DigiTMG Best Tableau Training in Pune Program. Enroll today.
Data Science Placement Success Story
Tableau Training Institutes in Other Locations
Ahmedabad, Aurangabad, Bangalore, Chengalpattu, Chennai, Hyderabad, Kothrud, Noida, Pune, Thane, Yelahanka, Andhra Pradesh, Anna Nagar, Bhilai, Calicut, Chandigarh, Chromepet, Coimbatore, Dilsukhnagar, ECIL, Faridabad, Greater Warangal, Guduvanchery, Guntur, Gurgaon, Guwahati, Indore, Jaipur, Kalaburagi, Kanpur, Kharadi, Kochi, Kolkata, Kompally, Lucknow, Mangalore, Mumbai, Mysore, Nagpur, Nashik, Navi Mumbai, Patna, Porur, Raipur, Salem, Surat, Thoraipakkam, Trichy, Uppal, Vadodara, Varanasi, Vijayawada, Vizag, Tirunelveli
Navigate to Address
360DigiTMG - Data Science, IR 4.0, AI, Machine Learning Training in Malaysia
Level 16, 1 Sentral, Jalan Stesen Sentral 5, Kuala Lumpur Sentral, 50470 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur, Malaysia
+60 19-383 1378
