I am trying to calculate the percentile of success rate, using 2 fields count on one condition.
Expl : I have 1000 hits
time difference, flag, name
I need to calculate in the below format, Please suggest me how to do it in Elasticsearch/Kibana/Grafana
Success Rate Percentile = (count(time difference <=5 AND flag=Y)/count(*))*100
Thanks In Advance