Percentage calculation in kibana using json Inputs

Nijanthan · September 27, 2021, 1:06pm

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

Marco_Liberati · September 27, 2021, 2:27pm

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).

Nijanthan · October 12, 2021, 6:18am

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

Marco_Liberati · October 12, 2021, 8:04am

TSVB link works for 7.10 too.

Nijanthan · October 12, 2021, 9:06am

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

system · November 9, 2021, 9:07am

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