Complex Boolean operators on alert conditions

My previous answer assumed OR conditions (if hit thresholdA OR thresholdB). If you want to do a AND like condition, which as I re-read the question, might be what you are asking, that may depend on the situation.

Here I'm assuming you want to basically consider any Certs that have daystoexpire < -100 to just be ignored in all cases, in other words anything under -100 is invalid. So you can edit the "Valid value range" for daystoexpire  to be "-100 to blank". That way you will just get a NaN if it's less then -100, and still have an easily changed main thresholds of < 30.

6 minutes ago, Cole McDonald said:

I'd still like to know that there's an instance and how long ago it had expired, just not alert on it.  I'll definitely play with the virtual datapoints as a possible workaround though.  That's got some promise.

Sure, then I would remove the threshold on daystoexpire and let that be for information/graphing use. Then create a complex DataPoint with the expression of "daystoexpire" which has the valid range and thresholds for alerting.

I'm all for more complex conditions for thresholds!

But as a nice workaround you can have multiple DataPoints that just report the same value but have different thresholds. For example you have have the normal daystoexpire to be > -100, and create a Complex DataPoint called "daystoexpireSoon" that has the Expression of "daystoexpire" (aka, use the same value) and set it's threshold of <300. And you can keep doing that for all the various thresholds.

P.S. You can also remove the threshold for daystoexpire and create daystoexpireOld along with daystoexpireSoon, that do have thresholds, so it's clearer what each means.

I'd still like to know that there's an instance and how long ago it had expired, just not alert on it.  I'll definitely play with the virtual datapoints as a possible workaround though.  That's got some promise.

Here's what I used... working like a champ:

if( gt( DaysUntilExpire,(0-60) ), DaysUntilExpire, unkn() )

<= 30 14 7 for the alerting drastically reduced the number of alerts that are non-actionable.  Thank you Mike!