Effects of Filters on LOD Calculations
There are different kinds of filters in Tableau. Since LOD calculations modify the aggregation levels based on the view, the filters applied in the view are executed based on the kind of LOD calculation applied. The following chart describes how filters are executed in the view:
Figure 9.29: Order of filter execution
These are defined in greater detail below:
- Extract Filters: Extract filters are applied when you extract the data, as highlighted in the following figure:
Figure 9.30: Adding an extract filter
Extract filters are executed before LOD calculations.
- Data Source Filters: These filters are applied when you add data in the Data Explorer tab, as highlighted in the following figure:
Figure 9.31: Adding a data source filter
Like extract filters, data source filters are applied before the LOD calculations execute.
- Context filters...