How to edit my search query to display a Map graph?

[dhavamanis]

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?

[somesoni2 · Accepted solution]

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

[dhavamanis]

thanks a lot.

[dhavamanis]

I am waiting for this answer for long time. Can you please do the needful.

[dhavamanis]

Can you please someone help me on this?