I'm working on a Census tract map of Mississippi, showing the % African American population per tract. I'm working with two Excel sheets (both attached), the first (tl_2016_28_tract.dbf) that has the spatial data via TIGER, and the second (census_tract_race_Data) has the demographic data for each tract. Now, the shapes look like they've landed in the right place. But, when I hover over the tracts, the tract names are in all the wrong places, and thus so are the corresponding demographic numbers.
I think this might be from how I joined the two spreadsheets; I tried joining Id2 from the demographics file and GEOID from the shape file, but Tableau wouldn't allow it. So instead I made a column in the demographics file to match the NAMELSAD column in the shape data file. And that join worked, but alas the African American % data and the census tracts are all mismatched. Sorry this is so complicated, but if you look at the spreadsheets hopefully you'll see what I mean. The workbook is also attached.
Any help would be extremely appreciated.
Just figured it out for anyone curious: The tract level data I downloaded from the Census formats the tract ID column as a number, whereas the TIGER file formats it as text. On the page where you join the data in Tableau, convert the Census ID column to a string and that should fix the join.