Three kinds of filters are FOUND in Tableau. More explicitly, the information presented in your chart can be limited in three distinct ways. Each has its own weaknesses and strengths, and we look at them one by one. 

These kinds are traditional filters Custom SQL "Filters and Context filters.

• Custom SQL Filters: 

The "Filter" is a WHERE provision which is put in a SQL to search the WORKBOOK information. Custom SQL Filters: "Filter" is a table word that technically only relates to context and classical filters, but which is emulated by the conduct of the worldwide context filter with the Custom SQL Filter, so we're going to refer to it as such. Custom SQL "filters" are always worldwide by building. A personalized SQL filter is usually used because it limits the size of an information sample. The lower your information extract, the faster your charts are loaded. In other words, without sacrificing effectiveness, you can create more complicated graphs. During the server connection phase, one WAY to generate a custom SQL "Filter."

• Context Filters: 

Context Filters is a table filter which impacts the information transmitted to each table. Context Filters are good for limiting the worksheet information. If the worksheet queries the information source, a temporary flat table is created that is used to calculate the diagram. This provisional table involves all values not filtered out either with the Custom SQL or the Context Filter. Just like the Custom SQL "Filters," your objective is to reduce this temporary table. Context Filters have some benefits compared to Traditional Filters. First of all, they run faster than conventional filters. They are also performed before traditional filters and can be performed at once, thereby increasing effectiveness. They have a disadvantage, however. It requires time to put the filter in context. One principle is that the filter should be placed in context only if it minimizes the information by at least 10 percent from the knowledge base of Tableau. By dragging a field to the filter shelf and editing the filter, a context filter is developed. If you have various context filters, CTRL-Select all of them and add them to the framework in one lot. You can also pick the context by right-clicking the field at your shelf. This increases your filter's effectiveness. 

• Traditional filter:

A traditional filter is precisely what most individuals believe about filters. When Tableau creates the visualization, it CHECKS whether a traditional filter filters out a value. This is the slowest of all filter kinds since it is not done on the table LEVEL. However, after the context filters, it has the benefit to be done. If you have complex filters "Top N," this is a must. You can create a traditional filter by dragging a field on the "Filters" shelf.