I have an alert for incoming requests for something. These requests happen every 5 minutes, but there are less requests during the night.
I have the following settings:
SELECT count(name) FROM Transaction WHERE transactionSubType = 'Custom' AND name = 'OtherTransaction/Custom/Requests' When the query returns a value below 1 for at least 30 mins.
Now, this is sometimes triggered during the night when it is perfectly normal not to have any incoming requests. What I want is that I am not alerted during the night (threshold should be different), but during the period of 08.30 - 21.00 I am. I cannot use the baseline as it also alerts when I have more requests than the baseline. I only want be alerted when it goes below the baseline.
How do I accomplish this?