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(Primary_Address_ZIP) as _geo_count by Primary_Address_ZIP | lookup geolookup Zipcode as Primary_Address_ZIP OUTPUT Lat, Long | where Lat not null AND Long not null | eval _geo=Lat+","+Long
Can you please help me on this?
Try 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
Try 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
thanks a lot.
I am waiting for this answer for long time. Can you please do the needful.
Can you please someone help me on this?