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
please suggest the query to add an alert when successrate is 95.00% in one hour span
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."%"
hi @ITWhisperer
i want to send an alert when result is below 95.00%
| where successrate < 95
If you get any results, raise an alert