Hi @mimo
So I am not sure how to do that (or if it’s even possible) using InfluxQL. I did something similar using Flux here using the elapsed function. Instead of:
|> filter(fn: (r) => r["_value"] == 0)
You would have a filter where the value is > 5000 (or whatever you wish).
Maybe @Anaisdg or @Zoe_Steinkamp or @scott can tell us how (if?) this can be done using InfluxQL.
