# Kibana issues on showing results **URL:** \ **Category:** Kibana\ **Created:** [June 20, 2016, 3:26am UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257 "2016-06-20T03:26:34Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\ **Post date:** [June 20, 2016, 3:26am UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/1 "2016-06-20T03:26:34Z")
I have been making some visualizations on kibana, it runs smooth at first; however, when time goes on, some graphs displayed something not in sense. It displays the message that `"No results displayed because all values equal 0"`. The problem is it did receives input but can only show results for not raw field. Figure 1: With raw field for hostname ![](https://us1.discourse-cdn.com/elastic/original/2X/8/8889e2491826cb911b816f6a560060d3f3e3edcd.PNG) Figure 2: Without raw field for hostname, however, my machine hostname is called Win-07llqen2sjb, but not 2 machines. ![](https://us1.discourse-cdn.com/elastic/original/2X/c/c51ec0a19825b84240dc135f2b05e3d32412a857.PNG) ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [June 20, 2016, 7:11pm UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/2 "2016-06-20T19:11:20Z")
Do you have any filters or searches that would limit the number of results? ---
**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\ **Post date:** [June 21, 2016, 3:14am UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/3 "2016-06-21T03:14:46Z")
Here is my conf file ``` input { jdbc { jdbc_driver_library => "C:\Users\Administrator\Downloads\Microsoft JDBC Driver 4.2 for SQL Server\sqljdbc_4.2\enu\sqljdbc42.jar" jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc_connection_string => "jdbc:sqlserver://WIN-07LLQEN2SJB\SQLEXPRESS:1433;user=sa;password= ********" jdbc_user => "sa" jdbc_password => " ********" schedule => "* * * * *" statement => "Select servername, total_memory_mb, sql_memory_mb, (sql_memory_mb*100/total_memory_mb) as sql_memory_p from DISK.dbo.memory_activity" jdbc_paging_enabled => "true" jdbc_page_size => "50000" } } filter { } output { stdout { codec => rubydebug } elasticsearch { hosts => "172.16.1.209:9200" index => "mssql-%{+YYYY.MM.dd}" template => "C:/logstash/sql.json" template_overwrite => true } } ``` As seen, I did not make any filtering option. What does it mean by limitation on searches? ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [June 21, 2016, 3:54pm UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/4 "2016-06-21T15:54:33Z")
Sorry, I meant to ask if, inside Kibana, you are using the search bar or filters to limit the results that are shown inside the visualization. For example, the following shows me searching for all records that match "lukas" and where the `metricset.name` is "process": ![](https://us1.discourse-cdn.com/elastic/original/2X/1/1e9e30782b67869a91a2e31f81c24afc123b765e.png) ---
**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\ **Post date:** [June 22, 2016, 2:13am UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/5 "2016-06-22T02:13:14Z")
No, there still aren't any results. Any filters or searches only work on analyzed field but not raw field. Is there any limitation on raw field? ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [June 22, 2016, 10:17pm UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/6 "2016-06-22T22:17:32Z")
If you want to be able to search against your "raw" field, you have to search for the exact text of the raw field, since it isn't analyzed. See this guide for more information: [https://www.elastic.co/guide/en/elasticsearch/guide/current/multi-fields.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/multi-fields.html) ---
**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\ **Post date:** [June 23, 2016, 1:52am UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/7 "2016-06-23T01:52:16Z")
I have already tried to search for the exact text, but it seems still could not give a proper output. How about if there is a way that I can trick Kibana to consider the string as a whole word but not separate the whole string into pieces of words? ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [June 23, 2016, 8:49pm UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/8 "2016-06-23T20:49:52Z")
You would also have to type in the name of the field, like this: hostname.raw: "07llqen2sjb" ---
**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\ **Post date:** [June 24, 2016, 4:28am UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/9 "2016-06-24T04:28:42Z")
Yes, I have tried that also, but still not solved ---
**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:49pm UTC](https://discuss.elastic.co/t/kibana-issues-on-showing-results/53257/10 "2017-07-06T13:49:23Z")
Closed on July 6, 2017, 1:49pm UTC