Dynamic Alert Thresholds Based on Query


Currently, alerts are triggered when the value of a column from a query exceeds, drops below, or equals a fixed value. It might also be useful if the alert threshold could be set dynamically to a value obtained from the query.

For example, one could add a column to a query called “threshold_value” that is XX% of the previous day’s value. Then, when defining the alert, one could set the alert threshold to be the value of the “threshold” column, rather than a fixed value.

I think this feature would make alerts more useful, as I often have cases where values fluctuate widely based on (e.g.) day of the week, so a fixed alert threshold doesn’t really work.