Using filters wisely
Filters generally improve performance in Tableau. For example, when using a dimension filter to view only the West region, a query is passed to the underlying data source, resulting in information returned for just that region. By reducing the amount of data returned, performance improves. This is because less data means reduced network bandwidth load, reduced database processing requirements, and reduced processing requirements for the local computer.
Filters can also negatively impact Tableau's performance. For example, using only relevant values causes additional queries to be sent to the underlying data source, thereby slowing down the response time. Also, creating quick filters from high-cardinality dimensions can impair performance.
Tableau's filters are executed in a specific order, so keep this in mind when using them. Refer to the Tableau help pages here: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm. The...