Ratio of different event count

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.

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

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

thanks, that worked great.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.