Hi, I am trying to setup an alert and notify by email, when count of last 3hrs is greater than rolling average of last 7 days using the below query. Query is working fine but in the alert is not working/not getting triggered I tried as below Alert Config Trigger conditions in alert Screen are, Trigger alert when ,Custom option ,search alert==true Query: sourcetype="cloudwatch" index=***** earliest=-6d@d latest=@d |bucket _time span=1d |stats count by _time |stats avg(count) as SevenDayAverage |appendcols [search sourcetype="cloudwatch" index=***** |stats count as IndividualCount] |eval alert = if((IndividualCount.SevenDayAverage),"true","false") SevenDayAverage IndividualCount alert 5 1139 true
... View more