When creating a dual axis, you only duplicate either the latitude or longitude pill. Are you sure you set up the dual axis properly when you tried it?
Example instructions for a dual axis map are here: http://kb.tableausoftware.com/articles/knowledgebase/creating-filled-maps-pie-charts
My initial reaction was that this would be a good use for a dual axis, but its hard to tell without being able to see a workbook. If you can post a workbook here, you will be likely to get the best possible help you can find.
I took out the extra longitude, but it didn't make any difference. The issue now is that the data for the second attribute just isn't showing on the map at all.
I see. Well, its difficult to say what is happening without seeing an example. Perhaps you can mock one up with some sample data and post here. If not, I am not sure what else to advise. Best of luck!
Jonathan Richman wrote:
What I'd like is to be able to have independently sized circles. One for the store locations (which would all be the same size) and a range of sizes to represent website visitors.
Message was edited by: Jonathan Richman
You could set up a measure swapper on the size shelf:
Something like a parameter called Size with 1 - Store Locations and 2 - Website Visitors
Then do a CF with
WHEN 1 THEN COUNT([Store Locations])
WHEN 2 THEN SUM([Webstie Visitors])
It'll be hard for me to make a sample data set, but I'll give it a shot.
The problem seems to be that when I add the locations to the shelf, the data isn't matching the visitor data. That is, tableau wants city and city to be mapped together, but they aren't the same (for example). I want the two things to be independent, but that doesn't seem to work.
I can tell there's a problem just looking at the View Data. For example, the range for the website visitors is from 10-250000 with a good spread throughout. When I add that Measure in the dual axis set up, the range collapses will a ton of Nulls and the range turns into something like 217,000-250,000. Clearly there is an issue with how the data sets are connected, but I don't know how to troubleshoot.