Splunk Search

summation of row values

abhayneilam
Contributor

I have a report like this :

keyword "one" "two" "three"
mumbai 5 3 2
kolkata 2 2 1
chennai 0 6 4

I want my output like this :

keyword sum "one" "two" "three"
mumbai 10 5 3 2
kolkata 5 2 2 1
chennai 10 0 6 4

sum is the field which is the summation of each row

Please help

Thanks in advance,
Abhay

Tags (4)
0 Karma

Ayn
Legend

Ayn
Legend

The docs provide examples. It's as easy as adding | addtotals at the end of your search. What is it you don't understand?

abhayneilam
Contributor

Hi,

Can you please show me one example to use that.

Please, it is a kind request

0 Karma
Get Updates on the Splunk Community!

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...