I want to reduce the number of points that are displayed in my google map. If the latitude and longitude is the same I want to count it as one point. I tried this
Number="123456" | eval ResLat=round(Latitude,3) | eval ResLong = round(Longitude,3) | eval _geo=ResLat+","+ResLong it still gave me the same number of points. Any ideas on how to remove these duplicates
You can use a search in the following form to aggregate the location information:
... eval ResLat=round(Latitude,3) | eval ResLong = round(Longitude,3) | eval _geo=ResLat+","+ResLong | stats count as _geo_count by _geo
This will only return 1 result for each unique location and still preserves the count information.
Hmmmm? Does not seem like "| stats count as _geo_count by _geo" has any effect?
However | dedup ResLat, resLong | eval _geo=ResLat+","+ResLong seems to give me what I want