I am sure the gurus here will have better ways of doing this, all I could think of:
- Use your county data to extract the shape files from US Census county data.
- Append population info to the shape files
- Merge the Gauge info with the county info.
- Plot as Dual-Axis map plot.
Hope this helps.
county_map.twbx 238.2 KB
You're trying to display measures from two different sources.
You have two options one either merge your both the data at source level like plotting gauge in population data or you can use data blending to join both the sources. But in data blending you should have blending key to join both the sources. Here I didn't find any common filed so that you can blend the data.
Once you come up with how to link both, use dual axis map to display your measures.
I dont think we need a SQL like Join here. A Union will do just fine - only make sure that we align the columns by Name and that Latitude/Longitude line and that there is a Classifier for each row which indicates if Lat/Long belong to County or Gauge.
That said, the Area names here are County names. Changing the Area to 'Geographical Type County' while generate the County Filled Map, it does not generate it for all the counties.
It appears that tableau is unable to decode the county names as unique. To overcome that, I created a new State Variable and labeled is "CO" (all counties appear to be in Colorado) and placing the "Area" measure under State hierarchy. This gives much better results and I think is simpler than custom shape job I had done earlier.
The dashboard below compares the results of dual axis plot with;
- Custom Extracted Shapefile (no missing counties but a large dataset)
- Just Converting Area to "County" geography (missing counties)
- Creating State to County hierarchy (no missing counties and smaller dataset)
county_map.twbx 371.2 KB
Thank you so much for your work on this. This appears to have the functionality I am seeking.
Hi all, just to point out that the well-known state-county issue can also be handled by editing the "unknowns" then "edit locations" then specify state = Colorado. Or, adding both state and county to the detail shelf so that the built-in hierarchy is utilized. Still, your workaround is interesting.