-
1. Re: Grouping zip codes into congressional districts?
Patrick A Van Der HydeFeb 8, 2017 3:18 PM (in response to Camila Mena)
Camila,
You could locate a zip code/congressional district file to map the zip codes to congressional disricts to get your subtotals. The census site has files like this per state - Congressional Districts Relationship Files (State-based) - Geography - U.S. Census Bureau
You can then create a Join to your data by zip code and group by Congressional district. Remember to assign the geographic role of Congressional Distritct to the field in the data. Note that in the Census data, the states are numerical so if that's the route you go, you will have a data clean up /normalization project to do. I just provide one way to do this.
I did a quick example of Superstore Sales by Congressional district for the State of Washington in the attached viz.
i hope that helps.
This viz is in Tableau 10.1
Patrick
-
2. Re: Grouping zip codes into congressional districts?
Camila Mena Feb 9, 2017 2:51 PM (in response to Patrick A Van Der Hyde)Thanks, Patrick!
-
3. Re: Grouping zip codes into congressional districts?
Patrick A Van Der HydeFeb 9, 2017 3:59 PM (in response to Camila Mena)
Thanks for coming back and marking the post correct Camila.
Patrick