Explore Courses Blog Tutorials Interview Questions
0 votes
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:

  • 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. 

Browse Categories