I have a question about a specific query and alert. I’m receiving constant positioning data to one database that I can graph in real-time with the query SELECT “coord_x” FROM “position” WHERE $timeFilter.
I’d like to trigger an alert when that value is above 10,000 for over 5 seconds.
“WHEN max() OF query(A, 5s, now) IS ABOVE 10000” registers and alerts the spikes over 10000, but that’s too many false positives. I’m thinking I need to change the query to give me one avg() value over the last 5 seconds but I can’t get it to work.
Any help? Thanks.