Splunk Search

Count of hosts in to Single value dashboard module

Path Finder

I'm using

index=main earliest=-1d@d latest=@d | stats distinct_count(host) by host | addcoltotals fieldname=sum | rangemap field=sum

in an attempt to get a count of hosts in to a single value module on a dashboard. Using this search, I get the name of the first host in the single value module.

Tags (2)
0 Karma
1 Solution

Splunk Employee
Splunk Employee

I don't see why you are using a command that complex, or why you're using rangemap at all. (And in general, rangemap is a terrible command. If you need the functionality, eval's case() function is better in every way.) Why not just:

... | stats distinct_count(host) as hostcount

and then just display the hostcount field in your singlevalue

View solution in original post

Splunk Employee
Splunk Employee

I don't see why you are using a command that complex, or why you're using rangemap at all. (And in general, rangemap is a terrible command. If you need the functionality, eval's case() function is better in every way.) Why not just:

... | stats distinct_count(host) as hostcount

and then just display the hostcount field in your singlevalue

View solution in original post

State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!