Splunk Search

How to edit my geostats search for a simple map visualization? Getting "no match found"

seetharamanss
Explorer

Hi,

I'm trying to do a simple MAP visualization with the search below, but it is throwing me error no match found. Is there any thing I'm missing out?

host = "hostname" sourcetype = "sourcetypelog"  MarketName =SINGAPORE | geostats latfield=1.3667 longfield=103.8 count by MarketName
0 Karma
1 Solution

sundareshr
Legend

Try this

... | eval lat="1.3667" | eval lon="103.8"| geostats latfield=lat longfield=lon count by MarketName

View solution in original post

0 Karma

s2_splunk
Splunk Employee
Splunk Employee

latfield/longfield are meant to be the field names for latitude and longitude, not the field values.

0 Karma

sundareshr
Legend

Try this

... | eval lat="1.3667" | eval lon="103.8"| geostats latfield=lat longfield=lon count by MarketName

View solution in original post

0 Karma

seetharamanss
Explorer

Thank you . It worked

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.