Prometheus calculate value longer than X in Grafana

[beutel31]

I would like to have Prometheus show a value in Grafana that is over 60% and longer than a minute, I haven’t found a solution yet.

I tried that “min(prtg_sensor_lastvalue{id=“2053”} > 60)” but I only get the value which is over 60% but every point and not the value that is longer than a minute.

Like this:

[ventura]

You could try something like this:

sgn(prometheus_query{...} offset 1m) * abs(prometheus_query{...})

This will hide data for the first minute of each connected value group, so you might need to play around with this idea to find out what works.

[beutel31]

Unfortunately this did not work