I'm a bit confused on what you want - I had a user that wanted to be able to create custom regions based on zip codes and also use the zip codes on a map with the goal of selecting the region as a whole or the individual zip -
is that similar to what you want?
Needed to use Qgis to create a map that overlayed the regions and the zip
I keep a copy of the end result on my Public Site at Tableau Public
it looks like this (only the Tableau part)
If that is along the lines of what you want let me know and I will forward the Qgis part
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.
Just an observation, you're using dual-axis for both Rows (Latitude) and Columns (Longitude). That methodology is probably what's limiting you. Which is why you're not seeing a map. You're seeing X/Y.
If you can, post your workbook so we can help you to adjust that. Best, Don
Here is the workbook (with the relevant sheets only). Visual Stop Verification is the version I had which filters out any stop that isn't included on the selected route. Visual Stop Verification (2) is the sheet I'm asking about in this query.
I have Tableau Desktop 2019.2.4.
2 of 2 people found this helpful
Looking at the workbook it looks like you're blending the data sources. I will use blending only as last resort for a number of reasons. Blending only allows for a native left-join, so that's all you'll get between the two data sources. It's limiting.
Ideally and preferably, you'd bring in your spatial file left side and JOIN using the intersect feature with your points (lat/lon) data on the right side within the Data Source (Data Source tab) Pane Window. You can select a particular set of lat/lon points (Stop Lat/Lon) and use MAKEPOINT (Latitude, Longitude) function as part of the join calculation to intersect on. I think you'll get much better results thereafter. Here's an example of what that would look like:
Thereafter you'd bring your GEOMETRY from measures (from your .shp file) over to the Marks Card and then a dual-axis Dual Axis Mapping - Many Ways method to overlay your Stop Points onto your .shp file data (which may be a polygon or line or points). Best, Don
Thank you for this information, it did help me get to where I wanted to go (or much closer to it). Ultimately, Tableau is not as versatile as GIS (and I never expect it to be), but I did get to a better spot with regard to what I want to show clients. Thanks again!