Counts and sum of counts

[alnapp]

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

[cramasta · Accepted solution]

...chart count by UserName, host | addtotals

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

[alnapp]

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