Here is a thought. In table one create calculated fields with values equivalent to the fields you want to use in table two. You will have to blend the tables and then create a dual axis map with the first layer having the country and its CBD's and the second layer showing the heat map data.
Table 1 and Table 2 presented contain geofields with different geographic role.
Creating a map you cannot use more then one location structure for latitude and longitude.
I'd suggest a bit different approach (sorry, IT IS with joins):
1. add region to table one
2. join tables in the source and create a dual axis map
HeatMapWithCities.twbx 43.0 KB
Thank you! This looks perfect, only problem is I can't open the workbook you sent.
Error message below:
This file was created by a newer version of Tableau. Please upgrade Tableau to the version (or greater) that the file was saved in.
I've already upgraded to the latest ( 10.5.6 ) though :/
Would you please be able to just send me 2 screenshots of how the data is joined and the graph was created please?
Thank you so much!