Forum Discussion
Map multiple data sets on the same map
Yes do overlay here too!
That's why in the picture on the right those locations are neither red nor green because they are directly on top of each other!
And yes you can use a slicer(s) to turn on/off various elements such as Current or Prospect
Good Luck! :smileyhappy:
Merge the 2 datasets in the Query Editor (you can keep only the relevant columns)
Post some sample data...
You can create a conditional column say - if no EquipmentID - "prospect" else "current" so you can use this as a Legend
to easily identify current vs prospects...
its tough to say what the best option would be without seeing some sample data of the 2 datasets :smileyhappy:
Sean,
I have similar situation.. the two datasets cannot be merged since they dont have same zipcodes for example.. so if i want to map two datasets containing different sets of zipcodes then how do i do this?
If i append both datasets into one then i can see all zipcodes but i want ability to filter zipcodes from first dataset and always see zipcodes from second dataset.
Post some sample data of all columns involved in both data sets
ok.. i dont see an option to upload an excel file here so i am pasting tables here itself..
Here is "my locations" table which i would like to see on map.. its canadian... thats straight forward when i use postal code as location.
Primary_City Primary_State postal_code Blumenort MB R0A 0C0 Kleefeld MB R0A 0V0 Landmark MB R0A 0X0 New Bothwell MB R0A 1C0 St Laurent MB R0C 2S0 Teulon MB R0C 3B0 Warren MB R0C 3E0 Beausejour MB R0E 0C0 Carman MB R0G 0J0 Manitou MB R0G 1G0 St Claude MB R0G 1Z0 Sanford MB R0G 2J0 Neepawa MB R0J 1H0 Sandy Lake MB R0J 1X0 Baldur MB R0K 0B0 Brookdale MB R0K 0G0 Cartwright MB R0K 0L0 Killarney MB R0K 1G0 Souris MB R0K 2C0 Roblin MB R0L 1P0 My second table has "supply locations" which has different set of postal codes..
Primary_City Primary_State postal_code Brandon MB R7A 7M5 Neepawa MB R0J 1H0 Winnipeg MB R2J 0T9 Blumenort MB R0A 0C0 Neepawa MB R0J 1H0 Winnipeg MB R2J 3V9 Winnipeg MB R2J 3V9 Teulon MB R0C 3B0 Winnipeg MB R2J 0S3 Winnipeg MB R2W 2Z3 Winkler MB R6W 4A8 Winnipeg MB R3Y 1G6 St Laurent MB R0C 2S0 Souris MB R0K 2C0 Winnipeg MB R2X 1G4 Springfield MB R2C 2Z2 Winnipeg MB R2C 4G5 Winnipeg MB R2J 3S1 Blumenort MB R0A 0C0 Beausejour MB R0E 0C0 Portage La Prairie MB R1N 3B2 Winnipeg MB R2L 0X5 Winnipeg MB R3E 2V2 Swan River MB R0L 1Z0 New Bothwell MB R0A 1C0 Warren MB R0C 3E0 Melita MB R0M 1L0 Schanzenfeld MB R6W 1K5 I would like to always see the "supply locations" in my map.
Idea is that by filtering one of "my locations" i need ability to see my "supply locations"
