-
1. Re: Sum over counties when data only contains zip codes?
Dan CoryFeb 23, 2012 12:22 PM (in response to Rebecca Horowitz)
Tableau can show you where the zip codes are but does not have a way to group the zip codes by county. You can find zip code / county mapping tables on the web and join them into your results to do this aggregation.
Note that zip codes may cross county boundaries so any such aggregation is only approximate.
-
2. Re: Sum over counties when data only contains zip codes?
paul.rodriguez Feb 28, 2012 11:10 AM (in response to Rebecca Horowitz)Rebecca, I've been looking for the exact same thing, sadly for a few weeks. Showing my info by state is too broad but by zip code is too precise and sloppy. If you find something on the web that relates zip codes and counties and you could share that would be rad!
Thanks,
Paul
-
3. Re: Sum over counties when data only contains zip codes?
Alex Kerin Feb 28, 2012 12:02 PM (in response to paul.rodriguez)Here's a site with a free list that you could do a table join on:
http://www.populardata.com/downloads.html
Don't know where they got the data from, but it's free to use from their site with no restrictions.
-
4. Re: Sum over counties when data only contains zip codes?
paul.rodriguez Feb 28, 2012 6:55 PM (in response to Alex Kerin)Awesome! I couldn't get it to blend with my zip code data (because of all the Military and PO Box zip codes??) but I threw the Database in excel and ran a lookup up and all works well.
Thanks,
Paul