What do you mean when you say you have "52 worksheets"? Are you talking about Excel worksheets or Tableau worksheets? If Excel, then you can leverage Tableau Union to bring them all together. This can be done directly in Tableau: Union Your Data - Tableau Or it can be done using Tableau Prep: Join or Union Data - Tableau
Once you do that, it will all be a single data source, you you'll only need a single filter.
Thank you for the response.
Yes, 52 worksheets means excel sheets.
By doing the union the number of rows will exceed 200 millions.
Does that not affect the performance?
I don't see how that's possible. Excel has a limit of 1,048,576 rows, so the max you could have with 52 separate sheets is 54.5 million records. How is it possible that you have 200 million rows?
Thankyou for studying deep into this issue.
Firstly,Total population under study in this case is 250 millions.
I found that depending on the business case we may be switching to zipcodes instead of states.
If we union all the excel sheets for all zipcodes, then the total rows will be equal to the population size.
Okay, understood. Tableau can handle a large amount of data, but there are so many factors involved in determining whether or not your particular instance can handle it. The resources of your Tableau Server instance, the number of columns in each record, the complexity of your visualizations, etc. all play a big role in Tableau's ability to handle a lot of records.
Got it. Thank you.