How to reduce time taken to compute filters in Tableau?

0 votes

I have a dashboard where I have kept all the filters used in the dashboard as global filters and most used filters I have put as context filters, The problem is the time taken to compute filters is about 2-3 minutes. How can I reduce this time taken in computing these filters I have about 2 Million of extracted data, on Oracle with Tableau 9.3.

Aug 20, 2018 in Tableau by AwesomeSauce
• 860 points
51 views

1 answer to this question.

0 votes

You can apply the context filtering before the actual worksheet pulls down the records -- if your filtering is done correctly, the filters get passed directly into the SQL query predicate (an actual WHERE CLAUSE and not really a 'filter') -- Try this -- Open Tableau, go to HELP > Settings and Performance > Start Performance Recording, then open your workbook and apply the filters. Once it is done loading, go to HELP > Settings and performance > Stop Performance Recording. This will give you a worksheet with the queries used on it.

You can also use a custom SQL to select only the dimensions and measures which you are going to use for the dashboard.

Finally, you can even use custom SQL to remove unnecessary filters and parameters.

An extremely good place to start is the following white paper by Alan Eldridge:
http://www.tableau.com/learn/whitepapers/designing-efficient-workbooks

answered Aug 20, 2018 by Nitish
• 630 points

Related Questions In Tableau

0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
1,615 views
0 votes
1 answer

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 27,960 points
804 views
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22 in Tableau by Cherukuri
• 27,960 points
67 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,016 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
691 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
52 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,530 points
45 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
861 views
0 votes
1 answer

How to ignore null values in your chart?

If you right click on the bar ...READ MORE

answered Aug 20, 2018 in Tableau by Nitish
• 630 points
40 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
60 views