Can I calculate fractional ratios for visualizations in Kibana?


#1

Good Morning,

I'm trying to understand whether what I'm trying to do is possible through Kibana.

I'm using the ELK stack to track service desk tickets. Each ticket has an open date and a closed date. I can plot open and closed tickets over time no problem. What I'd like to do, though, is be able to plot the ratio between the number of opened and closed tickets for a given time period. The formula is simple: count(tickets with closed date within time period)/count(tickets with open date within time period). I'd like to see this metric in a line chart.

Can I achieve this using Kibana?

Thank you in advance!

Regards,

Andrew


(Mark Walkom) #2

You could probably do it via a scripted field - https://www.elastic.co/guide/en/kibana/current/managing-fields.html#create-scripted-field


(system) #3