Ratio of different event count

Dror_Tirosh · February 11, 2022, 1:18pm

I have a log of various event
I need to find the ratio of "good events" from "bad events". I want to graph it over time.

For the "vertical axis formula", I need something like
count(eventName=="bad) / count(eventName=='good')

How can I do it ? while I can create a global Filter by eventName, I can't find a way to create it inside the axis formula.

Tomo_M · February 11, 2022, 1:41pm

You may find explanation in "Common formulas". kql can be used in Formula.

count(kql='eventName: true ')/count(kql='eventName: false ')

Dror_Tirosh · February 15, 2022, 10:31am

thanks, that worked great.

Topic		Replies	Views
Percentage metric in Kibana Kibana	2	1325	July 21, 2020
I have two events logged into elasticsearch, I want to visualize the ratio of these two events in Kibana Elasticsearch	0	327	March 25, 2015
Visualize: Divide values of 2 filters Kibana	3	9293	November 3, 2017
Divide two counts of the same index with different filters Kibana	3	908	January 21, 2023
Graph a ratio between two counts Kibana	7	10334	June 21, 2017