This map is really hard to read but if you look closely there are two Arkansas maps and some teeeeeennnyyy tiny cities.
Basically, I used vLOOKUP* to pull the zip code info for the Arkansas cities into the UCR sheet. Then I had to manually enter the zip codes for the counties. I used the city in each county with the largest population. When I plugged all of this into Tableau, this (the above maps) is what I got. I think the reason the zip code areas are so tiny is because each city/county had a zillion different zip codes and I only used one for each area/county/city in the spreadsheet. If we had more time, I think we could whittle this down and get each city to have all of the available zip codes so that it would link up with Tableau and create a better map, but due to the time constraint and the fact that I have a math midterm in 7 hours, I had to end with the above dual axis map.
I tried adding the map layer with the county borders, which I think sort of helps visually, but the maps are also hard to read and messy. Also, my 2010 zip codes populated several areas with dots instead of actual region/zip colors. Not sure why this happened.
With more time, I think the vLOOKUP combo would be the ideal fix for this mapping thingy, but its still really, really time consuming and frustrating. (I only cried once)
*disclaimer* My boyfriend is kind of a whiz with Excel and he did help me with vLOOKUP. I did all of the Tableau mapping, however.
Recent Comments