Thanks for all the files. Bassicly all your files are working correct. But ...
None of them are using calculated Long/Lat positions. In all cases Lat and Long are included in the data sources.
The only file using calculated fields is Holland.twbx . But here you calculated from sources inside the book and not the imported geographic data.
Investigating the data in my books a little more it really seems that the import of the csv does not handle ',' (comma) and "." (dot) well.
For instance take postal code 8431, according to the file it should give :
But what it does is:
So it probably misinterprets the "52.9916" and sees 6.291 as an integer instead of a decimal ". " 6291-34*180=171 so it is projecting the postal code to : Lat: 0, Long 171.
I thought I would add everything as a useful resource, if not for you, maybe others who find this thread.
I live in The Netherlands - so i have had particular reason to use some of this...
With the dot (.) vs comma (,) comment, you're on the right track... Tableau expects dots (.) in the co-ords (drove me nuts to!)
Personally, I tend to take them from Google Maps (this isn't 100% true, we use an automated mapping service, and I look up manually the few not found like this...)
Right click a point, click What's here (Wat is hier?) - at the bottom you get latitude & longitude to 6 decimal places (close enough for most )
Does that help?
Thanks for this tips. I have found a workaround, which I will post as answer on this question.
1 of 1 people found this helpful
Finally I found a work around.
The problem is indeed that during import the comma and point are not interpretted correctly. My local settings (windows 10) are Dutch:
I removed the GeoData from Tableau, changed the regional settings format to English (United States) and re-imported the csv file.
Once this is done all sheets run fine.
After the import you can change your regional settings back to what it originally was.
Fantastic, glad you got it sorted
I hadn't thought of the Windows settings... being English, I naturally keep my Windows settings as such, even though i live here.
Good to know, and thanks for feeding back as I'm sure that may affect others!
FYI September 6th in Amsterdam - Tableau v10 conference...