elasticsearch – Kibana Monitor and Alerting : Elastic Search Query to calculate average

I am new to kibana queries and come across a requirement as follows,
I have two terms in my kibana logs as follows :

  1. “test_service_name.keyword” : The count of this term(with value = “TestService”) will give total number of calls to a particular service

  2. “failed_test_service_name.keyword” : The count of this term(with value = “TestServiceFailure”) will give total number of failure calls to a particular service

I need to create an alert, if average failures > 25

i.e. total of “failed_test_service_name.keyword” / total of “test_service_name.keyword” * 100 > 25

How can I achieve this

Read more here: Source link