Alerts Don't Match Results In Query

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:




metric:“Column B”


In the database itself, there is no negative values or decimals. There are no records below 400