Tableau will only send queries for what's in your view, so if you add Analyst and Stock as filters it should be fast. Add and show those filters and set the Stock filter to Only Relevant Values so it will be filtered based on the selected Analyst. Also turn off the Show "All" Value option for both filters. See image below and attached TWBX.
Dependent filters 103.twbx 1.1 MB
Thank you for the response. I did try this, and it works fine when the workbook is open - I can change selections and the results render quickly, but it is still get a long running query when I try to reopen the workbook. I get the "Processing request / Executing query" window, that runs for a very long time. If I cancel out of the executing query, then my filters are blank and I can't make selections.
I recreated this workbook and connection, but using custom SQL with parameters for the 2 inputs, and it works well. But this is not ideal, as my inputs are not a static list, and I do want the 2nd selection (stock) to be only the relevant values based on the first selection (person assigned).
Ultimately, what I would like to do, is only refresh the filter values when the workbook is opened (I could create a separate query to do this quickly). Then, once selections are made, retrieve the whole dataset using these selections. I want to avoid pulling the whole dataset without using inputs, but I'm struggling with how to accomplish this.
Any other suggestions or resources on details of how Tableau executes SQL would be appreciated. thanks