-
1. Re: Simple latitude/longitude info
Zhouyi ZhangJul 10, 2017 6:29 AM (in response to Esther Twain)
HI, Esther
If you could provide a sample workbook with your issue will be more helpful
ZZ
-
2. Re: Simple latitude/longitude info
Jay Morehart Jul 10, 2017 8:02 AM (in response to Esther Twain)If you want to add this so tableau recognizes your field ([Store Number] for example) as a geo location, you can add this info (including hierarchy info) by importing a csv file per the directions here: Custom Geocode Your Data
It is also possible to assign a geo location to a field if there is a geo field(zip, state, etc) associated with it in the data source:
Hope this helps!
-
3. Re: Simple latitude/longitude info
Esther Twain Jul 12, 2017 1:28 AM (in response to Jay Morehart)Hi Jay,
But that's the thing: why do I have to setup a whole single csv file with a hierarchy, instead of doing it on an existing table? I literally just want the Latitude and Longitude info so I can plot some names on the map. Why doesn't this work?
Thanks,
Esther
-
4. Re: Simple latitude/longitude info
Esther Twain Jul 12, 2017 1:29 AM (in response to Zhouyi Zhang)Hi Zhouyi!
Unfortunately I can't provide a workbook The data is confidential and I'm not quite sure how to set it up on the superstore dataset...
But thanks anyway!
Esther
-
5. Re: Simple latitude/longitude info
Jay Morehart Jul 12, 2017 6:33 AM (in response to Esther Twain)Do you have the Lat/Lon data in one of the tables? if so you can simply put this on rows and columns
if not then when you say Latitude and Longitude at, for example, city level (but with another name rather than City). Do you mean that the field name is something different than City (but the data is city names) or the data is something different (like store names) but in the real world is tied to a specific lat/lon?
if it is city data in a field called [Locality], for instance, you can just assign it the geographic role of city, and Tableau will generate the lat/lon for cities it recognizes.
if you don't have lat/lon in your tables, and you don't have recognized geo-data (city, state, zip etc) (and this is what I thought you were asking, especially since you mentioned "custom geocoding") then the data to do what you want does not exist in your data set and you need to add it. You can either add it by, adding it to one of the already existing tables, adding a new table with lat/lon and joining to it (blending is possible but has its limitations), or add it to tableau as custom geocoding so Tableau recognizes your data as something with location info.
-
6. Re: Simple latitude/longitude info
Joshua Gearheart Jul 19, 2017 4:54 AM (in response to Esther Twain)Esther-
Tableau will only geocode for you down to the city level, so if your data is more precise than that you'll need to add lat/lon to the datasource yourself or import custom geocoding. Tableau's integration with R may help with the former: https://www.dataplusscience.com/Geocoding%20in%20Tableau%20using%20R.html