1 of 1 people found this helpful
Nope Tableau doesn't support ZIP+4. If your question is can we convert a +4 to a five-digit ZIP and then use it, the answer is yes. Something like this:
But there are some ZIPs back east that are only 4-digits, so then you'll need to do something like this:
IF LEN(STR([MyZIPs]))=9 THEN
Is there a way around it if tableau doesn't support zip plus 4. For instance, if i have my own X(longitude) and Y(latitude) coordinates, can I use mine instead of the generated? I tried to, but it didn't work. Maybe I am doing it wrong.
Sounds like you must be doing something wrong, because Tableau definitely supports using your own lat/longs. Post a sample of your data or a package sample workbook and I can show you how to set it up.
No, I don't have a product like geolytics, but our dbase actually provides the longitude and latitude coordinates. I think it is just in the wrong format. If I format correctly, I think it should work.
Thank you both for your very helpful responses. It is much appreciated!
When you say you have coordinates, are they for points (e.g., one lon/lat pair for each zip+4) or the polygon geometry for drawing the boundaries of each area?
And if, by wrong format, you mean a different coordinate system, you should be able to ask someone that does the GIS or spatial database work for your organization to convert the data to WGS84, which gives you the decimal degrees that Tableau uses (and GPS systems,etc.). Instead of feet, meters or miles.
One of us can help if you want to post some sample data, as Shawn suggested.
What Steph said. Also there are free conversion utilities out there for doing batch conversion.