We are trying to build the MAP with the query below. I can see some results in the statistics view but nothing is showing in Map (zip, Lat and Long). Can you please review this query and correct me if anything is wrong?
index="abcindex" | stats sum(PrimaryAddressZIP) as geocount by PrimaryAddressZIP | lookup geolookup Zipcode as PrimaryAddressZIP OUTPUT Lat, Long | where Lat not null AND Long not null | eval _geo=Lat+","+Long
Can you please help me on this?
index="abcindex" | lookup geolookup Zipcode as Primary_Address_ZIP OUTPUT Lat, Long | where Lat not null AND Long not null | geostats latfield=Lat longfield=Long count by Primary_Address_ZIP