Dividing counts of two different queries in kibana

I am trying to create a lucene expression for displaying division on counts of two queries. Both queries contain textual information and both results are in message field. I am not sure how to write this correctly. So far what i have done is without any luck -


for first query message contain text as - "404 not found"

for second query message contain text as - "500 error"

what i want to do is count(404 not found)/count(500 error)

I would appreciate any help.

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