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:
Post some sample data of all columns involved in both data sets
Here is a sample from each dataset.
Note: there may be similar lat and long in each set, but this will not always be the case. So it can't be assumed that this ties the datasets together as there could be situations where lat and long never matches.
In a perfect world I could control visiblity of each dataset independent of the other on the map, and quickly see areas where my work is concentrated relative to all areas that have work taking place. I have used another product that allowed me to select datasets to be visable without the requirement for the datasets being joined. Hoping this is possible and thanks for your help.
Data Set 1
| MXXEquipmentID | Latitude | Longitude | LocationName |
| 2456 | 54.51225 | -118.62191 | KAKWA 11-1-64-5 |
| 7896 | 54.46818 | -118.60062 | 102 KAKWA 11-19-63-4 |
| 13336 | 54.4303 | -118.52172 | DD ET AL KAKWA 3-10-63-4 |
| 18776 | 54.38926 | -118.64139 | ET AL 102 KAKWA 6-26-62-5 |
| 24216 | 54.39189 | -118.59343 | ET AL 102 KAKWA 6-30-62-4 |
| 29656 | 54.40489 | -118.62569 | ET AL HZ 102 KAKWA 1-36-62-5 |
| 35096 | 54.38427 | -118.63158 | ET AL HZ 102 KAKWA 16-26-62-5 |
| 40536 | 54.39726 | -118.60073 | ET AL HZ KAKWA 1-31-62-4 |
| 45976 | 54.41491 | -118.60316 | ET AL HZ KAKWA 13-36-62-5 |
Dataset 2
| LocationID | Latitude | Longitude | CompanyName |
| A5478 | 54.51225 | -118.62191 | Sanders |
| C5147 | 54.46818 | -118.60062 | Sanders |
| A578 | 54.4303 | -118.52172 | Mott |
| A9214 | 54.38926 | -118.64139 | Mott |
| N47895 | 54.41679 | -118.58234 | Selve |
| A5479 | 54.41692 | -118.58229 | Hillier |
| C5148 | 54.40503 | -118.6257 | Hillier |
| A17850 | 54.40951 | -118.60323 | Hillier |
| A26486 | 54.36622 | -118.50757 | Selve |
| N47896 | 54.46785 | -118.71304 | Keller |
| A5480 | 54.46785 | -118.71304 | Ladd |
You have Identical Locations (to 5 decimal places) that can be both Prospect and Current
or can be 2 different Prospects at the same exact Location
How did you handle these with the other software?
EDIT: Oh and I meant - Append the 2 tables (see picture)
Yes, some lat and longs are identical but this can not be guaranteed in my data.
This approach may work. Other software I used was Saleforce with Geopointe add-in for mapping. For mapping I could add many datasets and not have to merge them in order to display. I could have many lat longs at exact same location (in different data sets)and it would just visually overlay them, and i could selectively turn an entire data set on or off.
I will try your approach as it should work for what I am trying to accomplish.
Thanks!!!
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:
If you want to filter out a specific current prospect and also look at the future prospects around the current prospect then how do u do this?
The Column that is the Location Field - includes all Locations
Therefore you can either create a
1) SLICER (same as below - select all and uncheck the ones you don't want)
OR
2) Go to the Visual Level Filters - open the Location Field Column - Basic Filtering - Select All - Uncheck only the ones you don't want
There are other ways too by creating additional conditional column to Include and Exclude...
But option 2 is probably the fastest/easiest way to do this! :smileyhappy: