In the Google Maps display, we see "xxx results with location information ( yyy distinct locations) over all time". What constitutes a "distinct location" ? e.g. ... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00 | stats count(ip) --> 98346 And the unique IPs for that same result set: ... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00 | dedup ip | stats count(ip) --> 46411 I've also verified that "... | dedup ip | stats count(ip)" returns the same value as "... | stats distinct_count(ip)" Using the Google Maps module, I see the former query has 14085 distinct locations: ... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00 | geoip ip --> 95393 results with location information ( 14085 distinct locations) over all time One would imagine removing duplicate IPs should not change the number of distinct locations, but it does (increases to 14165): ... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00 | dedup ip | geoip ip --> 46243 results with location information ( 14165 distinct locations) over all time |
One Answer:
|
A distinct locations is a unique combination of the latitude and longitude values (ie. the values of the fields _lat and _lng). It's calculated by appending The only reason I can imagine that would explain those results is that the geoip commands somehow failed (crashed) on some of those IP values. The next version should fix this though. Also in the upcomming version of the Google Maps there will be a single field |