In the attached workbook "Confused as ****" I have three data sources:
- Custom polygons for all counties within Illinois and all ZIP codes within one county. Created from ArcMap & ET GeoWizards. [Datasource named Custom]
- Provider IDs with long/lat for each practice location in the state (so each provide IDs is found on one or multiple rows) [Datasource named Master]
- Provider IDs with patient service details, including totals for age ranges, location category, and geographic service area (linkable to polygons data source). The way it's disaggregated, each provider ID is duplicated along many rows. [Datasource named Maximus]
I want to produce a dual-axis map with provider locations as points and counties or ZIPs as polygons. When the user clicks on a point, two things happen:
- All the other points with the same provider ID are highlighted (showing all their practice locations in the state)
- All the polygons that are served by the provider are highlighted (and color ramped by the total patients served).
The forum posts I've seen tell me everything has to be unioned into one data source in order to make the dual-axis map work. Is that true? I don't know how to achieve that given my three data sources. I'm hoping I can blend.
As close as I can get:
I've been able to achieve some of what I want I want with a single and far less detailed data source (see attached workbook Success with smaller scope...) But this example was easier because:
- Each provider had only one location
- Each provider had simpler patient data (no age/service/place category differentiation)
- There were only county geographies. There were no custom polygons combining ZIP and County. Tableau could intuit counties automatically.
- No joins were necessary
This is for a public health data project showing access to care for Medicaid populations; your help with greatly assist us with our project. Note, none of the data is sensitive or governed by HIPAA. It was provided by a government agency that aggregated to levels that protect patient confidentiality.
Confused as hell.twbx 29.8 MB