How to calculate the number of items in a radius of 100 meters on a map

[stilllifemuseum]

Hello there! This is my very first Post in the community. Espero se entienda porque lo escribí primero en español.

I need an expression that results in the total of parked cars that are located within 100 meters of a point on the map, from a list of points.
The list of parked cars is in Table A, and the list of points is in Table B, both with their respective latlong columns.
The result would have to be: “There are X number of cars within 100 meters of such a place”

Muchas gracias!

[Marc_Dillon]

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

DISTANCE()

Distance between locations

[stilllifemuseum]

Hey Marc_Dillon that was very educational, what do you say?

COUNT(
	FILTER(
	"geolocalizacion", 
  	AND(
  		DATE([datetime]) = TODAY(),
    	DISTANCE([geolocalizacion].[latlong], [latlong]) < 0.100)
    )
   )

[Marc_Dillon]

Looks good. Does it work?

[stilllifemuseum]

It works perfect. Now I have to calibrate the ideal distance between points. Thank you!

[adityo_reksopra]

Hi @stilllifemuseum ,

i need function like this, but i need to calculate the distance between langlot in the same column, how to do this?