# Percentage calculation in kibana using json Inputs

**URL:** <https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234>\
**Category:** Kibana\
**Created:** [September 27, 2021, 1:06pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234 "2021-09-27T13:06:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nijanthan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nijanthan/32/94663_2.png) [@Nijanthan](https://discuss.elastic.co/u/Nijanthan)\
**Post date:** [September 27, 2021, 1:06pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234/1 "2021-09-27T13:06:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [September 27, 2021, 2:27pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234/2 "2021-09-27T14:27:51Z")

</div>

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](https://www.elastic.co/guide/en/kibana/current/lens.html#lens-formulas) feature, alternatively you may look into [TSVB advanced functions (like Filter Ratio)](https://www.elastic.co/guide/en/kibana/master/tsvb.html#tsvb-function-reference).

---

<div class="post-metadata">

**Author:** ![Nijanthan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nijanthan/32/94663_2.png) [@Nijanthan](https://discuss.elastic.co/u/Nijanthan)\
**Post date:** [October 12, 2021, 6:18am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234/3 "2021-10-12T06:18:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [October 12, 2021, 8:04am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234/4 "2021-10-12T08:04:05Z")

</div>

TSVB link works for 7.10 too.

---

<div class="post-metadata">

**Author:** ![Nijanthan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nijanthan/32/94663_2.png) [@Nijanthan](https://discuss.elastic.co/u/Nijanthan)\
**Post date:** [October 12, 2021, 9:06am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234/5 "2021-10-12T09:06:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 9, 2021, 9:07am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana-using-json-inputs/285234/6 "2021-11-09T09:07:37Z")

</div>

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