alert

[vinod_52791]

I am getting success percentage from the query as 97.00% and my requirement is to add an alert when success percentage is below 95.00%

i am getting success % from below query

vinod_52791_0-1637320029885.png

please suggest the query to add an alert when successrate is 95.00% in one hour span

[ITWhisperer]

Don't add the % to the successrate field, then you can do numeric comparisons on it. If you still want it displayed with the % sign, you can use fieldformat.

| eval successrate=100*successcount/total
| fieldformat successrate=successrate."%"

[vinod_52791]

hi @ITWhisperer 

i want to send an alert when result is below 95.00%

[ITWhisperer]

| where successrate < 95

If you get any results, raise an alert