I have this points.
select * from EXECUTION
name: EXECUTION
time Category Value sequence
2020-04-30T22:00:00Z Event UNAVAILABLE 2
2020-05-01T06:00:00Z Event READY 3
2020-05-01T06:10:00Z Event ACTIVE 4
2020-05-01T09:30:00Z Event STOPPED 5
2020-05-01T12:00:00Z Event READY 6
2020-05-01T12:10:00Z Event ACTIVE 7
2020-05-01T13:00:00Z Event FEED_HOLD 8
2020-05-01T14:00:00Z Event ACTIVE 9
2020-05-01T16:00:00Z Event STOPPED 10
If I execute the follwing query
select * from
(
select last(“Value”) as Stato from
(
select Value from( SELECT Value, sequence FROM “EXECUTION” WHERE time> now() -24h ),
(select last(Value) as Value from ( select Value, sequence from “EXECUTION” where time < now() -24h) )
) WHERE (“Value” != ‘null’) GROUP BY time(1m) fill(previous)
)
If i filter (where time > now() - 24h) the result is empty.
Could someone explain me this behavior kindly ?
