Hi everyone, I have a search on approval success rates : stats count as TOTAL,count(eval(criteria)) as APPROVED | eval APPROVEDPERCENT=if(TOTAL>0,round((APPROVED*100)/TOTAL,2),100) I would then get the percentage of approved transactions on the time range. I would like to raise an alert when this approvedpercent is less than 50 in 3 consecutive span of 15min. I have tried the following based on another post: | timechart span=15min max(APPROVEDPERCENT) as APPPERCENT | where APPPERCENT<50 | stats count as NumberNOK (that I could run with the alert trigger condition as NumberNOK>=3 on last 45min) But I ran this search on a time range where approval is 100% and NumberNOK is null . Anyone can help on this search? thank you in advance ... View more