# Calculate ratio of success in a field kibana

**URL:** <https://discuss.elastic.co/t/calculate-ratio-of-success-in-a-field-kibana/117417>\
**Category:** Kibana\
**Created:** [January 29, 2018, 8:52am UTC](https://discuss.elastic.co/t/calculate-ratio-of-success-in-a-field-kibana/117417 "2018-01-29T08:52:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cilzzz](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@cilzzz](https://discuss.elastic.co/u/cilzzz)\
**Post date:** [January 29, 2018, 8:52am UTC](https://discuss.elastic.co/t/calculate-ratio-of-success-in-a-field-kibana/117417/1 "2018-01-29T08:52:32Z")

</div>

Hi all,

i have a field named Status that contains values (ok and failed), i want to visualise the ratio of success under a metric visualisation (i dont want to use a pie chart) is that possible through scripted field or logstash.

my formula will be:  
((count when status=ok)/total count)\*100

any help

thanks in advance

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [January 29, 2018, 9:48am UTC](https://discuss.elastic.co/t/calculate-ratio-of-success-in-a-field-kibana/117417/2 "2018-01-29T09:48:54Z")

</div>

Hi,

This definitely should work using scripted fields. Here is the documentation for it.  
[https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html)

You need to add a field, choose painless and write your script.

 ![scripted_field](https://us1.discourse-cdn.com/elastic/original/3X/5/e/5e5791b7f162fe8048a2e5deaf74167ee056f27c.jpg)

Here is the language/syntax specification:  
[https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-specification.html](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-specification.html)

Cheers,  
Bhavya

---

<div class="post-metadata">

**Author:** ![cilzzz](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@cilzzz](https://discuss.elastic.co/u/cilzzz)\
**Post date:** [January 29, 2018, 10:32am UTC](https://discuss.elastic.co/t/calculate-ratio-of-success-in-a-field-kibana/117417/3 "2018-01-29T10:32:39Z")

</div>

thank you but as far as i know the scripted field doesn't return the count of a string inside a field what i am thinking to do is to add another field that have the same value of the Status field then use gsub filter to replace OK by 1 and Failed by 0 then convert it to integer.  
finally i can use my scripted field like this:

(doc['Field'].sum/doc['Field'].length)\*100 hope this work this will the success rate

---

<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:** [February 26, 2018, 10:33am UTC](https://discuss.elastic.co/t/calculate-ratio-of-success-in-a-field-kibana/117417/4 "2018-02-26T10:33:04Z")

</div>

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