This is an excellent resource for what you're trying to do. Many methods will work with your two data sets: Dual Axis Mapping - Many Ways Best way to learn is by doing! If you get stuck though. Feel free to reach out (with a sample workbook).
Happy to help! Thx, Don
Thanks for your help! Unfortunately, I'm still struggling with this. I do, however, think I have a better idea of what I do know and what I need to know. For some more context:
- I have three files:
- A shapefiles map of King County, divided by Census block.
- An excel sheet that gives me the median household income of each census block.
- An excel sheet that has the lat/long coordinates of certain bus stops in King County.
Files 1, 2, and 3 all have one "like" field: the Census block ID. I'm assuming that this is needed to join the data.
I have no problem making a map from files 1 and 2. It's when I add file 3 to the mix that things get complicated.
As you can see from the packaged workbook, my dual axis map merely highlights the census block that each stop is - it does not portray the stop as a point/dot. Basically, I want the map to:
- Display a King County map divided up by Census block [DONE!]
- Be able to hover over each Census block on the map to see the median income of that block [DONE!]
- Be able to see each bus stop on the map as a dot [NOT done]
- Be able to hover over the bus stop point to see the bus stop's line ID [NOT done]
- Customize the color of the bus stop point so it stands out on the map [NOT done]
I'm not even sure if I'm connecting the three files correctly - perhaps this is why I'm running into errors again and again?
I would be so grateful for any advice on how to do this. I'm using Tableau 10.4 Desktop.
Median HH Income - WIP.twbx 487.3 KB
- I have three files:
See if the following two screenshots play out for you? Change Data Source join to ID and Lines 36_40 Stops to Geo ID Final. Change JOIN to FULL OUTER. As shown in Sheet 2, the majority of your map will go away due to the NULLS (1K). However, this is a small sample data set to join on, so that number will go down and more detail should display when you add in the additional lines. But I think it will only display underlying data (polygon layers) if there's related data.
Meaning, unless there's a bus line that crosses over each and every census tract, you might end up with some blank spots in the map. Give it a go and see how it turns out. Also notice I needed to change the Latitude and Longitude to use GPS Lat/Lon for both Columns/Rows and for Dual-Axis to get to the resulting view. I think this gets you closer than where you were before, but you were getting there!
Lastly, this is definitely GPS data...meaning it's tracing the bus line route and although there appears to be large gaps between stops, there are generally two (2) points for the line/route/trace. Which would lead me to believe that it was a stop up the route and then another stop on the return route back the reverse direction. Just an observation...
K, hope that helps! Thx, Don
Median HH Income - WIP_v10.4.twbx 523.6 KB
This is incredibly helpful - and it worked like a charm! Thank you so much for your help.
Last question (and I can also start this as a new thread if you think this diverges too much from my original question)
Now, I'd like to make a 1/4-mile radius circle around each bus stop point on the map. Basically, my goal is to see the census blocks that each bus stop servces using the industry standard that a stop serves households located within 1/4 mile of the stop.
I looked at this thread but haven't been able to crack how to do it yet - I don't have any experience with SQL, so it's new territory for me.
Any advice? Again, I really appreciate your help!
Updated workbook is attached for reference.
Median HH Income - WIP.twbx 473.8 KB
That's great! I don't have much experience with doing buffers around the points. Which is more due to my lack of time to attempt, than anything else! I would recommend closing this thread out and then posting a new request on the forums. You can close this thread by marking my response as correct.
There are at least 3-4 other folks actively monitoring the forums that should be able to help with your latest need. Hopefully you won't need to do any SQL to make that work.
Try looking at this solution (Step 3 onwards)? Make sure you use 3959 (for miles) instead of 6371 (for KM). I'm assuming you'd use .25 for the parameter control... hope it helps!
Awesome - thanks!