I wonder if it would help to add any of these as context filters? I don't know if that improves filter performance. Are your filters set to relevant values only? You may want to change that if so.
ive read the small amount of information on 'context filters' and they seem to be for narrowing down the results of the results in your results. this is also what you are getting at when you say i should filter relevant vaules.
both these are not really going to make any difference as the results im getting back from the VIEW on my database alraedy filter back only the results i want.
i really need some more general advice on how i can set up a lot of filters on a page without killing Tableau.
ive tried optimizing my dataset - but that didnt seem to do anything [it just came back with a message saying 0 rows updated].
i might try data blending but again im not entirely sure this is the right direction to go in as im such a Tableau newb.
i'ld love to hear from someone who has actually do something similar - eg a dashboard heavy on mulitple filters.
where all you are trying to do is get back a set of results for the user to extract to a spreadsheet.
this is a simple one page dashboard, with 20 filters.
the filters let you choose what catagory of customers you want to contact.
their are three types of customer - enquirers, applicants and current students.
the other filters help catagories the customers.
so for instance i might choose the department of english.
i could choose applicants and enquirers.
i would then get a list of just applicants and enquirers from the english department.
is this a task that tableau can meet?
normally i would just right this in PHP and MySQL and a web form with filters and the results would come back on 'submit'. however we dont use this technology where i work so im trying to get it working with Tableau.
You could try the technique I described in this link: http://community.tableau.com/message/189086#189086. What that does is to allow you to force some of your filters to be evaluated in Tableau rather than in the datasource. That can sometimes make a huge difference.
I would try having a few of your more selective filters as normal filters that are applied in the back end and then replacing the rest with filters using this trick. Ideally you want to limit the number of rows actually returned to Tableau as much as you can with the normal filters, but use the other technique to pick through the rest.