With transformation, is it possible to filter data older than a certain period?
I would like to reproduce the same behavior of the SQL clause:
WHERE "time_frame" > (NOW() - INTERVAL '5 minute')
But I would like to avoid filtering the data in the selection query, which is what I am doing at the moment, because I would like to use the results from another panel in the dashboard as data source.
In the following image the maximum I got so far, obviously getting an error since it not expand the
now() variable, or even make the computation: