topic Implementing conditions between different lines in stats command in Reporting

Implementing conditions between different lines in stats command

jarrebola — Tue, 28 May 2024 08:22:30 GMT

I have extracted this data with the stats command.

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

Re: Implementing conditions between different lines in stats command

ITWhisperer — Tue, 28 May 2024 08:28:19 GMT

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

Re: Implementing conditions between different lines in stats command

jarrebola — Tue, 28 May 2024 08:44:55 GMT

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

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 !

Re: Implementing conditions between different lines in stats command

jarrebola — Tue, 28 May 2024 08:53:44 GMT

I already figured out ..

Thanks for your help ITWhisperer.