Splunk Search

How to get added count for the fields from previous count over a period of time?

madhu06
Engager

I am having a issue tracker for tracking all opened issues and the query for the same is below:

search issue_status=open| timechart span=1d count(issue_id) by issue_category | addtotals 

I need to see addtotals as count of total open issues for the current day and with the sum from previous days ie. each day it should show total count of all open issues so far (today's + sum till yesterday's).
Could you please help me?

0 Karma

to4kawa
Ultra Champion
issue_status=open earliest=-1d@d
| eval date=if(_time < relative_time(now(),"@d"),"yeasterday","today")
| stats count(issue_id) as id by date issue_category
| xyseries issue_category date id

and add your calculation.

0 Karma
Get Updates on the Splunk Community!

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

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...