I have an event lets say his time is 15/09/2022 13:10:00 lets call it E and current time is 14:15:00 and I am writing query to get the event that finished/still work in the last hour so I want to get event E since it is still working but it is time isn’t in the window.
there is no state column in the measurement.
Hello @MohamedAshraf794,
Welcome!
I’m sorry, I’m having trouble understanding your problem. Could explain it more please?
Thank you.
Best,
Anais
we are trying to calculate a duration for multiple events in last hour but we are facing problem that there is an event start before this hour and continued to work until 30 minute ago.
the problem is we can’t catch this 30 minutes in the duration since event time is before range start.
