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:
These are defined in greater detail below:
- Extract Filters: Extract filters are applied when you extract the data, as highlighted in the following figure:
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:
Like extract filters, data source filters are applied before the LOD calculations execute.
- Context filters...