Filtering data
Often you will want to filter data in Tableau in order to perform analysis on a subset of data, narrow your focus, or drill into detail. Tableau offers multiple ways to filter data.
If you want to limit the scope of your analysis to a subset of data, you can filter the data at the source:
Data source filters: These filters are applied before all other filters and are useful when you want to limit your analysis to a subset of data. These filters are applied before any other filters.
Extract filters: These filters limit the data that is stored in a Tableau Data Extract (
.tde
) file. Data source filters are often converted into extract filters if they are present when you extract the data.Custom SQL filters: These filters can be accomplished using a live connection with custom SQL that has a Tableau parameter in the
WHERE
clause. We'll examine parameters in Chapter 4, Using Row-Level, Aggregate, and Level of Detail Calculations.
Additionally, you can apply filters to one or more...