Forum Discussion
GIS Data Plotting (Multiple Tables)
Hello!
I would love some community help again 🙂
What I want to do:
I have a 'Epicenter' Data Set and 'Shops' Data set.
I would like to build a dashboard where I can 1) select the ID of a certain epicenter from the 'Epicenter' dataset, and 2) choose a radius (let's say 5km).
I would like to then 1) see the chosen epicenter point on the map and 2) all the shops in a 5 km radius.
I would like this radius to be on a slicer so that the clients can choose their prefered radius from the epicenter.
Epicenter Data Set:
| ID | Epicenter Type | GPS Lat | GPS Long |
| A1 | Hailstorm | xx | xx |
| B1 | Fog | xx | xx |
| C1 | Mist | xx | xx |
| D1 | Hailstorm | xx | xx |
Shops Data Set
| Shop Type | Shop Name | GPS Lat | GPS Long |
| Flower | Jasmin's Shop | xx | xx |
| Wood | JEP Wood | xx | xx |
| Steel | All Steel Co. | xx | xx |
| Food | Ihungry | xx | xx |
The 'Epicenter' Data Set will be refreshed daily and new information will be added
The 'Shops' Data set will remain static as I only have a set of clients at this point
I have done some research, but I have come up empty.
Does anyone have any suggestions that could help?
Guidance would be highly appreciated!!
MischaT Well, for the 2nd one you could create a slicer for the distance and use SELECTEDVALUE to grab that value in a VAR and use that in the formula versus hard coding it.
I think I would need sample data to play with in order to take this further.
8 Replies
MischaT I have created a couple different measures that should help:
Hi Greg,
Thanks for the tips.
Any suggestions on how to use the two graphs' GPS Coordinates?
Kind Regards
MischaT Well, if they are lat and long then mark their data categories as such and then use them in Latitude and Longitude field wells in map visuals. Or am I missing something?
