Show What is Tableau Context Filter?Tableau Context Filter is a special type of filter that controls the data for the other filters. Whereas the normal filters are generally processed all the data rows from data source independent of the associated filters. Tableau creates a temporary table to process the context filter data that is the reason the context filters in Tableau are also known as dependent filters. The context filter is used to improve the processing performance. It is a recommended filter condition in Tableau for large datasets for creating visualizations. The Tableau Context filter should include in the visualization design before adding other filters for optimizing performance. Creating Context Filters
Removing Context Filters
Example of Tableau Context FilterYou can consider the superstore sample data set below for the following example.
Step 1: Using the SuperstoreSample data set, create an initial view showing the sub-category sales, which is sorted in the descending order of the sales as shown below: Step 2: Now show the products which are top-selling by creating a top 10 filter:
Step 3: Now the view is filtered to show only the top 10 product sub-categories by Sale as shown below: Step 4: Now you may add one more filter to show one product category, say Furniture.
The filtered view is shown as in the below screenshot:
Step 5: Using Context Filter on Category, we can find the top ten products.
Advantages of Tableau Context FilterThe advantages of Tableau Context Filter are explained below: 1. Improve Performance
2. Dependent Filter Condition
Performance Improvement of Tableau Context Filter
ConclusionContext filters are used to improve your query performance. Context filters reduce the size of your data sets to one-tenth or even more. The selection of the number of context filters is also very crucial for the performance. Selecting the type of joins is also important for performance improvement. Recommended ArticlesThis is a guide to Tableau Context Filter. Here we discuss how to create and remove context filters, examples and advantages of context filters. You may also look at the following articles to learn more – |