I am trying to combine two data sources in Tableau - one has listed the individual information I am looking as individual measures and the other has listed them under one measure. I want to be able to combine this information but am not sure how to get them in the same format so that they can be compared directly.
Here is an example of how it is laid out to make it more clear:
Data set 1:
Count |
Words |
200 |
data |
300 |
source |
Data set 2:
Country |
data |
source |
UK |
100 |
250 |
USA |
100 |
50 |
I'm sure there is an easy solution to this but I'm fairly new to tableau and my playing around with the software isn't amounting to much. Any guidance or relevant help pages would be so useful. Thank you!