How CnosDB filters results after using timestamp_repair
After I have repaired the data using the timestamp_repair function, filtering the result set using the WHERE keyword does not give me the correct results.
CnosDB How to Calculate Derivatives through a Time Window
I would like to use the following SQL to take the derivative of the data, but EXTRACT does not work as expected, is there an alternative way?