Can you attach the file you're looking at?
Do you have postcode in your data? I've found that fairly reliable to create maps.
I've attached an example I've just thrown together from a postcode list and a list of post codes per county, it's got a couple of gaps, but could be filled out pretty easily.
ukpostcodecounties.twbx 90.7 KB
Thanks for reply. I can't seem to open your file in Tableau Public - is that due to the file type?
The two files I'm trying to use are attached. Regions is the file I took from the older thread that seemed to help the other poster and the 'PRMS_data' is what I want to map - it includes counts, averages and quartiles. I was wanting to start by mapping the median for each of the regions.
It doesn't seem to recognise the regions at all. Am I doing this wrong?
Sorry, you can't open that in tableau public. You'll be able to open it in tableau reader, but you won't be able to see the data sources.
It looks to me like the UK regions sheet you've attached is meant to give the coordinates for the mapping, there is an option for custom geocoding, which doesn't work with Tableau public, that this might be for. Where is the sheet from.
The UK geography levels are:
It looks like you can get an ONS to postcode breakdown here https://data.gov.uk/dataset/national-statistics-postcode-lookup-uk/resource/3206f3b9-854a-46ec-8fd2-a6823e836b65 which you could use to define the regions.
1 of 1 people found this helpful
Ok, it looks like they are using it as a way to get around the fact that they can't load in geolocations to Tableau Public.
This was back in tableau 9 before the functionality to create a geographic role from another field
If you get a file together with each ONS area and either the postcode or city, if cities don't cross boundaries you will be able to use that to define your shapes, which will take a lot less data c3k postcodes (it uses the outcode, so the part before the space) against 88,877 ONS codes and probably a lot less cities.
So you could do it with a table like this:
Then using the postcode to define the geographic role will generate the shapes you need.
Thanks Chris that sounds interesting. I don't have time to sort a file out today but will hopefully be able to take a look tomorrow. As I'm looking to do local authorities as well (really unitary authorities, districts and boroughs) I guess I'm looking for something with that as well. Will all of that be doable from a NSPL file? I wonder if anyone has put that together already :-)