Hi, I have a map marked with few address. Is it possible to add a background color or band around a specific county every 200 miles. Please let me know
thanks
2 answers
You could use the BUFFER() function, which is a spatial calculation to create the below visual. This uses two separate calculations, one for 200 mi, another for 400 mi, colored differently but the same calc just modifying the parameters in the calc's:
BUFFER(MAKEPOINT([Latitude],[Longitude]),200,'miles')
You will need the latitude and longitude of each address, or in your case the lat/lon for each COUNTY for this to work... Best, Don
