Reporting

Implementing conditions between different lines in stats command

jarrebola
Explorer

I have extracted this data with the stats command.

jarrebola_1-1716884361179.png

The goal is to compare left timestamp (start time) of the second line with right timestamp of previous line (end time) and the condition will be like this

if (start next row > end previous row) 1:0; in this way I want to mark this lines with bool=1 if not bool=0

Please someone has some suggestion about how can I implement this?

Thanks in advance

 

 

Labels (1)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| streamstats window=1 current=f values(right_time) as previous_right_time

View solution in original post

jarrebola
Explorer

I already figured out ..

Thanks for your help ITWhisperer.

jarrebola_0-1716886398846.png

 

0 Karma

jarrebola
Explorer

Hi ITWhisperer, first I want to say Thanks !, now I have this with your suggestion, 

jarrebola_0-1716885750469.png

Now I need to compare the start time with previous right_time to set the bool field for every line, how I can do this please?

Thanks you !

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| streamstats window=1 current=f values(right_time) as previous_right_time
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

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

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...