Tableau newbie here. I am trying to look at financial services market capture of latino populations (as per 2010 census) in NC via census data visualization. I have followed Mark Evans' guide for importing census variable data and joining it to shapefiles via his WDC (Tableau, Census Data, and Web Data Connectors – I Like Big Bytes and http://ilikebigbytes.com/index.php/2016/09/07/mapping-census-tracts-in-tableau/ ) and successfully formed a color coded map of Hispanic or Latino populations in NC - see attached workbook. I would next like to put our branch locations as points on the same map and use the radius selector tool to count/add up the latino populations in circles of any given radii from those branch points based on census tract centroids.
However, I am stuck on/struggling with:
- Making circles (e.g. 5-10 miles) around any arbitrary point shows a very inaccurate sum(hispanic or latino population), off by at least a factor of 1000 (in many cases exceeding the population of our state!) and I have no idea why this is... any insight / how to fix it?
- I made an excel of (branch, zip, lat, long) and am trying to display the branch locations to the same map but it says I must first create a relationship mapping the branch latitudes / longitudes to the "generated" ones in the census shapefile... I believe the generated ones are just endpoints of the tract polygons, so the equivalency wouldn't work... what should I create instead to get it to show? I'd like to show branches as labeled dots.
- Alternatively, I could add the branch locations by (center points of) zip codes, but then I need to figure out how to map zip codes to tract-level FIPS codes... any simple way to do that? I would also like to add our membership data to this map too but cannot geocode it en masse due to privacy restrictions; hence will probably have to aggregate by zip codes - I know by itself on a new workbook zip codes aggregate data without any issues but I am not sure what the right way is to create a relationship so I can plot zip code level data along with the existing tract data I have.
Mr. Mark is understandably unable to offer help and advised me to ask here. I would really appreciate any advice from the community!
Tableau 10.2 - 32 bit.
NC_Latino_Visualization_post.twbx 723.0 KB