Combining dimensions with non overlapping data (Tableau)

Question

My data source is an 'outer join' of data from three distinct excel sheets with non-overlapping data. Each sheet has the same fields for filtering and the same two dimensions for the desired graph, ID and Reason. I want to create a basic bar chart that has the Reasons across all three sheets on a single horizontal axis and a CountD(ID) on the vertical axis.

How can I combine the three separate dimensions into one dimension? Should I use a calculated field?

Let me know if you need further information.

Answer 1

• With a bit more digging I was able to figure this one out (with the help of the second half of this post: https://www.tableau.com/about/blog/2016/1/combine-your-data-files-union-tableau-93-48891)

• All you need to do is to select all three of the dimensions whichever wanted to combine, right-click, hover over "Transform", and then select "Merge Mismatched Fields".

• This will work for sure because there were no overlapping data in the three relevant columns. The other two were always null, wherever one had a value, 

• You can use Tableau 10

I would recommend sign up for Tableau Certification classes from Intellipaat, they will also help you get a job.