3 Replies Latest reply on Apr 3, 2013 1:10 PM by Dale Wunderlich

    Plotting county-to-county commuting patterns across state lines?

    Chris Hubbuch

      I'm trying to illustrate county-to-county commuting patterns using U.S. Census data.

       

      I've tried following the guides outlined here and using the custom SQL join described here but can't seem to convince Tableau Public 8.0 to cross state lines. Here's an example using some test data:

      http://public.tableausoftware.com/static/images/co/commutingtest/Sheet1/1.png

      The data includes fields for state of residence, county of residence, state of work and county of work. I created a Path ID using the county names only. I suspect this is the root of the problem but am not sure how to resolve it. Any suggestions?