Forum Discussion
Map multiple data sets on the same map
I have 2 datasets:
Dataset 1 has a latitude and longitude value for every piece of equipment my company has working in remote locations.
Latitude
Longitude
EquipmentID
Dataset 2 has a latitiude and longitude value for every possible remote location that my company could be working, but does not currently have equipment. These locations would identify potential customers.
Latitude
Longitude
LocationID
CompanyName
On the same map I want to plot the locations where I am currently working, and also plot the locations where potential customers could be so I can see them together.
How could I accomplish this?
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:
15 Replies
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
Hi, I've got a similar issue but I want the distance in figure and not to plot it on the map.
For example I want to know which of my cutomer travelled the longest distance to me.e.g 4miles, 7miles et.c
