# Numerical range in Kibana 3 not working **URL:** \ **Category:** Elasticsearch\ **Created:** [July 22, 2014, 4:24pm UTC](https://discuss.elastic.co/t/numerical-range-in-kibana-3-not-working/18799 "2014-07-22T16:24:20Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![deepak\_deore](https://avatars.discourse-cdn.com/v4/letter/d/9fc29f/32.png) [@deepak\_deore](https://discuss.elastic.co/u/deepak_deore)\ **Post date:** [July 22, 2014, 4:24pm UTC](https://discuss.elastic.co/t/numerical-range-in-kibana-3-not-working/18799/1 "2014-07-22T16:24:20Z")
My tomcat access logs have last field as "%D - Time taken to process the request, in millis". I am trying to filter the logs which took more than some number of milliseconds, but it is showing all the logs as a result, I am trying as per lucene "Range Searches" [http://lucene.apache.org/core/2\_9\_4/queryparsersyntax.html](http://lucene.apache.org/core/2_9_4/queryparsersyntax.html) I tried below queries but it shows all the logs. timetaken: [1000 TO \*] timetaken: [1000 TO 5000] timetaken: ['1000' TO \*] -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/0b6cf974-2928-4162-8d2a-a3566fd75264%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/0b6cf974-2928-4162-8d2a-a3566fd75264%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![deepak\_deore](https://avatars.discourse-cdn.com/v4/letter/d/9fc29f/32.png) [@deepak\_deore](https://discuss.elastic.co/u/deepak_deore)\ **Post date:** [July 25, 2014, 10:54pm UTC](https://discuss.elastic.co/t/numerical-range-in-kibana-3-not-working/18799/2 "2014-07-25T22:54:51Z")
By default logstash takes all input as a string, added ":int" to the fields which i wanted as number. eg. %{NUMBER:apache\_bytes:int} %{NUMBER:apache\_response\_time:int} Ref: [Redirecting to Google Groups](https://groups.google.com/forum/#!topic/logstash-users/2ewrcovttSY) On Tuesday, 22 July 2014 09:24:20 UTC-7, deepak deore wrote: > My tomcat access logs have last field as "%D - Time taken to process the > request, in millis". I am trying to filter the logs which took more than > some number of milliseconds, but it is showing all the logs as a result, I > am trying as per lucene "Range Searches" > [Apache Lucene - Query Parser Syntax](http://lucene.apache.org/core/2_9_4/queryparsersyntax.html) > > I tried below queries but it shows all the logs. > > timetaken: [1000 TO \*] > > timetaken: [1000 TO 5000] > > timetaken: ['1000' TO \*] -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/6ce210aa-9072-4f3e-b1d0-1b69e65ba568%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6ce210aa-9072-4f3e-b1d0-1b69e65ba568%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:13am UTC](https://discuss.elastic.co/t/numerical-range-in-kibana-3-not-working/18799/3 "2017-07-06T01:13:00Z")