I have an avg alert that should alarm when it is below 6000 in a 5 minute sample. I have a MySQL query doing a select on a column. My results in the chart are correct, however, my alert is reading way below or way high. What do i need to do for the alert to be based off the actual result?
An example of a failure:
timeMs:“-929.827ms”
matches:Array[1]
0:Object
metric:“Column B”
value:-0.4677773921092213
In the database itself, there is no negative values or decimals. There are no records below 400