Splunk Search

How to sum values from Splunk log data?

pk555
New Member

My Splunk log is coming in this format:

\"amountLabel\":\"Amount\",\"amountValue\":\"6000.00\",\"sentOrDepositLabel\".......

I want to sum the values of 'amountValue' field and show it in a table for a specified period of time. Please let me know how can I do it.

0 Karma
1 Solution

kthammireddygar
Path Finder

First extract the amountValue field.

Link to Regex: https://regex101.com/r/UcePur/1

SearchString: index=foo sourcetype=xyz ....|timechart span=1h sum(amountValue) AS TotalSum

hope this helps

View solution in original post

0 Karma

kthammireddygar
Path Finder

First extract the amountValue field.

Link to Regex: https://regex101.com/r/UcePur/1

SearchString: index=foo sourcetype=xyz ....|timechart span=1h sum(amountValue) AS TotalSum

hope this helps

0 Karma

HiroshiSatoh
Champion

Aggregation uses stats.

| stats sum(amountValue)

If you extract the field with the search sentence

| extract pairdelim=",", kvdelim=":"
| stats sum(amountValue)

Refer to the manual for how to set field extraction.
http://docs.splunk.com/Documentation/Splunk/7.1.2/Knowledge/ExtractfieldsinteractivelywithIFX

0 Karma
Get Updates on the Splunk Community!

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...