Hi Chris, I wouldn't use filled maps, you can use this file for state level and left outer both to the DBF (feature file)
If you want to do ZIP, you'll need the Tiger ZCTA file here. If you want to get really trick, create a measure swapper between State X,Y and ZIP X,Y measures. If you need to drill up/down, then you can use this technique.
I'm hitting the same problem here. Any answers out there?
I am trying to find a solution to this problem as well. I am tyring to do a basic heat map of sales by state, and overlay the location of our dealer base (using zip code) on top of that. Seems simple enough, but for the life of me can't figure it out.
If both tables have the same schema, you could probably do a UNION with CustomSQL to get all of the data into a single table, and create a constant field for the branch/customer field.
From there, I think you could create calcs for "Branch Sales" and "Customer Sales" to generate separate measures (create zeroes where appropriate to filter out Branch/Customers respectively). With separate measures you can create your dual-axis chart.
Ryan Shirley, you should take a look at this article:
You can also look at the workbook attached.
Book2.twb 237.3 KB
Thank you Roger. However, my problem isn't when I am dealing with the same data source (that I can do quite easily - I have posted a picture of that below), it is when I am working with 2 different data sources.
Data Source 1: Microsoft SQL Server - Dealer information - Contains all the info I need to plot the dealers locations.
Data Source 2: Excel File - Sales data by state - Only 50 rows of data, and 2 columns
I want to have 2 maps right on top of each other just like the picture below (which is based off a different set of data that resides within our datamart and I can access through the SQL Server using joins).
For some reason, though it seems easy, I can't get this to work properly.
2 of 2 people found this helpful
The only way to make this work right now is that they have to be in the same data source. As far as a I know, there is no work around for it. You'd have to manage to get the data into the same data source and the techniques described here will work The Vizioneer: Day 3: Dual Axis Maps - Filled and Points.
Thank you Sean. That is unfortunate.
Can you elaborate on your comment about not using filled maps? I'm new to the Tableau product courtesy of a viz class and working on this exact problem - multiple levels of detail shown on a single map for drill up/down as well as dashboard actions to drive behavior in related charts. I'm digesting the reference link you posted with the parameter swapper, but wondering a couple things:
For pre-built layers already included in the product, i.e. the filled maps, why not utilize them? I understand (I think) the limitation of only 2 layers if using a dual axis, but that would support my use case for county and state mortality data, though I will be pursuing the parameter solution since I would also like to aggregate up to sub-region and region groupings of states. Is there a specific limitation other than the limit of 2 layers?
Also, can you comment on the drill/up down capability of this solution? Ideally, clicking on a higher level layer (state) would zoom to the selected entity's boundaries and alter the parameter to the next lower level in the hierarchy (county) as well as trigger the highlighting rules in play to mask the items outside the selected parent layer (state) boundary.
Hi All! Did anyone found a solution or a workaround for this topic? I just encountered the same issue and was wondering if something changed from the last post?