Splunk Search

How to persist fields after group by command?

kimsej
Explorer

I have a query that does a group by, which allows the sum(diff) column to be calculated. 

[search] | stats sum(diff) by X_Request_ID as FinalDiff:

Screen Shot 2022-09-15 at 6.28.02 PM.png

From here, how can I list out only the entries that have a sum(diff) > 1? My attempt looks like:

[search] | stats sum(diff) by X_Request_ID as FinalDiff |where FinalDiff>1
 
My issue is that after the group by happens, the query seems to forget about the grouped sum and so I cannot compare it to 1. 
Labels (1)
0 Karma

thesplunkmonkey
Path Finder

Switch the order up a bit and it should work for you.

| stats sum(diff) as FinalDiff by X_Request_ID  |where FinalDiff>1

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...