Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have map, as shown below, with one layer (yellow) to show various business locations, and a separate layer (blue) to show various airport locations.
I am aiming to have this map set up so that when a user selects a business name from an adjacent table in the same sheet, it will zoom in to let's say a 50km radius of that point and only show the airports within that radius.
Currently the businesses are plotted using Coordinates (AgentLongitude_AgentLatitude), and the airports using IATA codes (AirportCode), but I do also have a coordinate field for these if required (AirportLongitude_AirportLatitude).
I had found a similar question from a few years ago here, but couldn't quite get it to work, so any help would be much appreciated.
Hi @akelleway one option is first in script create the distance between points, using for example :
then, with that new distance field, you can add a set analysis expression to specify the distance expected inside the map chart to include that points