Percentage calculation in kibana using json Inputs

How to calculate the failure percentage in kibana using the json inputs ?
Like the failure is NOT statusCode:200 and success is statusCode:200. I need to calculate (failure/total)*100

Hi @Nijanthan ,

Currently it is not possible to perform that kind of computation in visualize.
If you have a new 7.15 instance of Kibana you could leverage the new Lens Formula feature, alternatively you may look into TSVB advanced functions (like Filter Ratio).

I'm using kibana 7.10.2 version, Is there any possibilities to calculate percentage ? (Without using the scripted fields)

TSVB link works for 7.10 too.

Can you please explain me how to use tsvb to calculate percentage in a data table