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
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...