# The "is between" & "is not between" operator function not showing up

**URL:** <https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003>\
**Category:** Kibana\
**Created:** [December 15, 2017, 3:13pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003 "2017-12-15T15:13:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![cchooks2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cchooks2/32/21987_2.png) [@cchooks2](https://discuss.elastic.co/u/cchooks2)\
**Post date:** [December 15, 2017, 3:13pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003/1 "2017-12-15T15:13:55Z")

</div>

Hi,

We are running Kibana 5.5 and i see the "is between" & "is not between" operators show up on some of my services, but not all. Why is that?

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)\
**Post date:** [December 15, 2017, 3:17pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003/2 "2017-12-15T15:17:28Z")

</div>

Hi Steven,

which filters are available depend on the type of the field.  
Most likely you have selected a text/keyword field and thus don't see those two filters. If you try selecting a numeric field or e.g. an ip field, you should see those filters.

Cheers,  
Tim

---

<div class="post-metadata">

**Author:** ![cchooks2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cchooks2/32/21987_2.png) [@cchooks2](https://discuss.elastic.co/u/cchooks2)\
**Post date:** [December 15, 2017, 3:50pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003/3 "2017-12-15T15:50:44Z")

</div>

Hi Tim,

Thanks for the quick reply. I will change it to a number field.

Another question, in some cases i am also seeing that the "visualize" button does not show up underneath on some fields i've extracted. Could you help me understand why?

Thanks again.

---

<div class="post-metadata">

**Author:** ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)\
**Post date:** [December 15, 2017, 3:56pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003/4 "2017-12-15T15:56:25Z")

</div>

Hi,

the most likely reason why a field is not "visualizable" from the Discover app is the following:

It is a field of type text (this means an analyzed string), Elasticsearch cannot aggregate on those by default. In this case you might still have the same field also in an unanalyzed version (most often with the suffix `.keyword` or `.raw` but the same name). You can just go to the visualize app and do a terms aggregation on that unanalyzed field in this case (but Discover won't show you the button).

Cheers,  
Tim

---

<div class="post-metadata">

**Author:** ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)\
**Post date:** [December 15, 2017, 3:58pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003/5 "2017-12-15T15:58:26Z")

</div>

I've tried to explain the effect of analyzing on strings and thus the search, in [this tutorial](https://www.timroes.de/2016/05/29/elasticsearch-kibana-queries-in-depth-tutorial/). And since Elasticsearch version 5 analyzed strings are not aggregatable by default anymore, though you could [enable it](https://www.elastic.co/guide/en/elasticsearch/reference/current/fielddata.html).

---

<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:** [January 12, 2018, 3:58pm UTC](https://discuss.elastic.co/t/the-is-between-is-not-between-operator-function-not-showing-up/112003/6 "2018-01-12T15:58:33Z")

</div>

Closed on January 12, 2018, 3:58pm UTC

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