Splunk Search

single table containing count for today, avg count for last 7 day and deviation of today vs last 7 day avg ------ by ID and Trading Partner

sayanidasgupta
Explorer

Single Table containing -
stats count by DID TN - for today
avg count for last 7 day by DID and TN
deviation of today vs. Last 7 day avg count.

e.g.

DID TN Today Last7Dayavg Deviation - Today vs Last7dayavg
123 A 230 330 -100
124 B 90 70 20

Tags (1)
0 Karma
Get Updates on the Splunk Community!

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

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...