1 of 1 people found this helpful
In order to use both of your data sources on the same worksheet (data blending) you'll need to have a column that's the same between the two data sources. I don't see one like that in your current data.
Here's some more info on data blending, and what is required to make it work: Blend Your Data
Ideally, for your situation, I'd recommend putting the app type in the same data source as the state data if it's even remotely possible. Having one data source with only one column in it is going to be more trouble than it's worth.
Really a format like:
State App type App Number # Of Users NY A App1 4 NY B App2 29 NY A App3
CT A App1 10
would be the best to allow you the most flexibility in analysis.
Once you have your data issues sorted out, getting all 3 shapes on your map might be a bit tricky. If there's not a specific location defined for the particular mark, it will just show up in the middle of the state (like the little people on your map now) and they will all be stacked on top of each other. My mapping skills, alas, are not strong enough to figure out what exactly to do about that.
Thank you, Amber! This is a big help! I'm sure I can figure out the mapping part...the biggest issue I had was that of the application to state blending.
Enjoy the weekend!