Selecting the last value of a time series, with time limit

[ecsmiki]

I found the solution, the builder did not work, but I could add in the sql editor: SELECT TEMPL_T, $__time(TIME) FROM zugisql.templomter WHERE TIME > NOW()-INTERVAL 1 HOUR