We really appreciate you sharing this csv file that you worked on that helps resolve some of those tricky mapping situations!
Hi there the file above works fine, it's just the order in which you place things in Tableau that has caused the strange output you ended up with.
The correct order (which I use all the time) is as follows:
- Open Tableau and start a new book.
- Change Marks to Polygon
- Drag Point ID to Path
- Drag Polygon ID to Detail
- Drag Sub Polygon ID to Detail
- Drag Longitude to Columns
- Drag Latitude to Rows
- Drag Region to Colour
You should then get the same output as that attached.
UK Regional Map (Forum).jpg 136.5 KB