Splunk Search

Advanced search for average and greater than

gagi76
New Member

Hi,

can someone point me to the advanced search. I need to search for transactions from current day that are greater than average from last month?
For now i have starting search for average from last month... and don't know how to proceed further.

earliest="04/01/2016:00:00:00" latest="04/30/2016:23:59:59" | stats avg(Price)
Tags (4)
0 Karma
1 Solution

somesoni2
Revered Legend

Something like this

index=yourindex sourcetype=yoursourcetype earliest=@d latest=now | where Price> [search index=yourindex sourcetype=yoursourcetype earliest=-1mon@mon latest=@mon | stats avg(Price) as avg | return $avg ]  | table ..put required fields here...

View solution in original post

0 Karma

somesoni2
Revered Legend

Something like this

index=yourindex sourcetype=yoursourcetype earliest=@d latest=now | where Price> [search index=yourindex sourcetype=yoursourcetype earliest=-1mon@mon latest=@mon | stats avg(Price) as avg | return $avg ]  | table ..put required fields here...
0 Karma

gagi76
New Member

Great, thanks! Actually it worked with this one:

yoursourcetype earliest=@d latest=now | where Price > [search  earliest=-1mon@mon latest=@mon | stats avg(Price) as avg | return $avg ]  | table ..put required fields here...
0 Karma
Get Updates on the Splunk Community!

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...