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!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...