Splunk Search

How to subtract values from two different fields but successive fields as shown below?

dinkarvidyarthy
New Member

group count SubTotal Desired_Field
WEEK1 9 36 36
WEEK2 1 36 27
WEEK3 3 36 26
WEEK4 7 36 23
WEEK5 2 36 16
WEEK6 1 36 14
WEEK7 2 36 13
WEEK8 3 36 11
WEEK9 2 36 8
WEEK10 1 36 6
WEEK11 1 36 5
WEEK12 4 36 1

I have Group, count and SubTotal with me. I want to get the values as shown in Desired_Field? Please help with the query. Thanks

0 Karma
Get Updates on the Splunk Community!

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened Audit Trail v2 wasn’t written in isolation—it was shaped by your voices. In ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...