Today, we will mainly be looking at the six types of Tableau filters that are available in Tableau. Additionally, we will also explore other types of filters that can be very useful.
Here is a video by Intellipaat that explains sorting and filtering in Tableau:
Data filtering can help to eliminate observations in an analysis that may be undesirable or contain errors. But, let us understand how Tableau can help to work with data in the first place.
Filters in Tableau
Let us first understand what filters are and what their purpose is. Filtering is nothing but removing some scope of data from a data set. Filters are very helpful to create dashboards in Tableau. Filters can help to minimize the size of data sets for efficient use, eliminate irrelevant dimension elements, clean up underlying data, set date ranges and measures as required, simplify and organize data, etc.
Types of Filters in Tableau
There are mainly six types of filters in Tableau. This blog is going to explain them one by one.
Context Filter
Context filter in Tableau can help to create data sets by applying relevant presets for compilation. Tableau context filter is always processed and applicable first, even if other filters are applied. The multiple preset categories in the worksheet can be divided into many more parts that end up working like a context filter in itself. Data sets are created based on the original datasheet, and data can be minimized efficiently to allow for viewing all data rows despite the constraints. The sheets can be chosen as and when needed.
The context filter adds an actionable context to data analysis, but if the data is not reduced enough, the cost of computing can be very high.
Extract filter in Tableau are used to extract a small subset of data from the original data source. Tableau then creates a local copy of the data set that is to be stored in the repository. You can save a screenshot of how it looks in your workbook. These methods reduce Tableau queries. The data size can be further reduced by applying the measure or dimension filter to the extract as required.
Data Source Filter
Data source filters in Tableau are mainly used to restrict sensitive data from viewers and reduce data feeds. Viewers can, however, have certain access rights to view the underlying data. Data source filters allow the direct application to source data. One important thing to mention is that the extract filter and the data source filter are not linked, and if you happen to go back to a live connection, the data source filter will remain intact.
Dimension Filter
Dimension filters in Tableau are non-aggregated filters. The dimensions that are used are mostly blue pills. Blue pills correspond to discrete data. The dimension filter can be applied by dragging it from the Filters pane. The same can also be achieved by right-clicking on a particular dimension and selecting Show Filter. This way, one can exclude or include the values that they want to analyze.
If there are many dimensions, one can search for them. Dimension filter provides four options, General, Wildcard, Condition, and Top/Bottom. You can pick up any of the four options to select the right data or remove the unwanted data. One can create their own formula as well and then use it in the Condition filter and the Top/Bottom filter for data selection. They provide a channel to measure to get the required data.
Measure Filter
Using a Measure filter in Tableau allows for various operations and aggregate functions such as sum, median, avg, standard deviation, etc. Aggregated filters are always applied after non-aggregated filters, no matter what the order is on the Filters pane. The filters are applied to Measure fields consisting of quantitative data.
In the next stage in a subsequent dialog box, you will get four types of filters:
- Range: Select the range of values to include in the result
- At least: Select the minimum value of a measure
- At most: Select the maximum value of a measure
- Special: Select null or non-null values
Get 100% Hike!
Master Most in Demand Skills Now!
Table Calculation Filter
The Table Calculation filter is the last filter that is applied after the view has been created. If you want to add a filter to the view, the Table Calculation filter will do the job for you without filtering the underlying data.
Apart from the six main types of filters in Tableau, one will also come across other types of filters that are very convenient. Some of them are given below:
Global filter
The Global filter can be applied across multiple worksheets by using the same source data within a workbook. The filter can be applied to all worksheets by using the same data as well.
Quick filter
The various filter types in Tableau are quickly accessible by using the right-click option. These filters are known as Quick filters, and they have sufficient functionality for all common filtering needs. Quick filters in Tableau can also be implemented on dimensions or measures.
Cascading filter
Cascading filters in Tableau allow for the selections in the first filter to change the options in the second filter. This helps to limit the values to ones that are only relevant to the first filter and prevents users from selecting irrelevant data, which creates a better user experience.
User filter
The User filter, a.k.a. the row-level security, in Tableau is a feature that restricts and manages the data that users can view or access based on the authority given.
Filtering plays an essential role in data analysis. This blog explores the many ways one can use the filters in Tableau to have a better view of data as and when required.
Conclusion
Filters are an important part of Tableau. They help in working with data and creating dashboards. We have seen how the six filters in Tableau work and how we can use them. Hope this information takes you further ahead in your Tableau journey.