It would be nice if Tableau could impose filters on queries for distinct values (e.g. for colors, quick filters, etc). In my application, these queries currently require an index scan. Since I normally have a global filter restriction on date, using that in queries for distinct values would drastically reduce the amount of data scanned. Is there a way to do this?
The only way to do this now is to use extracts and set up your global filters as Extract filters. Otherwise I don't think there's a way to do what you're trying to acheive.