Splunk Search

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

Builder

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?

0 Karma
1 Solution

SplunkTrust
SplunkTrust

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

View solution in original post

SplunkTrust
SplunkTrust

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

View solution in original post

Builder

thanks a lot.

0 Karma

Builder

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

0 Karma

Builder

Can you please someone help me on this?

0 Karma