I am hoping to show a map of where my customers are (with circle size by count) and also I want to show the path of projected hurricanes in the same map. I know how to do this individually (two maps), but I can't seem to figure out how to show the customer count and storm path on the same map.
I have my customer data by city.
I found storm path data with latitude and longitude.
I would like to combine the two tabs in the example attached. Any ideas how to do so?
Hi Kent, what a creative idea. I'm part of the way there, but it's not very elegant . It might give you a start in the right direction though.
First, I had to put all of your data in one source, so that there was a single Lat and single Lon column. I let all the non-matching columns be null. I added a column called Source so I can group the records by which data series they belong to.
Then I re-created your Storm map as near as I could. One difference is that I un-checked the Aggregate Measures (under Analysis on the Menu bar), so that each record will show.
Put Lat on the Rows shelf again, right-click it, and choose Dual Axis.
With a dual axis, you now have 2 marks cards that you can set up semi-independently. They aren't completely independent, but we can choose different marks.
The first Marks card is already set up for Irma. I'll set the second one up for Customer City. I put the Source on Shapes here, and assigned a clear shape to Weather. Otherwise, Circles were showing up all along the hurricane path. To bring custom shapes into Tableau, check out Custom Shapes | Tableau Software. I have a clear 10x10px png file if you want it. Just let me know.
I can't figure a way to remove that tiny blue line between the customer cities. I think to get rid of it, you have to change the Irma path to something other than a line.
I've attached the .xlsx and .twbx, but I have Tableau 10.3.
Ok, this may get you part of the way there. Hopefully others will chime in with other suggestions.
Best,
Jennifer
