0 votes
1 view
in BI by (17.6k points)

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.

1 Answer

0 votes
by (47.2k points)

  • 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

Welcome to Intellipaat Community. Get your technical queries answered by top developers !