I have a alert condition configured as below, but even after meeting the condition alert notification is not triggering for the first time, after 2 or 3 events its triggering. Can somebody please help me, what am i missing here?.
alert condition:
NRQL> SELECT count(newrelic.timeslice.value) AS `Custom/Sidekiq/DeadQueue` FROM Metric WHERE metricTimesliceName = 'Custom/Sidekiq/DeadQueue' AND `entity.guid` = 'xyz'
Metric query result is > 0.0 at least once in 1 min
As the query returns 1 for the first event.
Alert condition aggregation settings needed to be tuned according to the frequency of data ingested: