Create views on statuses with math

[Murali_Y]

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

2. 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?

Thanks.

[devon.thomson]

This looks like a great use case for Lens formula!

You could also try to use a scriped field