I have a data source that has 2 different sets of data in it.
1. Set of data gives me a store location (I have Name, address, zip, and Lat/long)
2. Set of data give me vehicles that belong to those stores by Vehicle ID and Lad/Long
We are trying to map the vehicles around their respective stores and are having a hard time figureing that out. How do you map it?
5 answers
Assuming there's a primary key in the data sets for you to join them and the vehicles are located away from the store, you may need to format your data so that the lat long for the store and the lat long for the vehicle are in separate rows w/ a column containing the unique primary key. Put the categorization (store/car) in the color shelf.
