3 of 3 people found this helpful
Tableauchange the content of the data that may enter a Tableau workbook, dashboard, or view. Tableau has multiple filter types and each type is created with different purposes. It is important to understand who can change them and the order of each type of filter is executed. The following are numbered based on the order of execution.
A. Secure p, Web Edit mode, or standard dashboard mode in a web browser).: that can be locked down to prevent unauthorized data access in all interfaces (i.e., Tableau Deskto
1. Data source: To be “secure” they must be defined on a data source when it is published. If they are defined in the workbook with live connection, Tableau Desktop users can still edit them. Think of these as a “global” filter that applies to all data that comes out of the data source. There is no way to bypass a data source filter.
2. Extract : These are only effective at the time the extract is generated. They will not automatically change the dashboard contents until the extract is regenerated/refreshed.
B. Accessible: Can be changed by anyone that opens the dashboard in Tableau Desktop or in Web Edit mode, but not in regular dashboard mode in a web browser.
3. Context: You can think of a context filter as being an independent filter. Any other that you set are defined as dependent because they process only the data that passes through the context filter. Context are often used to improve performance. However if the context filter won’t reduce the number of records by 10% or more, it may actually slow the dashboard down.
4. Dimension : on dimensions, you can think of as SQL WHERE clause.
5. Measure : on measures, you can think of as SQL HAVING clause.
C. User: Can be changed by anyone in Tableau Desktop, in Web Edit mode, or in regular dashboard mode in a web browser.
6. Quick: Commonly used end user .
7. Dependent quick : There are quick depends on another quick filter. Dependent quick can quickly multiply and slow down dashboard performance.
9. Table calculation : on the calculated fields.
Can you tell me which filter should be used? I somewhere read that Quick filter should be avoided
I am more interested to know which filters should be used in terms of performance consideration?