Tableau join and blending of data

Question

Hi, when I repeat the steps on the tableau exercise in doing the joining and blending of data, my ratings numbers does not show when I add the "Purchase Date" to the column header? It does show the total when I drag it to the worksheet, but as soon as I add the "Date of Purchase", there are no values as per your example. I have triple checked that I follow all the steps correctly. It happens with both the joining and blending exercise. Please advise as to why? Am I missing a step?

Edit: I did notice when I hover over the bars for each month, it shows the data there, but then I have to select all the bars and change the mark label from "Automatic" to "Always show" in order for the individual data lines to reflect such as per your example. Is there a way to permanently change it to show like yours in the table format? All the settings are correct to show mark labels in the graph format - I checked this...

Answer 1

Hi Bianca, Please use blending. Joins are not suitable in this situation. The idea is that blending is preferable when we work with two files and we want to use data from both. Tableau keep updating versions of Tableau public and quite a few things change with every update. This is the reason why you see different results compared to the video. Could you share a screenshot, please? Or feel free to email me at nedko@365datascience.com Thanks

Answer 2

Thank you, I understand the importance of using blended, rather than joins, but my question was more about the format of how the numbers in the table displayed on your example, but not on my version. I had to do an additional exercise in order to see the numbers. I had to highlight all the bars on the table and right click to choose "always show" the marks. Guess its more of a formatting issue, but might have to do with different versions of Tableau.

Answer 3

Thanks, Bianca! Appreciate your follow up. Best, Ned

Tableau join and blending of data

Submit an answer