I do not see an attached map, but this is done by creating a Dual Axis map. Click the latitude pill in the first map and hold down the control key. Drag the pill to the left and you will have two identical pills. Remove the county mapping from the second map and then map your address dots. Right click on that second latitude pill and select Dual Axis from the menu. You will not have the dots over the counties. You can look at this as a sample: Tableau Public
Hello @Tim thank you for your reply. I thought I attached the workbook. But it didn't and am trying to attach to this post but don't see an option.
Ill try to explain in Pics.
So I did what you suggested, first I dragged the latitude pill so I have two identical pills:
Then I removed the second pill and drag over the latitude and longitude of the address, but I get this:
What am I doing wrong?
Did you look at the Tableau Public sample?
Sent from the iPhone of Timothy Dines.
Can you upload a packaged workbook?
I don't see anything attached...
I'm confused with what you're trying to do, but I see two possible scenarios.
One: Your 'service addresses' represent very specific locations, like a home or business?
If this is the case, then you won't be able to achieve the desired result, since Tableau can't create a dual axis map when each map is using different lat/long coordinates (where one map is using the 'generated' coordinates and the other is using your own coordinates).
Two: Your 'service addresses' are just specific counties?? This is where I'm confused. Are you coloring by county, and then trying to show which counties get services via the points?
If that's the case, then all you need to do is hit the down arrow on your second map, take county off the detail, place 'governor regions res' on the detail, and then change the chart type from filled map to circle.
Then go back up to your second latitude, right-click and hit dual axis.
Either way, it's pretty difficult without a workbook attached.
Move your fields titled Geo Latitude and Geo Longitude to measures and then use those to replace the generated versions. They should show up with AVG as the aggregation. If you send me your workbook or post it here, I will have it back to you in a few minutes. My work load is very light today.
Hello @Tim Dines, @Ken Flerlage, @ Galen Busch and @Mike Mainzer,
First, Thank you to all for your assistance! it is greatly appreciated.
I am trying attach a workgroup to this post but don't see a link that will allow me to attach, I thought I did to my original post but I guess it didn't go through.
Anyway the public link that Tim suggested I looked at and it was great! Something that I would like to achieve to (as I am a newbie at Tableau). However, I didn't get how it was done as I was not able to open the data source.
However! I was able to figure out what was going on. The recommendation on coping and pinning the latitude twice and then adding the lat/long indicators was correct. The problem was that New York State has 62 counties but the addresses are not in all 62 counties (Mike to your note). So a work around (not sure if this is what I was supposed to do) was that I created a some empty rows with the missing counties and added a fake lat/long to those missing counties (I added Montreal's lat/long so in the map there was an indicator that was out of NYS, I need to figure out how to not show that point but one problem at a time).
@Glen Busch thank you for the tutorial all this helped.
Next I need to re-look and study how Tim created the Indiana BMV Location Information, because that is ultimately to something that I would like to achieve. Tim, suggestions on how I can open the data source so I can see what the data looks like?
Thanks again all!
I attached the twbx in the forum, but will be happy to email the file to you.
Sent from the iPhone of Timothy Dines.
yes I can download and open the workbook. And I am able to see all the sheets and the dashboards, but I cannot open the data Source, when I try to open it I opens a new window with "Where is the data file"?"
I'm asking for the data source as I think it will help better understand how the data is saved and displayed.
Further more it looks like the Locations and Region sheet doesn't have anything (is that correct?)
However, I would love to figure out how you created all those maps. I will study it meticulously.
If you are able to email me the workbook with the datasource (firstname.lastname@example.org) I would greatly appreciate it!
You've got mail.
Got it! Thank you!
I hope you don't mind me contacting you in the future if I have further questions.