The postal code issue is because of the version of Tableau you are on. Those codes are not in the database that shipped with that version. When I open your spreadsheet in 2020.1, only 58 unknowns appear.
Nope, wrong! For UK postcodes, only the characters before the space are used. You need to split the field into two separate fields and only use the left-most portion.
Will look at the heatmap issue later, time permitting.
Thanks a lot!
I have been exploring forum and also found something like this:
Seems to be something you mention in your comment. Will try that.
Thanks for checking my question and the heat map issue.
10.2? I hope you know that version is out of support and not being maintained. That would explain some of this issues with postcodes not being updated. We update the postal codes frequently but with the quarterly maintenance updates. I assume you are not under a support/maintenance contract and explains the 10.2 version. 10.2 went out of support in August, 2019.
Perhaps others have some ways to get around this issue. You could download the latest 2020.1 version using the free 2-week trial and try it out. If you like it, get in touch with your sales rep and get a price to get upgraded/support contract in place.
Yes, this is unfortunately not up to me. I work using this version of Tableau (full version is: 10.2.1(10200.17.0328.0755)) and try to explain to my supervisors what is possible and what is not. But thank you for update.
I tried what you advised in your previous remark. I have split UK postcodes and called them: postcode_outward and postcode_inward, someting like this:
I was able to get this View:
So this is not a clasic Heat Map but at least some progress. Is there anything more I can do here to have it looking more like Heat Map? Also, can you help me with the multiple dimention?