I think what you are describing is you have 50 separate files that are all the same format - 1 for each state - you would union the files together ( equivalent to appending)
see wild card union Union Your Data - Tableau
then depending on the formats you may need to pivot the result and the file is ready for us - you could then just use filters to select any state
tableau has excellent training at the link below - focus on data connection and visual analytics
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
This is not an Union Operation but something where I want to dynamically change the graphs I want to see. For example, I want to see graph of Texas first, Add California to the filter and I should now be able to view Texas+California (View shows only one graph of Sales vs Time. Thanks!
It's really difficult for anyone on the Forums to do anything without some data or drawing or example outcome.
We're just guessing at what the answer is without more detail or diagram. See if the below screenshot comes close to what you're trying to do?
When you say Texas + California, I'm assuming the two states sales values are combined by whatever date you want to see?
The below uses Superstore example data found in Tableau Desktop. The title would update automatically with the 'State(s)' being chosen from the filter.