Percentage calculation in kibana using json Inputs

Elastic Stack Kibana
1

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

2

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

3

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

4

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