I am building a dashboard and i want to be able to see individual records within the group when i click on a group. The problem is i have a dataset of about 700K records. so when i tried to drill down from the dashboard to the sheet with the crosstab, the system slows down significantly. How can i achieve this or is it even possible?
A set action would likely help here. Check out the walk through for an asymmetric drill down here: https://help.tableau.com/current/pro/desktop/en-gb/actions_sets.htm#asymmetric-drill-down
The other option is a parameter action that drives the asymmetric drill down, but because it relies on strings as opposed to Booleans like a set does, it will run slower: https://www.vizwiz.com/2019/09/parameter-action-drill-down.html
Other than that, take a look at this resource here for increasing workbook performance, which will offer tips outside of your drill-down that may help speed things up: https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm
