Sorry - cant dual axis maps when one is generated long and lat the other is input directly
see the piece that Sarah Battersby wrote to explain (She and Kent Marten are the real map experts)
If you cant use zips or something that is generated on your other map you could use Qgis to connect the points using a merge within a set radius -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Jim, thanks for the response. I started with Sarah's piece - very comprehensive but much of it's above my current understanding. Just to clarify, the lat. and long. in both data sets were input directly, which was why I thought there might be a dual axis map solution. I'm not familiar with Qgis - I will explore it further but I'm afraid I might not have the time to do so before I need to wrap up the project. I may just need to place the maps side by side.
I didn't see that each of the maps had Long and lat had generated - did the values match?
also you are on on older version of Tableau - new versions have a feature the Sarah talks about - intersection - that can be used to join the data - any chance of that?
I'm running Desktop version 10.3.16. Not sure by what you mean by the values matching. I grabbed the map coordinates through batch geocoding. The coordinates in one set represent school districts while the other set includes coordinates for specific school locations so while the data type matches, the data points themselves do not.
I'm not familiar with intersection. I've only worked with simple joins and unions.