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
1,203 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
14,725 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, 2019 in Tableau by Cherukuri
• 33,030 points
4,990 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, 2019 in Tableau by Cherukuri
• 33,030 points
3,108 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
9,391 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,727 views
0 votes
1 answer

How to create a global filter

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

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,204 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 ffdfd
• 5,550 points
629 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 21, 2018 in Tableau by Atul
• 10,240 points
4,759 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
2,687 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 8, 2018 in Tableau by Nitish
• 630 points
709 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP