How are you doing?
I am not an expert of map, but try something.
Near future, Tableau will have more functional join between installed map and data driven long/lat location, but up to 10.5, I think it's not available yet.
What I tried is to specify the most appeared ZIP code of respective School ID.
==> One school ID has only one ZIP
Then map ZIP to generated map
mapzaipschool_SM_10.5.twbx 504.4 KB
There are many references in the mapping section of the help manual on how to do this, but the attached and below should help you out. Please mark this reply as correct if this answers your question, so that others can find it and use it going forward. Thanks, Don
1. Drag Latitude 1 (same pill but another instance of it) next to Latitude 1 and a new marks card will appear along with a second map.
Go to the new (2nd) marks card and remove all visible pills. Add in, the following pills: Zip, Latitude1 and Longitude1. CountD on ParentID and set to color.
Then go to the new Latitude1 pill and using the drop-down arrow click on Dual-Axis to combine the two maps together.
In this instance the colors were nearly the same for the underlying Zip Code map vs. the color of the points so go to the Color button on the marks card and edit the color so that your points stand out. If need be you may need to swap the two Latitude1 pills so that your point shows above the Zip Code layer of the maps. In other words you're bringing it forward into the view, should you have to do that.
You should have a map that looks like this, and like the attached.
Book3.twbx 456.6 KB
Hey Shin! Very good! Thanks for your help, it worked well.