1 of 1 people found this helpful
Currently (as of version 10.5) there is not possible to mix
both auto-generated and materialised Lat/Lon in one view.
So one opt to convert X & Y from Excel to a shapefile.
Then combining Geometry columns from different shapefiles
could be done via Union (of a kind), for the exact method
please refer to the blog post by Tableau own Sarah Battersby:
Please find the attached as an example.
3 of 3 people found this helpful
I think you'll be pleasantly suprised by this...a little further down in Sarah's post is the "Spatial File + CSV" section that has instructions for using spatial data & x/y coordinates. I followed Sarah's instructions to set up a union via full outer join and then built out the two ZN calculations and got this view:
For the provided lat/longs the ZN does nothing other than create marks at 0,0 that need to be hidden per the instructions. However for the shapes somehow the ZN enables Tableau to use the geometry instead of just returning shapes at 0,0 and I just don't know how that works, but I'm glad it does!
v10.5 workbook is attached.
Jonathan, big thanks.
I'm happy you've questioned & exercised this.
I recall our exchange with Łukasz in this thread
A question might spike why the shaped Marks
coming from Tableau internal geo database
would get in their exact (same) position(s) --
effectively 'ignoring' the their (then table calc)
Lat / Lon coordinates on the view --
but I never try probing this behaviour.
Besides, i've even used that 'creatively' --
or so i thought -- in one of my public vizes
(shameless plug :-) Tableau Public
Again, thank you for your help.
UPDATED: just added a 'naked' view illustrating the point:
Map_Primer_v10.0_YF.twbx 1.2 MB
Thank you Jonathan and Yuri for your guidance. This helped me with my map tremendously!!!!!