It looks like what you are trying to accomplish is a variant of a slope chart/bump chart - have you taken a look at this article that Andy wrote that might help out?
- How to make a slope chart in Tableau – Gravy Anecdote
- How To: Using Ranks to Create Bump Charts in Tableau | Sir Viz-a-Lot
Looking at the data, I would suggest merging the data structures into one table before potentially starting this process. It would make sense for the analysis to start with a more consolidated structure:
Country Measure Type Value United States Real GDP Growth 1.6 United States Stock Market Return 12.1 China Real GDP Growth 6.7 China Stock Market Return 14.5 Canada Real GDP Growth 1.4
It seems like both the options you presented use time as the X axis but I’m not trying to compare return over time. I essentially need to have a dimension (country) on separate ends of the spectrum, and then rank county on both sides of the spectrum by 2 separate measures… GDP growth and stock market return. Do you have any suggestions for that? I’ve combined the two tables into one like you suggested.
This should still work with categorical measures on X. I tried a subset of the data in the shape I described above to see how this might look:
I've attached my example as well. Hopefully this helps!
Bump Example.twbx 41.8 KB