Filter based on distance from a location/geocode
My data is location based. I have a Latitude/Longitude field in my database, and I want to view my reports based on locations that are within a distance from a point I specify. So, I need to be able to enter an address into a Maps search field, then return results that are x kilometers away from that address.
This is crucial for us, as we want to analyse our data by location/region. For example, enter an address/ZIP code, and find all sales that have occurred within 5/20/50/100km of that address.
I could then choose a different address, and return those results.