Splunk Search

How to get Total Sum of Error Type Counts per day?

mhamano
Explorer

I'm trying to add a column to the right of OTHER, which sums up the entire row counts of each errorType per day. So for example, the first value in a column farthest to the right would be the total count for api_error + approved + declined + expired_Card etc. for each day.

My current search is gateway=firstdata errorType!=null event=transactionCompleted | timechart count by errorType span="1m"

alt text

0 Karma

somesoni2
Revered Legend

Look at the addtotals command.

My current search is gateway=firstdata errorType!=null event=transactionCompleted | timechart count by errorType span="1m" | addtotals 

http://docs.splunk.com/Documentation/Splunk/6.3.3/SearchReference/Addtotals

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...