Need help setting up map with specific data

Need help
1

I have a map that is pulling a data type with an address tied to it.

map data
map data394×314 14.7 KB

Right now, it is showing a pin for every Service Request. What I want it to do instead is show a pin for every city that a Service Request has been done at.

For example, let’s say the client has had 20 Service Requests (these are essentially jobs) in Houston, Texas. Instead of showing 20 pins on the map in various locations around Houston, I want it to only show 1 pin outlying that we have serviced in Houston previously.

Basically what I want is some form of search that consolidates all the Service Request addresses and only does 1 per city to show all of the cities that we have serviced in. Instead of hundreds of pins all scattered around. I hope this makes sense, let me know if there is any other information needed for this.

Thank you!

2

Easiest fix is to either (A) add a City field on Service Request and have the Map use Search for Service Requests’s City:unique elements and one representative address per city, or (B) better long-term: create a City data type (Name + Location) and link Service Requests to it, then map Search for Cities. Option B is more scalable and avoids nested/duplicate searches.