Splunk Search

How to add sum filed in table

jslee
Explorer

I have two fiels. Deny and Monitor.
I want to draw timechart added by SUM field.
Can i add SUM field?

_time A B _time A B SUM
0:0:0 1 2 => 0:0:0 1 2 3
0:0:1 3 3 0:0:1 3 3 6

Tags (1)
0 Karma

yannK
Splunk Employee
Splunk Employee

use the | addtotals command.
see http://docs.splunk.com/Documentation/Splunk/5.0.1/SearchReference/Addtotals

mysearch | table _time A B | addtotals

0 Karma

jslee
Explorer

It's very simple..thnx

0 Karma

yannK
Splunk Employee
Splunk Employee

or if you have fixed list of fields use an eval to do the sum
mysearch | eval SUM=A+B | table _time A B SUM

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, ...