4 Replies Latest reply on Jan 12, 2018 11:35 AM by Sarah Battersby

Help with dual maps

P R Jan 9, 2018 7:36 AM

Hi all,

I have a data source with the following columns, record of 100 customers visiting 5 stores ( for example)

custLAT custLON custZIP storeVisits storeLAT storeLON storeID

I need to create a dual map with the following requirements:

1. heatmap or choropleth map , shaded by custZIP and store visits.

2. marks or points for every store overlaid on the above

Basically i want to know which zip has maximum demand and where my stores are located in relation. Can someone please guide me on how I can achieve this? I was able to successfully complete step 1 but stuck on step 2.

Thanks

1. Re: Help with dual maps

lenaic.ridinger Jan 9, 2018 7:50 AM (in response to P R)

Hi PR,

Would you be able to share your workbook with us please?

----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Like Show 0 Likes(0)

Actions
2. Re: Help with dual maps

P R Jan 9, 2018 8:04 AM (in response to lenaic.ridinger)
sure, attached is the tableau workbook. I have managed to create two maps on two separate sheets, I want to overlay them on one map.

Book1.twbx 60.8 KB
Like Show 0 Likes(0)

Actions
3. Re: Help with dual maps

lenaic.ridinger Jan 12, 2018 7:19 AM (in response to P R)

Hi P R,

I see, you have different measures for Latitude and longitude.
I would advise you to Union your data (lat & long) in order to create a single map.

Would you be able to do that in your datasources?
Union Your Data

----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Like Show 0 Likes(0)

Actions
4. Re: Help with dual maps

Sarah Battersby Jan 12, 2018 11:35 AM (in response to P R)
Hi P R,

Is this what you are looking for? You can do this with a dual axis map...just use two copies of StoreLat on the Rows and set one to the CustZip for the detail and the other to Store ID (to separate out the store points). I've attached a TWBX to demonstrate. Take a look at the Stores + Visits tab.

-Sarah
Tableau Research

Book1.twbx 88.5 KB
Like Show 0 Likes(0)

Actions

Go to original post