Splunk Search

Counts and sum of counts

alnapp
Engager

I'm sure this is obvious but I'm not seeing it

I've a search endiing in "chart count by UserName, host"

which gives me

> Username host1 host2 
> user1     2     2
> user2     5     1

but I really want a total column
e.g

> Username host1 host2 Total
> user1     2     2      4 
> user2     5     1      6

Any help would be appreciated

Tags (3)
1 Solution

cramasta
Builder

...chart count by UserName, host | addtotals

you can also add the column totals by using ...| addcoltotals

View solution in original post

cramasta
Builder

...chart count by UserName, host | addtotals

you can also add the column totals by using ...| addcoltotals

alnapp
Engager

I knew it would be obvious, thank you for the insight 🙂

0 Karma