# Return value True or False based on Kibana Script

**URL:** https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400
**Category:** Kibana
**Created:** [May 6, 2020, 7:55pm UTC](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400 "2020-05-06T19:55:31Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![vdalvi](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@vdalvi](https://discuss.elastic.co/u/vdalvi)
#### Post date: [May 6, 2020, 7:55pm UTC](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400/1 "2020-05-06T19:55:32Z")

</div>

Hi,

How can I aggregate to return value as True if doc\_count != 0 and False if doc\_count == 0 in Kibana response?

Below is my query

```auto
{
  "query": {
    "range": {
      "timestamp": {
        "gte": "now-1h/h"
      }
    }
  },
  "size": 0,
  "aggs": {
    "get_cmtsId": {
      "terms": {
        "field": "cmtsId",
        "size": 2
      },
    "aggs": {
      "every30min": {
        "date_histogram": {
          "field": "timestamp",
          "fixed_interval": "30m"
        },
        "aggs": {
          "my_filter": {
            "bucket_selector": {
              "buckets_path": {
                "the_doc_count": "_count"
              },
              "script": "params.the_doc_count != 0"
              }
            }
          }
        }
      }
    }
  }
}

```

---

<div class="post-metadata">

### Author: ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [May 6, 2020, 9:31pm UTC](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400/2 "2020-05-06T21:31:03Z")

</div>

Yes, have you tried using scripted fields  
[https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-operators-boolean.html#painless-operators-boolean](https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-operators-boolean.html#painless-operators-boolean)

---

<div class="post-metadata">

### Author: ![vdalvi](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@vdalvi](https://discuss.elastic.co/u/vdalvi)
#### Post date: [May 6, 2020, 11:20pm UTC](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400/3 "2020-05-06T23:20:25Z")

</div>

Hi Rashmi, thanks I created the scripted field, however I am unsure how to call it in the kibana query so I can see the value as True or False in the result of the query ?

The scripted field is working as expected when I tested it in the test script section of scripted fields.

I can see the field created in the Discover section as well.

---

<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: [June 3, 2020, 11:20pm UTC](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400/4 "2020-06-03T23:20:35Z")

</div>

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