Extract filters modify the data in the local copy of data set which is extracted from the data source. Data source filters modify the data based on given condition. These filters apply on both live and extract connection. Context filter creates a temporary table in Tableau engine and acts as a primary filter.
Tableau has 6 different types of filters:
- Extract Filter: This filter retrieves a subset of data from the data source.
- Dimension Filter: This filter is for non-aggregated data (discrete).
- Data Source Filter: This filter refrains users from viewing sensitive information and thus reduces data feeds.
- Context Filter: This filter creates datasets by applying presets in Tableau.
- Measure Filter: This filter applies various operations like sum, median, avg, etc.
- Table Calculation Filter: This filter is applied after the view has been created.