Splunk Search

how to get the aggregation count of field values?

vrmandadi
Builder

I am looking something like the following result

  • A_Count AGGREGATE TOTAL 20 20 30 50 10 60

I know delta command will give the difference but is there any command which gives the aggregation

0 Karma

vrmandadi
Builder
0 Karma

skoelpin
SplunkTrust
SplunkTrust

You should check out addcoltotals

It will work like this | addcoltotals labelfield=change_name label=ALL

http://docs.splunk.com/Documentation/Splunk/7.0.1/SearchReference/Addcoltotals

0 Karma

vrmandadi
Builder

I know about addcoltotals,but that does not do something like a delta where For each event where field is a number, the delta command computes the difference, in search order, between the field value for the event and the field value for the previous event. The delta command writes this difference into newfield.

In the similar manner instead of difference I am looking for addition of it

0 Karma
Get Updates on the Splunk Community!

Operationalizing TDIR: Building a More Resilient, Scalable SOC

Optimizing SOC workflows with a unified, risk-based approach to Threat Detection, Investigation, and Response ...

Pro Tips for First-Time .conf Attendees: Advice from SplunkTrust

Heading to your first .Conf? You’re in for an unforgettable ride — learning, networking, swag collecting, ...

Raise Your Skills at the .conf25 Builder Bar: Your Splunk Developer Destination

Calling all Splunk developers, custom SPL builders, dashboarders, and Splunkbase app creators – the Builder ...