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

[marisstella]

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

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

[to4kawa]

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

hi, @marisstella
how about this?