# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=495 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 496 --- ## [Kibana 7.6.1 How Does Discover's Search Bar Work](https://discuss.elastic.co/t/kibana-7-6-1-how-does-discovers-search-bar-work/231422)
**Author:** [@0josh](https://discuss.elastic.co/u/0josh)\ **Replies:** 2\ **Last updated:** [May 7, 2020, 1:59am UTC](https://discuss.elastic.co/t/kibana-7-6-1-how-does-discovers-search-bar-work/231422 "2020-05-07T01:59:45Z")
Hi, I'm trying to integrate SQL as an alternative option to KQL in the discover search bar. Essentially redirecting inputed queries and POST them to hostname:9200/\_opendistro/\_sql It seems call\_client.ts in the Kibana s… --- ## [Kibana React - error when importing](https://discuss.elastic.co/t/kibana-react-error-when-importing/231431)
**Author:** [@Paul\_Gege](https://discuss.elastic.co/u/Paul_Gege)\ **Replies:** 2\ **Last updated:** [May 7, 2020, 1:40am UTC](https://discuss.elastic.co/t/kibana-react-error-when-importing/231431 "2020-05-07T01:40:06Z")
Hi all, I'm trying to explore what "kibana-react" does. I went through the github code (https://github.com/elastic/kibana/tree/master/src/plugins/kibana\_react) and tried to follow the instructions from the readme and ap… --- ## [Return value True or False based on Kibana Script](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400)
**Author:** [@vdalvi](https://discuss.elastic.co/u/vdalvi)\ **Replies:** 2\ **Last updated:** [May 6, 2020, 11:20pm UTC](https://discuss.elastic.co/t/return-value-true-or-false-based-on-kibana-script/231400 "2020-05-06T23:20:25Z")
Hi, How can I aggregate to return value as True if doc\_count != 0 and False if doc\_count == 0 in Kibana response? Below is my query { "query": { "range": { "timestamp": { "gte": "now-1h/h" } … --- ## [Create new index pattern: Reticulating splines](https://discuss.elastic.co/t/create-new-index-pattern-reticulating-splines/226779)
**Author:** [@yurig](https://discuss.elastic.co/u/yurig)\ **Replies:** 4\ **Last updated:** [May 6, 2020, 8:32pm UTC](https://discuss.elastic.co/t/create-new-index-pattern-reticulating-splines/226779 "2020-05-06T20:32:55Z")
I am running Kibana/Elastic version 6.4.2 on Windows and trying to create a new index pattern by going to Management --\> Index patterns --\> Create index pattern. The window gets stuck on 'Checking for Elasticsearch data… --- ## [Exporting issue](https://discuss.elastic.co/t/exporting-issue/231395)
**Author:** [@jppedals](https://discuss.elastic.co/u/jppedals)\ **Replies:** 1\ **Last updated:** [May 6, 2020, 7:45pm UTC](https://discuss.elastic.co/t/exporting-issue/231395 "2020-05-06T19:45:43Z")
I have issue when i export to CSV. When I pull my queries and export it only allows me to export maybe 5600 of them but I have many more and I am trying to figure out how to increase this on the export but I cant find a… --- ## [Kibana-7.6.1 startup error：“Elastic APM initialization error: ……”](https://discuss.elastic.co/t/kibana-7-6-1-startup-error-elastic-apm-initialization-error/229809)
**Author:** [@LuckyNemo](https://discuss.elastic.co/u/LuckyNemo)\ **Replies:** 4\ **Last updated:** [May 6, 2020, 5:54pm UTC](https://discuss.elastic.co/t/kibana-7-6-1-startup-error-elastic-apm-initialization-error/229809 "2020-05-06T17:54:52Z")
Environment： 3 nodes（all deploy es nodes and kibana nodes） version：elasticsearch7.6.1 and kibana-7.6.1（both r RPM installed） ES nodes worked fine，but when I start kibana nodes,throw exception as follows： Elastic … --- ## [How to convert derivative of doc\_count into percentage change?](https://discuss.elastic.co/t/how-to-convert-derivative-of-doc-count-into-percentage-change/231242)
**Author:** [@vdalvi](https://discuss.elastic.co/u/vdalvi)\ **Replies:** 1\ **Last updated:** [May 6, 2020, 5:47pm UTC](https://discuss.elastic.co/t/how-to-convert-derivative-of-doc-count-into-percentage-change/231242 "2020-05-06T17:47:36Z")
Hi, Below is my query. I have a aggregation "count\_deriv" and want to convert the delta value generated into a percentage value (i.e divide it by the doc\_count from previous interval)? I would like to calculate the perc… --- ## [Single Watcher Alert for multiple hosts](https://discuss.elastic.co/t/single-watcher-alert-for-multiple-hosts/231318)
**Author:** [@spike83](https://discuss.elastic.co/u/spike83)\ **Replies:** 3\ **Last updated:** [May 6, 2020, 4:22pm UTC](https://discuss.elastic.co/t/single-watcher-alert-for-multiple-hosts/231318 "2020-05-06T16:22:52Z")
Hi, Is it possible to setup a single Watcher alert for something such as HDD space and have the action send the hostname of the server reporting the issue in the alert? The only drawback I can see if this is possible i… --- ## [Creating a report Dashboard from Multiple CSV](https://discuss.elastic.co/t/creating-a-report-dashboard-from-multiple-csv/226518)
**Author:** [@NoobieDev](https://discuss.elastic.co/u/NoobieDev)\ **Replies:** 3\ **Last updated:** [May 6, 2020, 3:45pm UTC](https://discuss.elastic.co/t/creating-a-report-dashboard-from-multiple-csv/226518 "2020-05-06T15:45:18Z")
Hi all, I'm discovering ELS I've worked previously with Kibana only using Visualization. Today I'm looking to do something different. I have some CSV from a tool, I have 1 CSV per month to get some data from the previo… --- ## [Maps possible bug: link terminates wrong geo location](https://discuss.elastic.co/t/maps-possible-bug-link-terminates-wrong-geo-location/231212)
**Author:** [@seanziee](https://discuss.elastic.co/u/seanziee)\ **Replies:** 4\ **Last updated:** [May 6, 2020, 3:35pm UTC](https://discuss.elastic.co/t/maps-possible-bug-link-terminates-wrong-geo-location/231212 "2020-05-06T15:35:52Z")
Possibly I'm missing something, but I find that links in the maps app don't always go to the actual destination, but rather a little next to it. When I zoom in more, then it correctly terminates at the correct destinatio… --- ## [Point to Point (Lines) Have to Zoom in to show in Map](https://discuss.elastic.co/t/point-to-point-lines-have-to-zoom-in-to-show-in-map/230730)
**Author:** [@Viola\_Shen](https://discuss.elastic.co/u/Viola_Shen)\ **Replies:** 3\ **Last updated:** [May 6, 2020, 3:35pm UTC](https://discuss.elastic.co/t/point-to-point-lines-have-to-zoom-in-to-show-in-map/230730 "2020-05-06T15:35:39Z")
Have to zoom in to show more lines. Tried to increased the max result and there are more lines showing but still need to zoom in for more lines. Is there anything else we could do to increase the point-to-point lines sh… --- ## [Terms Aggregating over array elements and correlating data from a second array](https://discuss.elastic.co/t/terms-aggregating-over-array-elements-and-correlating-data-from-a-second-array/231156)
**Author:** [@svbernem](https://discuss.elastic.co/u/svbernem)\ **Replies:** 1\ **Last updated:** [May 6, 2020, 3:11pm UTC](https://discuss.elastic.co/t/terms-aggregating-over-array-elements-and-correlating-data-from-a-second-array/231156 "2020-05-06T15:11:19Z")
Hi, I have data in the following form: doc1: {"names": \["n1","n2","n3"\], "data\_points":\[0,1,2\]} doc2: {"names": \["n1","n2","n3"\], "data\_points":\[1,2,3\]} doc3: {"names": \["n1","n2","n3"\], "data\_points":\[2,3,4\]} Which c… --- ## [Coordinate maps/elastic maps](https://discuss.elastic.co/t/coordinate-maps-elastic-maps/231246)
**Author:** [@Ananya\_Mohiley](https://discuss.elastic.co/u/Ananya_Mohiley)\ **Replies:** 1\ **Last updated:** [May 6, 2020, 2:42pm UTC](https://discuss.elastic.co/t/coordinate-maps-elastic-maps/231246 "2020-05-06T14:42:13Z")
hi iam currently using ELK for doing vis for my project however i have got a requirement of using my own customised markings on maps visualisation in place of the dots as they are presently. these distinct markings are … --- ## [No data in simple vega lite visualization](https://discuss.elastic.co/t/no-data-in-simple-vega-lite-visualization/231273)
**Author:** [@zonas27](https://discuss.elastic.co/u/zonas27)\ **Replies:** 4\ **Last updated:** [May 6, 2020, 2:01pm UTC](https://discuss.elastic.co/t/no-data-in-simple-vega-lite-visualization/231273 "2020-05-06T14:01:05Z")
Hello, I've been using elastic search/kibana for a couple of months, but I'm very new to vega visualization. I have a simple script like this : { $schema: https://vega.github.io/schema/vega-lite/v2.json t… --- ## [Use Json input convert bytes to GB](https://discuss.elastic.co/t/use-json-input-convert-bytes-to-gb/231330)
**Author:** [@Jan\_Svajcik](https://discuss.elastic.co/u/Jan_Svajcik)\ **Replies:** 3\ **Last updated:** [May 6, 2020, 1:34pm UTC](https://discuss.elastic.co/t/use-json-input-convert-bytes-to-gb/231330 "2020-05-06T13:34:32Z")
Hello please i am beginner for elastics I created metric for sum filesize , but I have count in bytes I need in GB how should i write json input ? Soory for my Englisch , thank you --- ## [Date labels on histograms with monthly interval](https://discuss.elastic.co/t/date-labels-on-histograms-with-monthly-interval/231312)
**Author:** [@spaolik](https://discuss.elastic.co/u/spaolik)\ **Replies:** 1\ **Last updated:** [May 6, 2020, 1:31pm UTC](https://discuss.elastic.co/t/date-labels-on-histograms-with-monthly-interval/231312 "2020-05-06T13:31:37Z")
Hi there, I'm using a TSVB visualization to create a graph that displays monthly sum of values. I have used the "M" interval in the options, and am trying to understand what goes wrong as the result is not OK: Could… --- ## [Set Home Page as Dashboard](https://discuss.elastic.co/t/set-home-page-as-dashboard/231244)
**Author:** [@bmbrit](https://discuss.elastic.co/u/bmbrit)\ **Replies:** 6\ **Last updated:** [May 6, 2020, 12:07pm UTC](https://discuss.elastic.co/t/set-home-page-as-dashboard/231244 "2020-05-06T12:07:58Z")
Hi, I know earlier (in 4.4 version), we didn't have the option to set a dashboard as a home page in Kibana. Is it still unavailable? Thanks in advance. Thanks, Brit --- ## [Kibana 7.5 Heat map dashboard bug](https://discuss.elastic.co/t/kibana-7-5-heat-map-dashboard-bug/230173)
**Author:** [@Keshaw\_Pathak](https://discuss.elastic.co/u/Keshaw_Pathak)\ **Replies:** 2\ **Last updated:** [May 6, 2020, 11:11am UTC](https://discuss.elastic.co/t/kibana-7-5-heat-map-dashboard-bug/230173 "2020-05-06T11:11:53Z")
Heat map in kibana 7.5 has issues with filtering. Filters are working in visualization but not working when adding to the dashboard. --- ## [SLI / SLO dashboard](https://discuss.elastic.co/t/sli-slo-dashboard/230116)
**Author:** [@Vincent\_Vallet](https://discuss.elastic.co/u/Vincent_Vallet)\ **Replies:** 2\ **Last updated:** [May 6, 2020, 9:27am UTC](https://discuss.elastic.co/t/sli-slo-dashboard/230116 "2020-05-06T09:27:34Z")
Hi there, I'm a new user of Kibana and I want to create a custom dashboard. More precisely an SLO/SLI dashboard. I want to begin with simple formulas such as: 99,9 % of successful requests on service A (EB: 1% of tot… --- ## [Kibana JavaScript heap out of memory](https://discuss.elastic.co/t/kibana-javascript-heap-out-of-memory/228365)
**Author:** [@chandu5565](https://discuss.elastic.co/u/chandu5565)\ **Replies:** 6\ **Last updated:** [May 6, 2020, 6:48am UTC](https://discuss.elastic.co/t/kibana-javascript-heap-out-of-memory/228365 "2020-05-06T06:48:47Z")
Hi, While generating report in kibana am getting below error. How can i increase the heap memory for kibana. log \[13:01:39.659\] \[info\]\[queue-job\]\[reporting\] Successfully queued job: k92rw1ad0xuh4e318d6raay8 log \[1… --- ## [Converting Search Query To Filter](https://discuss.elastic.co/t/converting-search-query-to-filter/230595)
**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\ **Replies:** 3\ **Last updated:** [May 6, 2020, 6:27am UTC](https://discuss.elastic.co/t/converting-search-query-to-filter/230595 "2020-05-06T06:27:12Z")
I have a query I've built in the search menu I'd like to convert into a filter, if it's possible. I've tried it but I end up getting an error where it expects the end of the query but gets more. Below is my current que… --- ## [Watcher condition with aggregation](https://discuss.elastic.co/t/watcher-condition-with-aggregation/225758)
**Author:** [@18visions](https://discuss.elastic.co/u/18visions)\ **Replies:** 6\ **Last updated:** [May 6, 2020, 1:14am UTC](https://discuss.elastic.co/t/watcher-condition-with-aggregation/225758 "2020-05-06T01:14:03Z")
Hello, I'm trying to create a watcher alert when any rabbitmq queue exceeds X amount. My query returns the results I'm looking for, but the conditional usually throws a null pointer exception. Any help is appreciated! … --- ## [Kibana 4.1 metric visualization round decimal value](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098)
**Author:** [@rajeshchinnam1985](https://discuss.elastic.co/u/rajeshchinnam1985)\ **Replies:** 22\ **Last updated:** [May 5, 2020, 10:23pm UTC](https://discuss.elastic.co/t/kibana-4-1-metric-visualization-round-decimal-value/24098 "2020-05-05T22:23:19Z")
Thanks in advance.. I am using kibana 4.1 and trying to create a metric visualization which returning me a value of 135.649 how can I round off this value 135.65 How can I do this --- ## [Tips to create a Machine Larning job](https://discuss.elastic.co/t/tips-to-create-a-machine-larning-job/230244)
**Author:** [@david-vazquez](https://discuss.elastic.co/u/david-vazquez)\ **Replies:** 7\ **Last updated:** [May 5, 2020, 8:59pm UTC](https://discuss.elastic.co/t/tips-to-create-a-machine-larning-job/230244 "2020-05-05T20:59:22Z")
Hello guys, I´m trying to create a ML job which detect anomalies using an index pattern which contains information about traffic DNS (Cisco Umbrella). With this log, I can get categories about the DNS resolutions, knowi… --- ## [Unable to enable security on elk instance using puppet](https://discuss.elastic.co/t/unable-to-enable-security-on-elk-instance-using-puppet/231179)
**Author:** [@Thaylin](https://discuss.elastic.co/u/Thaylin)\ **Replies:** 4\ **Last updated:** [May 5, 2020, 6:05pm UTC](https://discuss.elastic.co/t/unable-to-enable-security-on-elk-instance-using-puppet/231179 "2020-05-05T18:05:36Z")
I currently have a puppet configuration of the elasticsearch and kibana, however I cannot get security to enable so I can setup users and then enable the logstash. When I enable the securty it still allows me into the UI… --- ## [Nested Date fields not showing up in date histogram/date range](https://discuss.elastic.co/t/nested-date-fields-not-showing-up-in-date-histogram-date-range/231202)
**Author:** [@sana\_es](https://discuss.elastic.co/u/sana_es)\ **Replies:** 1\ **Last updated:** [May 5, 2020, 6:04pm UTC](https://discuss.elastic.co/t/nested-date-fields-not-showing-up-in-date-histogram-date-range/231202 "2020-05-05T18:04:45Z")
I am working with a Nested field with date data type for as starting and ending duration. I would like to use use those fields for date histograms in data table and also to create drop down with control. I am not able t… --- ## [Kibana SSL "Unable to revive connection: https://localhost:9200/"](https://discuss.elastic.co/t/kibana-ssl-unable-to-revive-connection-https-localhost-9200/231037)
**Author:** [@derekmizak](https://discuss.elastic.co/u/derekmizak)\ **Replies:** 5\ **Last updated:** [May 5, 2020, 4:36pm UTC](https://discuss.elastic.co/t/kibana-ssl-unable-to-revive-connection-https-localhost-9200/231037 "2020-05-05T16:36:23Z")
I have elasticsearch and kibana working on the same node in the dev environment. I have configured TLS in elasticsearch and I can connect to it: root@host1:/home/admin# curl -k -0 https://localhost:9200 -u user:pas… --- ## ["fields" key show date-type fields in JSON view](https://discuss.elastic.co/t/fields-key-show-date-type-fields-in-json-view/230744)
**Author:** [@talalatpixlee](https://discuss.elastic.co/u/talalatpixlee)\ **Replies:** 2\ **Last updated:** [May 5, 2020, 3:26pm UTC](https://discuss.elastic.co/t/fields-key-show-date-type-fields-in-json-view/230744 "2020-05-05T15:26:33Z")
This is just an inquiry. In the discover view when i try and look at the raw json for a document, I see the keys \_id, \_type, \_index, \_version, \_score and \_source which are all expected. I see an additional field called "… --- ## [Kibana load time](https://discuss.elastic.co/t/kibana-load-time/231098)
**Author:** [@nityaraj06](https://discuss.elastic.co/u/nityaraj06)\ **Replies:** 4\ **Last updated:** [May 5, 2020, 2:49pm UTC](https://discuss.elastic.co/t/kibana-load-time/231098 "2020-05-05T14:49:09Z")
Hi, When the end user accesses Kibana 7.6 for the first time, it takes 15-20s to load, the search queries and other tabs within Kibana don’t take much time. Is there any particular reason for this? I checked through bro… --- ## [Unable to connect to Elasticsearch. Error: Request Timeout after 30000ms](https://discuss.elastic.co/t/unable-to-connect-to-elasticsearch-error-request-timeout-after-30000ms/230858)
**Author:** [@kelk](https://discuss.elastic.co/u/kelk)\ **Replies:** 8\ **Last updated:** [May 5, 2020, 2:43pm UTC](https://discuss.elastic.co/t/unable-to-connect-to-elasticsearch-error-request-timeout-after-30000ms/230858 "2020-05-05T14:43:51Z")
hi, I've been trying to simulate a Kibana to Elastic Connection. (As per the Link it was related to Kibana OSS, but I tried both Kibana and Kibana-oss, but still no luck.) ./bin/kibana --version 7.6.2 cat custom/co… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=494) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=496)