I would like to map the review between two international cities. I followed the demo and can get this to work for two cities in the same country, or the flows between two countries. I can’t get the map to work for flows between Miami and Calgary for example.
Attached is the workbook I created. Any ideas would be appreciated. I’d prefer not to have to geo-code each city and use Tableau’s default geo-coding.
Thanks
Patrick, I'm not sure where you're going with this but see attached. Also not sure why you say
I’d prefer not to have to geo-code each city and use Tableau’s default geo-coding.
You can do that with 5 clicks and a ctrl-v:
- Right-Click map
- Click View Data
- Click the upper left corner (to select all)
- Click copy
- Click cancel
Press ctrl-v. (Don't right click and expect to click paste, it will be greyed out). But ctrl-v does create a connection to the clipboard and create a new sheet for you. After you do that then rename the lat/longs to get rid of the (generated), just to be safe.
Now you have lat/longs that can be used in calculated fields, unlike the generated ones. Here's the new map:
--Shawn
EDIT: Sheet 3 has all your data in the connection.
