Create views on statuses with math

Hello all,
I am newbie to Kibana. I am trying to create table or view for below condition:

  1. In our logs we are writing below info:
    "Status": 100 for pass
    "Status": 200 for fail
    "Status": 300 for stuck due to issue

So sum of all 3 above statuses will give my total transactions i.e. Status 100 + 200 + 300

  1. I need to create below view:

Successful execution % = Status:100/(Status:100 + Status:200 + Status:300) * 100

Can you please guide me in achieving this?


This looks like a great use case for Lens formula!

You could also try to use a scriped field