I have a time series data, and I would like to display the last measured data if it is not older than eg. 1 hour.
I set up the query like in the picture.
Without the TIME filter, it works correctly presenting the last value.
With the TIME filter it gives no value back, even if there are data within one hour.
I entered TIME>now-1h, but in the SQL preview I see TIME>NULL.
SELECT TEMPL_T FROM zugisql.templomter WHERE TIME > NULL ORDER BY TIME DESC LIMIT 1
I certainly miss something…