By default, all filters that are generally used in tableau Desktop are computed independently i.e. each and every filter used in Tableau access all the records of your data source without depending upon other filters. You can design more than one categorical filters as context filters. These context filters are independent filters. Other than the context filters all filters are dependent means when you process the data it will pass through context filter.
You can create a context filter to Improve performance: – The queries can be slow when you set lot of filters or you have a large data source. In that case you can set one or more context filters for improving the performance.
Create a top N filter – You can create a context filter and include only the data of interest, and then set a top N filter. For example, let’s assume if you are in charge of breakfast products for a large grocery chain and you want to find the top 10 breakfast products by profit for all stores. If your data source is very large then you can set a context filter which contains only breakfast products. After that you can create a top 10 filter by profit as a dependent filter, and it will process only the data (Subset of data) that passes through the context filter.
To learn more about context filters in Tableau Desktop check learn tableau or make the right move by enrolling now in Tableau Online Course to learn it.
Back