Percentage calculation in kibana using json Inputs

How to calculate the failure percentage in kibana using the json inputs ?
The kql query for success is statusCode:200 nd for failure is NOT STATUSCODE:200.
I need to calculate the (failure/total)×100.

I'm using kibana 7.10.2 version nd
I need to calculate the percentage without using the scripted fields in the index management

Hi @Nijanthan

If you can't use scripted field or better runtime field for that then you will have to create the new "failureRate" percentage field at ingest time. For that you will probably need an ingest pipeline.

Cheers,
Sébastien

Is there any other way to calculate percentage in data table ?