Splunk Search

Count of hosts in to Single value dashboard module

MBerikcurtis
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

gkanapathy
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

gkanapathy
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

.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!