1 of 1 people found this helpful
Just an idea... have you try to create in the first data set a new variable as a copy of the variable on second data set that you need to filter?
I've solved similars problems working in this way.
Thank you - this seems to work however it's very tedious. The "directory" data source with the geographic information has to have each row copied several dozen times over (once for each month/year) and there are hundreds of locations. And this doesn't even get down to day level data which I will eventually want.
This seems to miss the point of data blending if I have to copy the data from one source to another - is this a Tableau limitation or am I missing something?
thank you again - SO
I know that is very tedious... :/
Other idea will be solve at query level... avoiding two or more data sets in your workbook.
If you can do the blending in sql level you will be very happy (if you have all data in the same place, of course)
Sorry, I have not more ideas!