I want to filter out transactions(where status ="InProgress ") that started in the previous slot and those completed in the next slot. basically if earliest=04/27/2021:12:0:0 and latest=04/28/2021:12:0:0 I want to display only those transactions which started in the specified period and are in completed status. I have a previous query like this : stats earliest(_time) as InTime ,latest(_time) as OutTime, values(eval(if(code="E100" OR code="E101" OR code="E102"))) as error, count(eval(code="E010")) as messageReceived, count(eval(code="E030" OR code="E031")) as messageCompleted | sort - InTime
... View more