1 of 1 people found this helpful
Try joining the two datasets together and then creating a dual axis map - I have written up a bunch of instructions on different ways to make dual axis maps here, in case it's helpful:
Thanks for your reply Sarah,
The link you provided is very helpful, unfortunately, it didn't work for me. I got to overlay the graph on each other but not on the Map, the moment I converted it into dual axis it replaced the map with blank background.
Could you please share your input on that.
Workbook attached with an example.
I used a full outer join on the two files, then created new calculated fields to hold the lat/lon values for both files (so there were no nulls; one field had all lat values for both files). I used the new lat/lon values to render the map. Set the first axis to line type and filled in the lines. Added a second copy of my new lat calculated field and set that to a point type. Removed all of the details used to draw the lines on the first axis and replaced them with dimensions of latitude and longitude to render those points.
Let me know if this doesn't work for you...
Merge two Maps2_v10.5.twbx 464.0 KB
You are a life saver.
I must have done something wrong....
I downloaded your workbook and followed exactly what you've done, I got something very different.
Please see Sheet 5 in the attached workbook.
First of all, why is that I do not have the AVG for the Rows and Columns pills? I'm using 2018.01. Yours are Avg(Lon - all)/Avg(Lat - all) while mine are Lon - all and Lat - all. I can see the results are the same, but just wonder why the names of the pills are different.
Most importantly, I do't understand why I've the straight lines in the upper map while you don't.
Then, in the second map, I have all the points (for rivers), while you only have the points for the Lat/Lon?
Thanks for your help.
Merge two Maps3_v18_01.twbx 284.8 KB