With a lot of support from the Tableau community (see here), I've been able to create a map that:
#4 is where I run into problems. I need the median household income of every census block to be visible on the map. Our goal is to look at a given stop and be able to see the median income of every census block that the .25-mile radius around that stop covers.
I assume there's an issue joining the data. When I try to perform a full outer join of the census hh income and the shapefile, I get a "Unable to update relation" error message.
For a visual of the issue: if I hover over a census block with a stop in it, I can view the hh income:
But if I hover over a Census Block that does not contain a stop, I cannot see the hh income:
I've attached the packaged workbook below; please see WIP Sheet on the doc for my map thus far. I'm using Tableau 2018.2.
Thank you so much!
Hi Leigh Michael,
Is there any chance you could share a sample of the original data (or the actual tables)?
Also, do you want to change the aggregation on Median HH to use Median not Sum?