# How to use greater than operator in Json Input in Kibana visualisation to get the data which is greater than a value

**URL:** <https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928>\
**Category:** Kibana\
**Created:** [October 13, 2020, 3:25pm UTC](https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928 "2020-10-13T15:25:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dubru](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dubru/32/45511_2.png) [@Dubru](https://discuss.elastic.co/u/Dubru)\
**Post date:** [October 13, 2020, 3:25pm UTC](https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928/1 "2020-10-13T15:25:30Z")

</div>

My actual requirement is I would like to display the data in kibana visualisation only if the `response.time` is greater than `10` seconds  
I've the field `response.time` and I am using this field to get the average response time in kibana data table visualisation.

I would like to use a greater than operator `>` in Json Input in kibana visualisation Data table so that it shows the data only if the response time is greater than 10 seconds.

How can we do this? if the Json Input is not appropriate way to achieve this, what are the possibilities to fix this?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [October 13, 2020, 5:30pm UTC](https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928/2 "2020-10-13T17:30:29Z")

</div>

It sounds like you can achieve this by adding a filter using the "Add filter" button below the search bar, then selecting `response.time` and `is between`. The filters are saved along with the visualization.

---

<div class="post-metadata">

**Author:** ![Dubru](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dubru/32/45511_2.png) [@Dubru](https://discuss.elastic.co/u/Dubru)\
**Post date:** [October 13, 2020, 6:19pm UTC](https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928/3 "2020-10-13T18:19:35Z")

</div>

I am using `Average` aggregation for Y-axis and `url.path` for X-axis values. I've attached the screenshot as well.

 ![Screenshot 2020-10-13 at 11.53.00 PM](https://us1.discourse-cdn.com/elastic/original/3X/9/4/94901ebbfaed298b7849d5c7233a65d60972c87c.png)

So here I want to get the average response time URLs whose actual response time is greater than 10 seconds.

If I add the filter like you said, it is not giving the expected output.

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [October 14, 2020, 7:26am UTC](https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928/4 "2020-10-14T07:26:18Z")

</div>

OK, if I understand correctly, you want to filter the `url.path` buckets by the average duration? This is possible using the bucket selector aggregation ([https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html)) but it's not supported at the moment in Kibana. This is the corresponding feature request: [https://github.com/elastic/kibana/issues/17544](https://github.com/elastic/kibana/issues/17544)

---

<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 11, 2020, 7:26am UTC](https://discuss.elastic.co/t/how-to-use-greater-than-operator-in-json-input-in-kibana-visualisation-to-get-the-data-which-is-greater-than-a-value/251928/5 "2020-11-11T07:26:29Z")

</div>

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