Can you please check the blending, my major concern is why blending is not working.
Naryb- I think my point is you don't have to blend those two data sources to answer this question. However, if you'd still like to could you attach a packaged workbook or sample data sets of super store and coffee chain? And also, which dimension are you using to blend these two data sources?
Can you please check attached workbook,
they clearly mentioned 2013, i assume we suppose to consider date from the superstore to get the results .
Thank you for your reply.
Coffechanin&samplestore.twbx 458.8 KB
2 of 2 people found this helpful
Let me give brief explanation of data blending,
i am checking both data sources one is having data 2010, 2011 and another sheet having data 2012,13,14 and 15.
so you understanding that after blending both data sources you can get the profit for 2013, but data blending will not work in that process.
Let me give you few points on data blending.
- Blending is a relationship of data from different databases based on a common dimension and its behaves like a left join.
- you can use a blending option when your data exist in secondary data source.
- Primary data source and secondary data source can be change for each and every sheet.
1) In your case coffee chain data source does not contain 2013 after you do the blending with super store data. Please check below image.
2) for your understanding i will give one more example:
let us take the state dimension instead of the Date and see the out put.
same states are present in both data-source so the output will be as below monitored.
I hope gave you clear idea on data blending please let me know if you still have any doubts.
Note: May be for the above question the data sets are not appropriate you should check and get appropriate data sets to do your practice.
I would agree with Anand, I was going to give the same explanation on why you're not seeing the data. Tableau cannot produce new data for something that doesn't exist, it only outputs based on the available data. As I said it's a clear typo in the question.