Help with an Alert
SummaryAlert for number of emails routed to a Queue
Can anyone maybe help me with setting up an alert? I have a simple report showing incidents that arrived in specific queues and am trying to create an alert that sends an email every time 10 or more emails were added to the queues within the last hour.
You will see I created variables for start and end times, but the exception I tried would not work:
(count( if(queue_stats.created>$start_time & queue_stats.created<$end_time,1, 0)))/((date_diff($end_time, $start_time))/3600) is greater or equals 10