# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=908 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 909 --- ## [How to aggregate on a text field?](https://discuss.elastic.co/t/how-to-aggregate-on-a-text-field/105566)
**Author:** [@charles221](https://discuss.elastic.co/u/charles221)\ **Replies:** 1\ **Last updated:** [October 27, 2017, 8:42pm UTC](https://discuss.elastic.co/t/how-to-aggregate-on-a-text-field/105566 "2017-10-27T20:42:44Z")
Have spent quite a long time with this problem and would like to replicate the functionality removed (I think?) when the string type was deprecated and replaced by the text and keyword types. Mentioned in this StackOverf… --- ## [Cumulative sum till date](https://discuss.elastic.co/t/cumulative-sum-till-date/105518)
**Author:** [@SHUBHAM\_GUPTA](https://discuss.elastic.co/u/SHUBHAM_GUPTA)\ **Replies:** 1\ **Last updated:** [October 27, 2017, 8:21pm UTC](https://discuss.elastic.co/t/cumulative-sum-till-date/105518 "2017-10-27T20:21:17Z")
Hey , I have data in elasticsearch with indexing at date. For example - I have data like this -\> 12 oct 2017 -\> value =30 13 oct 2017-\> value =20 14 oct 2017 -\> value =60 I can create dashboard with date as x-axis … --- ## [Multi field aggregation with Elasticsearch-kibana](https://discuss.elastic.co/t/multi-field-aggregation-with-elasticsearch-kibana/105301)
**Author:** [@shethsaam](https://discuss.elastic.co/u/shethsaam)\ **Replies:** 5\ **Last updated:** [October 27, 2017, 6:33pm UTC](https://discuss.elastic.co/t/multi-field-aggregation-with-elasticsearch-kibana/105301 "2017-10-27T18:33:23Z")
With kibana devtools, I am trying to create a query to get unique values from multiple fields into a single bucket. I am using cppy\_to to create a new field and plan to find the unique values with aggregation. I need to … --- ## [Kibana stuck with "Elasticsearch is still initializing the Monitoring indices" error](https://discuss.elastic.co/t/kibana-stuck-with-elasticsearch-is-still-initializing-the-monitoring-indices-error/105480)
**Author:** [@Jeff\_I](https://discuss.elastic.co/u/Jeff_I)\ **Replies:** 4\ **Last updated:** [October 27, 2017, 6:08pm UTC](https://discuss.elastic.co/t/kibana-stuck-with-elasticsearch-is-still-initializing-the-monitoring-indices-error/105480 "2017-10-27T18:08:28Z")
I have booted the es servers and restarted kibana, but in the status break down in kibana has one error: plugin:monitoring@5.6.3 Elasticsearch is still initializing the Monitoring indices Details: Nodes es version 5.… --- ## [How to create aggregations in Y axis](https://discuss.elastic.co/t/how-to-create-aggregations-in-y-axis/105454)
**Author:** [@arun\_s](https://discuss.elastic.co/u/arun_s)\ **Replies:** 2\ **Last updated:** [October 27, 2017, 6:01pm UTC](https://discuss.elastic.co/t/how-to-create-aggregations-in-y-axis/105454 "2017-10-27T18:01:09Z")
Hi I am new to kibana, can anyone help me to create custom based filed in y axis. I am having csv file response time against ips , i want to have response time in y axis and ips in x axis --- ## [How to use timelion to get a ratio](https://discuss.elastic.co/t/how-to-use-timelion-to-get-a-ratio/105457)
**Author:** [@Ximeng\_Zhao](https://discuss.elastic.co/u/Ximeng_Zhao)\ **Replies:** 3\ **Last updated:** [October 27, 2017, 3:10pm UTC](https://discuss.elastic.co/t/how-to-use-timelion-to-get-a-ratio/105457 "2017-10-27T15:10:52Z")
Hello, I want to write a script in Timelion to get a ratio. The idea is : count(field\_name) is not null divided by count(field\_name) The index name: call The field name I want to count : drop\_rate The value of drop\_… --- ## [Kibana not displaying data of more than one type in a particular index](https://discuss.elastic.co/t/kibana-not-displaying-data-of-more-than-one-type-in-a-particular-index/105233)
**Author:** [@raja\_gopal](https://discuss.elastic.co/u/raja_gopal)\ **Replies:** 3\ **Last updated:** [October 27, 2017, 10:13am UTC](https://discuss.elastic.co/t/kibana-not-displaying-data-of-more-than-one-type-in-a-particular-index/105233 "2017-10-27T10:13:26Z")
Hi, I have an index called history. I get data into this index through logstash and the data comes under the type clear. Now i am sending few data through perl which collects data from elasticsearch do some processing a… --- ## [Create custom metric for Y-axis, dealing with no existed values](https://discuss.elastic.co/t/create-custom-metric-for-y-axis-dealing-with-no-existed-values/105222)
**Author:** [@lsouvleros](https://discuss.elastic.co/u/lsouvleros)\ **Replies:** 12\ **Last updated:** [October 27, 2017, 9:47am UTC](https://discuss.elastic.co/t/create-custom-metric-for-y-axis-dealing-with-no-existed-values/105222 "2017-10-27T09:47:39Z")
Hello, I just started to use ELK and I want your help with issues. I have a dataset with the following fields Username,Name,Recruitment\_date,Recruitment\_year,duration\_at\_company,leave\_date, leave\_year and I want to f… --- ## [Kibana stops fetching the data from indices](https://discuss.elastic.co/t/kibana-stops-fetching-the-data-from-indices/105109)
**Author:** [@tomindo](https://discuss.elastic.co/u/tomindo)\ **Replies:** 11\ **Last updated:** [October 27, 2017, 8:27am UTC](https://discuss.elastic.co/t/kibana-stops-fetching-the-data-from-indices/105109 "2017-10-27T08:27:38Z")
Hi guys, I have strange issue that the kibana stops fetching the data from elastic search cluster. Logstash and elastic cluster works fine I can see new indices created and the new data comes in every second. please he… --- ## [Possible bug in Kibana 6 - data table not showing all partial rows](https://discuss.elastic.co/t/possible-bug-in-kibana-6-data-table-not-showing-all-partial-rows/105387)
**Author:** [@Conall\_Prendergast](https://discuss.elastic.co/u/Conall_Prendergast)\ **Replies:** 4\ **Last updated:** [October 27, 2017, 8:26am UTC](https://discuss.elastic.co/t/possible-bug-in-kibana-6-data-table-not-showing-all-partial-rows/105387 "2017-10-27T08:26:54Z")
I am making a Data table in Kibana 6, and I think I might have spotted something that is a bug. It appears that there is a bug with the "show partial rows" feature in the "Data Table" visualisation. I have attached thre… --- ## [Datepicker import](https://discuss.elastic.co/t/datepicker-import/105340)
**Author:** [@nugusbayevkk](https://discuss.elastic.co/u/nugusbayevkk)\ **Replies:** 3\ **Last updated:** [October 27, 2017, 7:53am UTC](https://discuss.elastic.co/t/datepicker-import/105340 "2017-10-27T07:53:26Z")
Hello everybody, i try to add to my plugin datepicker functionality kibana version: 5.5.2 node version 8.6.0 npm version 5.3.0 i try to use "jquery-datetimepicker": "^2.5.11": first i install it, then i install jqu… --- ## [Visualization Data table not displaying complete log message](https://discuss.elastic.co/t/visualization-data-table-not-displaying-complete-log-message/105444)
**Author:** [@nani9](https://discuss.elastic.co/u/nani9)\ **Replies:** 1\ **Last updated:** [October 27, 2017, 2:52am UTC](https://discuss.elastic.co/t/visualization-data-table-not-displaying-complete-log-message/105444 "2017-10-27T02:52:45Z")
I am creating a data table to show log messages. But i can only see single line errors in data table, For example javaexception errors are not displayed. Looks like it is not displaying multiline log message in data tab… --- ## [BAD request after deleting an index pattern and recreating it](https://discuss.elastic.co/t/bad-request-after-deleting-an-index-pattern-and-recreating-it/105333)
**Author:** [@abdalians](https://discuss.elastic.co/u/abdalians)\ **Replies:** 2\ **Last updated:** [October 27, 2017, 12:14am UTC](https://discuss.elastic.co/t/bad-request-after-deleting-an-index-pattern-and-recreating-it/105333 "2017-10-27T00:14:02Z")
Hi all, Continuing the discussion from Kibana shows blank sites in Discover, Management, ... after deleting/creation of default index pattern: I had an index-pattern logstash-2017\* which I deleted, then I recreated it … --- ## [How to visualize simple data points](https://discuss.elastic.co/t/how-to-visualize-simple-data-points/105326)
**Author:** [@Navinder](https://discuss.elastic.co/u/Navinder)\ **Replies:** 1\ **Last updated:** [October 27, 2017, 12:10am UTC](https://discuss.elastic.co/t/how-to-visualize-simple-data-points/105326 "2017-10-27T00:10:08Z")
Hi, How can I view simple data point on a line or bar graph in Kibana. For E.g. I have below data in csv Date, Count 2017-10-20, 45000 2017-10-21, 50000 2017-10-22, 55000 2017-10-23, 51000 2017-10-24, 52000 I wan… --- ## [visState Kibana](https://discuss.elastic.co/t/visstate-kibana/105311)
**Author:** [@sonic](https://discuss.elastic.co/u/sonic)\ **Replies:** 1\ **Last updated:** [October 27, 2017, 12:01am UTC](https://discuss.elastic.co/t/visstate-kibana/105311 "2017-10-27T00:01:58Z")
Hello everyone! I have datatable visualization and need multiply sort (two fields), also I need to get 15% of sorted results. Can I do this in visState, using elasticsearch sort, and how? I tried to sort by the end of … --- ## [Kibana rounds my values](https://discuss.elastic.co/t/kibana-rounds-my-values/105293)
**Author:** [@sonic](https://discuss.elastic.co/u/sonic)\ **Replies:** 1\ **Last updated:** [October 26, 2017, 10:48pm UTC](https://discuss.elastic.co/t/kibana-rounds-my-values/105293 "2017-10-26T22:48:00Z")
I got csv file, where I have Column with float values. When I export this data into kibana, kibana rounds it to something like int. For example, I have 1.5 in csv, and I have 1 in kibana, 2.05 in csv and 2 in kibana. Doe… --- ## ["Operation timed out" while accessing Kibana](https://discuss.elastic.co/t/operation-timed-out-while-accessing-kibana/104917)
**Author:** [@sanju1323](https://discuss.elastic.co/u/sanju1323)\ **Replies:** 22\ **Last updated:** [October 26, 2017, 1:46pm UTC](https://discuss.elastic.co/t/operation-timed-out-while-accessing-kibana/104917 "2017-10-26T13:46:24Z")
Hi, I have installed X-pack on Elasticsearch and Kibana on the server. I'm able to access Elasticsearch from my machine (which is on the same network) but not able to access Kibana. From the terminal, I'm getting the f… --- ## [Kibana logout on view report](https://discuss.elastic.co/t/kibana-logout-on-view-report/105413)
**Author:** [@pjanzen](https://discuss.elastic.co/u/pjanzen)\ **Replies:** 2\ **Last updated:** [October 26, 2017, 12:49pm UTC](https://discuss.elastic.co/t/kibana-logout-on-view-report/105413 "2017-10-26T12:49:05Z")
Hi All, I am using the report functionality and I like it very much. I noticed that when I generate a report - search, visualization, dashboard - and I go to managment -\> reports -\> (my report) I can look at my report b… --- ## [How to disable timezone conversion](https://discuss.elastic.co/t/how-to-disable-timezone-conversion/104525)
**Author:** [@zneh](https://discuss.elastic.co/u/zneh)\ **Replies:** 2\ **Last updated:** [October 26, 2017, 10:05am UTC](https://discuss.elastic.co/t/how-to-disable-timezone-conversion/104525 "2017-10-26T10:05:22Z")
Hi, I am using kibana 5.5.0 and have issue with timezones. Currently data I receive comes from different timezones and sometimes without timezone specified at all. For example: date1: 2016-06-13T08:30:00Z date2: 2016-… --- ## [Average calculation problem (round-off 0) on CPULoad via JMX](https://discuss.elastic.co/t/average-calculation-problem-round-off-0-on-cpuload-via-jmx/104689)
**Author:** [@ChuckNoxis](https://discuss.elastic.co/u/ChuckNoxis)\ **Replies:** 13\ **Last updated:** [October 26, 2017, 9:31am UTC](https://discuss.elastic.co/t/average-calculation-problem-round-off-0-on-cpuload-via-jmx/104689 "2017-10-26T09:31:32Z")
Hi, I've installed an ELK on Ubuntu, i'm trying to monitor some data from a Java app with JMX (I followed this tutorial). When I want to create a visualization for my CPU Load, the result of the average equals 0. \[Sé… --- ## [Filter out String that are ""](https://discuss.elastic.co/t/filter-out-string-that-are/105352)
**Author:** [@tomer](https://discuss.elastic.co/u/tomer)\ **Replies:** 3\ **Last updated:** [October 26, 2017, 7:53am UTC](https://discuss.elastic.co/t/filter-out-string-that-are/105352 "2017-10-26T07:53:30Z")
Hi, I want to make a filter that filters out logs if field "a" is "". How can I do so? I am using Kibana 5.6. \[image\] --- ## [Kibana Filter for a specific time range](https://discuss.elastic.co/t/kibana-filter-for-a-specific-time-range/105169)
**Author:** [@kavierkoo](https://discuss.elastic.co/u/kavierkoo)\ **Replies:** 2\ **Last updated:** [October 26, 2017, 2:13am UTC](https://discuss.elastic.co/t/kibana-filter-for-a-specific-time-range/105169 "2017-10-26T02:13:34Z")
Hi, I am new to Elastic that are trying it out, i am looking forward to generate report to display windows users logon after office hour via elastic cloud with only 1 winlogbeat in VM. However i am currently stuck with… --- ## [Querying for inner json parameters](https://discuss.elastic.co/t/querying-for-inner-json-parameters/105083)
**Author:** [@shaked571](https://discuss.elastic.co/u/shaked571)\ **Replies:** 3\ **Last updated:** [October 25, 2017, 5:00pm UTC](https://discuss.elastic.co/t/querying-for-inner-json-parameters/105083 "2017-10-25T17:00:34Z")
HI everyone, I am new in Kibana and i have some difficulties in my queries while using the Dev Tools. I try to find a log according to his nested json and getting an Error back and i wish to know what I'm doing wrong … --- ## [Is that possible import the visualize (editor included) in discover page?](https://discuss.elastic.co/t/is-that-possible-import-the-visualize-editor-included-in-discover-page/105065)
**Author:** [@whoami](https://discuss.elastic.co/u/whoami)\ **Replies:** 3\ **Last updated:** [October 25, 2017, 4:49pm UTC](https://discuss.elastic.co/t/is-that-possible-import-the-visualize-editor-included-in-discover-page/105065 "2017-10-25T16:49:05Z")
kibana version: 5.4.3 question: is that possible import the visualize (editor included) in discover page, i mean from code level? --- ## [The way to visualize data traffic from filebeat](https://discuss.elastic.co/t/the-way-to-visualize-data-traffic-from-filebeat/104379)
**Author:** [@hsafe](https://discuss.elastic.co/u/hsafe)\ **Replies:** 5\ **Last updated:** [October 25, 2017, 4:33pm UTC](https://discuss.elastic.co/t/the-way-to-visualize-data-traffic-from-filebeat/104379 "2017-10-25T16:33:28Z")
Hi, I have been using ELK for some time and all sort of shipment solution, however due to the storage issue and simplicity of the env , and as my LB(being HAproxy) and already configured with the filebeat shipping the e… --- ## [Passing Dynamic data to other Visualizations](https://discuss.elastic.co/t/passing-dynamic-data-to-other-visualizations/105226)
**Author:** [@paul1243](https://discuss.elastic.co/u/paul1243)\ **Replies:** 1\ **Last updated:** [October 25, 2017, 2:46pm UTC](https://discuss.elastic.co/t/passing-dynamic-data-to-other-visualizations/105226 "2017-10-25T14:46:06Z")
Hi - I have a requirement, to show the data as per the request coming in from the other visualization. Lets say I've a mark down visualization which shows build numbers (1....10) which will be as a hyperlink and when u… --- ## [Kibana hits are different](https://discuss.elastic.co/t/kibana-hits-are-different/103033)
**Author:** [@sudi\_2611](https://discuss.elastic.co/u/sudi_2611)\ **Replies:** 18\ **Last updated:** [October 25, 2017, 2:22pm UTC](https://discuss.elastic.co/t/kibana-hits-are-different/103033 "2017-10-25T14:22:20Z")
Hi Team, Thanks a lot for all the advice and help its been a wonderful forum to ask and learn stuffs. The issue is that the hit counts in discovery tab are varying when compared to the actual data because of which i a… --- ## [Timelion series matching specific field](https://discuss.elastic.co/t/timelion-series-matching-specific-field/105240)
**Author:** [@sanek640](https://discuss.elastic.co/u/sanek640)\ **Replies:** 8\ **Last updated:** [October 25, 2017, 2:11pm UTC](https://discuss.elastic.co/t/timelion-series-matching-specific-field/105240 "2017-10-25T14:11:56Z")
Hi, i have a problem with my time series data in Timelion. For example, I have a set of cars, that have index 'car' and every document besides different metadata has the most important for me fields: price (i may collec… --- ## [Deleting a field from the index pattern page](https://discuss.elastic.co/t/deleting-a-field-from-the-index-pattern-page/105204)
**Author:** [@mruthyu](https://discuss.elastic.co/u/mruthyu)\ **Replies:** 1\ **Last updated:** [October 25, 2017, 1:35pm UTC](https://discuss.elastic.co/t/deleting-a-field-from-the-index-pattern-page/105204 "2017-10-25T13:35:56Z")
How to delete a field from Kibana--\>Management--\> Index Patterns page? I see that a field is not indexed and is present in the Fields listing. Also is not part of the index mapping template. --- ## [Groovy scripting to Add custom values to an aggregate result, Eg - Unique count of "field1" + 1](https://discuss.elastic.co/t/groovy-scripting-to-add-custom-values-to-an-aggregate-result-eg-unique-count-of-field1-1/105195)
**Author:** [@viswadeep](https://discuss.elastic.co/u/viswadeep)\ **Replies:** 1\ **Last updated:** [October 25, 2017, 1:32pm UTC](https://discuss.elastic.co/t/groovy-scripting-to-add-custom-values-to-an-aggregate-result-eg-unique-count-of-field1-1/105195 "2017-10-25T13:32:34Z")
How to add custom values to an aggregated result. Eg - Unique count of "field1" + 1 Is this possible in Kibana? [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=907) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=909)