You are getting this issue due to the blended data.
Are both your data sources going to be excel or other flat file?
Can you not put both the data sources in same excel file in separate sheets and link them in tableau without using blending?
Thanks for the reply.
I'm not 100% I understand you.
The 2 data sources are flat file format, in same excel file in separate sheets - i'm bringing them separately into Tableau.
Are you saying link the sheets as I import them, don't import them as 2 separate data sources?
any specific reason to blend the data? I mean I am trying to understand purpose behind blending the data and what you are trying to achieve/ depict?
I can see that you are already having Medium column in the Primary data. Can you use it to put it in colors?
I would also like to know why data is just blended on date column. I think you should have blended the data over date and Medium. Let me know if you are pretty clear about your blending.
I blended the data as I couldn't find an alternative.
The sets needed to be different data sources or the filters wouldn't work - I need the filters for each axis to work independent of eachother - in order to show any possible combination.
The end goal is to be able to show any combination of City's sales and Campaign spend - but to have sales split by city, and spend by channel - which are being fed from different data sources.
The data in Medium in each data source is different - one is sales channel, and one is media channel