Michelle Kosmicki wrote:
Before you ask, no I cannot attach a workbook. It's client sensitive data so I am unable to share. Superstore may be a good substitute though.
It's always easier for us to help with a Tableau packaged workbook, even it's just a sample built of the Sample Superstore data which allows us to replicate.
I know Tom. If you have an intern I can borrow I'll get right on recreating this with Superstore.
Just wanted to put out the answer I posed for this problem in the Maps 'Ask Us Anything' forum in case it helps other people with the same problem...
I've been thinking about your problem with the synced pan and zoom maps and I wonder if this solution that I just tried with Superstore would work if you really need pan/zoom on the maps...
My test data: I split the superstore data into three separate parts to mimic the three datasets that you said you had
Tableau version: 10.2 (because it's easier to set up the full outer joins)
- Full outer join on the three datasets in Tableau
- Created calculated fields for the postal code, dataset number, and attribute I wanted to map (I used the Sales measure in superstore). I needed the calculated fields because with the full outer join on the three datasets I end up with three different postal code dimensions (one for each of the three datasets that I created) and have to have one single dimension that combines all three of these. Why? Because with the outer join only ONE of the postal code dimensions will be populated for each row, while the other two postal code fields will be empty, like this:
3. Mapped them as small multiple maps, using a field with the dataset name on columns. With small multiples the maps will stay in sync (example below - highlight action shown to select marks across the panes based on zip code)
Does that get closer to what you are trying to do?
I have attached a twbx so that you can see how I did this. It currently only has one action (highlight), but I think it should be possible to tweak the actions to work with what you need for your data.
synced_maps_10.2.twbx 816.4 KB