I would union the data sources instead of blending. The problem is that the generated latitude and longitudes cannot be associated with each other via blend.
When you union the data sources, make sure to have zip code spelled exactly the same. See the attached workbook.
Hope this helps!
Please mark this answer as correct of helpful if this helps you solve your question.
Dual Axis Two Datasources_v10.5.twbx 310.0 KB
Thank you! This did it.
Just to clarify, you unioned the two data sources, then created calculated fields to actually generate the zip locations. If I would have named the fields the same in the data sets, would I have needed to create the `Sales Points` and `DC Points` fields?
I also found this on Ryan Sleeper's Playfair Data site: https://playfairdata.com/3-ways-to-make-magnificent-maps-in-tableau/ (at the bottom of the post). His example involves charting restaurant locations over top of sales; he adds custom lat and long coordinates to the restaurant locations, then uses the auto-generated lat and long coordinates to map his sales data.
But if I can avoid pulling lat and long all the time, all the better.
1 of 1 people found this helpful
Great! I needed to create the sales points and dc points only because of your size requirement. Without them, the stars would have been too small since they didn't have a count field.