Splunk Search
Highlighted

How to calculate the value of row for every column and fetch the result in table?

Explorer

I want calculate the row values of every column by error message...
I did
| Stats count(host) values(host) values(functionality) count(functionality) values (loannum) by errormessage

I'm just getting host count as 90
If i run the query sperately , like.. | stats count(hostcount) by hostvalues
It is showing all the values in their respective columns. Let's if the host are like hosta-20 host-30 hostc-40

so i want to fetch individual details in the same above columns by error_message

0 Karma
Highlighted

Re: How to calculate the value of row for every column and fetch the result in table?

Ultra Champion
| stats count  values(loan_num) as loan_numby by host error_message functionality

hi, @marisstella
how about this?

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.