# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=306 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 307 --- ## [Kibana - intersection of two data sets on map](https://discuss.elastic.co/t/kibana-intersection-of-two-data-sets-on-map/277911)
**Author:** [@leonidbionic](https://discuss.elastic.co/u/leonidbionic)\ **Replies:** 4\ **Last updated:** [July 11, 2021, 9:34am UTC](https://discuss.elastic.co/t/kibana-intersection-of-two-data-sets-on-map/277911 "2021-07-11T09:34:38Z")
I have a index named 'request' with the below schema - \`\`\` "id": "160c6273-8462-4830-9a51-dabf2e292ebb", "username": "bob\_dylan", "date": "Jul 6, 2021 @ 12:00:00.000", "location": { "lat": 48.8, "lon": 2.35 }\`\`\`… --- ## [Elasticsearch访问权限xpack](https://discuss.elastic.co/t/elasticsearch-xpack/276736)
**Author:** [@peng-elasticsearch](https://discuss.elastic.co/u/peng-elasticsearch)\ **Replies:** 5\ **Last updated:** [July 9, 2021, 5:30pm UTC](https://discuss.elastic.co/t/elasticsearch-xpack/276736 "2021-07-09T17:30:25Z")
elasticsearch6.3.1版本申请免费基础版license证书，上传导入证书报错问题； 上传导入命令： curl -XPOST -u elastic:123456 http://127.0.0.1:9200/\_xpack/license/start\_basic?acknowledge=true -H "Content-Type: application/json" -d @license.json 执行结果返回：{"ac… --- ## [Convert string to integer](https://discuss.elastic.co/t/convert-string-to-integer/277915)
**Author:** [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)\ **Replies:** 3\ **Last updated:** [July 9, 2021, 4:31pm UTC](https://discuss.elastic.co/t/convert-string-to-integer/277915 "2021-07-09T16:31:07Z")
Hello everyone! I need help for converting a string data to integer value. I have an 'Hours' column which consist of numeric data but kibana is reading as string as a result when i try to sort the axis it does not sort… --- ## [Scripted field calculation with division](https://discuss.elastic.co/t/scripted-field-calculation-with-division/278284)
**Author:** [@jogabonito](https://discuss.elastic.co/u/jogabonito)\ **Replies:** 1\ **Last updated:** [July 9, 2021, 2:34pm UTC](https://discuss.elastic.co/t/scripted-field-calculation-with-division/278284 "2021-07-09T14:34:38Z")
Hi I want to make a scripted field using a simple calculation by using summation and dividing, but I just keep getting 0 and the error-message: "Unable to write index pattern! Refresh the page to get the most up to dat… --- ## [Misleading Sum Date Histogram chart with Split Series](https://discuss.elastic.co/t/misleading-sum-date-histogram-chart-with-split-series/278264)
**Author:** [@Quim\_Fornaguera](https://discuss.elastic.co/u/Quim_Fornaguera)\ **Replies:** 6\ **Last updated:** [July 9, 2021, 1:40pm UTC](https://discuss.elastic.co/t/misleading-sum-date-histogram-chart-with-split-series/278264 "2021-07-09T13:40:55Z")
Hello y'all! When I Create a Sum chart with date histogram and Split Series by Significant Terms (where should be no specific order), I get the series sorted anyway independently of the value of the SUM calculation. … --- ## [Illegal\_argument\_exception error](https://discuss.elastic.co/t/illegal-argument-exception-error/277816)
**Author:** [@keyofstarrysky973](https://discuss.elastic.co/u/keyofstarrysky973)\ **Replies:** 2\ **Last updated:** [July 9, 2021, 1:15pm UTC](https://discuss.elastic.co/t/illegal-argument-exception-error/277816 "2021-07-09T13:15:40Z")
Hello Team. I'm trying to implement a basic lifecycle policy, in order to delete an index after X hours (this lifecycle policy is just for testing). In my setup, I'm using to beats agents (Winlogbeat and Metricbeat). I … --- ## [Automate export of Kibana dashboard CSV](https://discuss.elastic.co/t/automate-export-of-kibana-dashboard-csv/278260)
**Author:** [@Core\_Sec](https://discuss.elastic.co/u/Core_Sec)\ **Replies:** 3\ **Last updated:** [July 9, 2021, 12:21pm UTC](https://discuss.elastic.co/t/automate-export-of-kibana-dashboard-csv/278260 "2021-07-09T12:21:05Z")
Hi All, I need to download the CSV data that generated by Kibana dashboard. I'm struggling with selenium to automate the manual download without much luck But it seems like very not generic and robust way to do that… --- ## [Getting Error in kibana while using xpach](https://discuss.elastic.co/t/getting-error-in-kibana-while-using-xpach/278245)
**Author:** [@SRIGURU\_VEL](https://discuss.elastic.co/u/SRIGURU_VEL)\ **Replies:** 4\ **Last updated:** [July 9, 2021, 12:14pm UTC](https://discuss.elastic.co/t/getting-error-in-kibana-while-using-xpach/278245 "2021-07-09T12:14:57Z")
Hi experts, I am using ELK version 7.12.0. I have secure my Elasticsearch With Xpack. so that i created http.p12 and elasticsearch-ca.pem certificates . And I configured it. In that Elasticsearch is working fine. But … --- ## [Install pulgin in kibana](https://discuss.elastic.co/t/install-pulgin-in-kibana/278165)
**Author:** [@vikramdayma](https://discuss.elastic.co/u/vikramdayma)\ **Replies:** 3\ **Last updated:** [July 9, 2021, 11:47am UTC](https://discuss.elastic.co/t/install-pulgin-in-kibana/278165 "2021-07-09T11:47:42Z")
Hi, I am trying to install plugin on centos 7.x in kibana 7.12.0 by command sudo bin/kibana-plugin install file:///home/mykibanaplugin/ai\_analyst-7.12.0.zip It is giving error Plugin installation was unsuccessful du… --- ## [Kibana launch failed](https://discuss.elastic.co/t/kibana-launch-failed/277629)
**Author:** [@EpLiar](https://discuss.elastic.co/u/EpLiar)\ **Replies:** 18\ **Last updated:** [July 9, 2021, 9:34am UTC](https://discuss.elastic.co/t/kibana-launch-failed/277629 "2021-07-09T09:34:44Z")
I deploy elasticsearch on 192.168.50.216 and 192.168.50.69. Both are working. \[epi@localhost ~\]$ curl 192.168.50.69:9200 { "name" : "EpCent-1", "cluster\_name" : "EpCluster", "cluster\_uuid" : "XuZIcIMhR46iStO7LJIdN… --- ## [How to find relations between independent documents within an index](https://discuss.elastic.co/t/how-to-find-relations-between-independent-documents-within-an-index/278107)
**Author:** [@InesCM](https://discuss.elastic.co/u/InesCM)\ **Replies:** 6\ **Last updated:** [July 9, 2021, 8:30am UTC](https://discuss.elastic.co/t/how-to-find-relations-between-independent-documents-within-an-index/278107 "2021-07-09T08:30:41Z")
So, I've been struggling for a while with a problem that looked simple but for which I just cannot find a solution. At this point I'm not sure if it's not possible to do this, or if I'm just unable to see it. Let's see i… --- ## [Heatmap hide specific column](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170)
**Author:** [@Celiken](https://discuss.elastic.co/u/Celiken)\ **Replies:** 2\ **Last updated:** [July 9, 2021, 7:50am UTC](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170 "2021-07-09T07:50:45Z")
Hi, I'm trying to create a heatmap but I encounter some issues. This is how it looked at first: Here, the X axis is not sorted and miss values (going from 1 to 15). I found I can fix it by adding {"min\_doc\_count":… --- ## [Can't create new Kibana visualizations after upgrade to 7.13](https://discuss.elastic.co/t/cant-create-new-kibana-visualizations-after-upgrade-to-7-13/278202)
**Author:** [@Toumal](https://discuss.elastic.co/u/Toumal)\ **Replies:** 4\ **Last updated:** [July 8, 2021, 10:00pm UTC](https://discuss.elastic.co/t/cant-create-new-kibana-visualizations-after-upgrade-to-7-13/278202 "2021-07-08T22:00:11Z")
Unfortunately I still run into issues after this upgrade: creating any kind of new visualization fails with an "Application not found" error. This is the basic license and I was trying to create a basic bar chart. It see… --- ## [Space/permission controls for "Add data" button](https://discuss.elastic.co/t/space-permission-controls-for-add-data-button/278187)
**Author:** [@GavinBeattie](https://discuss.elastic.co/u/GavinBeattie)\ **Replies:** 1\ **Last updated:** [July 8, 2021, 8:11pm UTC](https://discuss.elastic.co/t/space-permission-controls-for-add-data-button/278187 "2021-07-08T20:11:24Z")
Is there a permission to remove/hide the button shown in the screenshot? I've tried trial and error but no luck. --- ## [High CPU usages in Elastic Node](https://discuss.elastic.co/t/high-cpu-usages-in-elastic-node/277996)
**Author:** [@TonyLuc](https://discuss.elastic.co/u/TonyLuc)\ **Replies:** 2\ **Last updated:** [July 8, 2021, 7:53pm UTC](https://discuss.elastic.co/t/high-cpu-usages-in-elastic-node/277996 "2021-07-08T19:53:48Z")
High CPU usages in Elastic Node In a development setting, I have both ElasticSearch, Kibana and MetricBeat running on the same server. The CPU resources are so high that I couldn’t remote onto the server. It is only wh… --- ## [Yarn kbn bootstrap fails](https://discuss.elastic.co/t/yarn-kbn-bootstrap-fails/275337)
**Author:** [@Akhil2](https://discuss.elastic.co/u/Akhil2)\ **Replies:** 27\ **Last updated:** [July 8, 2021, 7:14pm UTC](https://discuss.elastic.co/t/yarn-kbn-bootstrap-fails/275337 "2021-07-08T19:14:17Z")
Hello everyone, I have been trying to run yarn kbn bootstrap but it keeps giving me following errors. E:\\Kibana-development\\kibana\>yarn kbn bootstrap --force-install yarn run v1.22.10 $ node scripts/kbn bootstrap --for… --- ## [How do I change a symbol on the kibana panel, as per the condition](https://discuss.elastic.co/t/how-do-i-change-a-symbol-on-the-kibana-panel-as-per-the-condition/278077)
**Author:** [@francieliton\_araujo](https://discuss.elastic.co/u/francieliton_araujo)\ **Replies:** 2\ **Last updated:** [July 8, 2021, 6:08pm UTC](https://discuss.elastic.co/t/how-do-i-change-a-symbol-on-the-kibana-panel-as-per-the-condition/278077 "2021-07-08T18:08:50Z")
How do I change a symbol on the kibana panel, as per the condition. example, I wanted to show that when something had a value above 10, I would place an image, and if it was less than 10, another image. It would be poss… --- ## [\[kibana 7.13\]can not support the --allow-root when using the kibana-keystore](https://discuss.elastic.co/t/kibana-7-13-can-not-support-the-allow-root-when-using-the-kibana-keystore/278207)
**Author:** [@harry\_010](https://discuss.elastic.co/u/harry_010)\ **Replies:** 6\ **Last updated:** [July 8, 2021, 6:08pm UTC](https://discuss.elastic.co/t/kibana-7-13-can-not-support-the-allow-root-when-using-the-kibana-keystore/278207 "2021-07-08T18:08:26Z")
when I used the following command to create the Keystore, I got the following error. /usr/share/kibana/bin/kibana-keystore create --allow-root kibana.keystore located in the data folder is deprecated. Future versions … --- ## [Firefox not loading the contents in kibana dashboard](https://discuss.elastic.co/t/firefox-not-loading-the-contents-in-kibana-dashboard/278182)
**Author:** [@martianzz](https://discuss.elastic.co/u/martianzz)\ **Replies:** 1\ **Last updated:** [July 8, 2021, 5:50pm UTC](https://discuss.elastic.co/t/firefox-not-loading-the-contents-in-kibana-dashboard/278182 "2021-07-08T17:50:19Z")
OS is debian 8. Tried opening elastic in all browsers. None worked. Except for Firefox atleast loaded the contents without the values. It is working in all other Desktops. Kindly help with this issue. --- ## [Error 401 when authenticating with OpenIDConnect](https://discuss.elastic.co/t/error-401-when-authenticating-with-openidconnect/277977)
**Author:** [@Kostas\_elastic](https://discuss.elastic.co/u/Kostas_elastic)\ **Replies:** 2\ **Last updated:** [July 8, 2021, 4:29pm UTC](https://discuss.elastic.co/t/error-401-when-authenticating-with-openidconnect/277977 "2021-07-08T16:29:09Z")
Hello everyone, I am getting this error message after trying to authenticate with OIDC. {"statusCode":401,"error":"Unauthorized","message":"Response session state does not have corresponding state or nonce parameters o… --- ## [Create a table showing two "sibling" elements](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112)
**Author:** [@rgahan5c](https://discuss.elastic.co/u/rgahan5c)\ **Replies:** 7\ **Last updated:** [July 8, 2021, 3:33pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112 "2021-07-08T15:33:34Z")
I have data that is in the form: { user\_email: "test@example.com", number\_of\_emails\_sent: 100, ... } I would like to display it in a table like: User Email Number of Emails Sent test@examp… --- ## [No option for managing index patterns after Kibana Upgrade](https://discuss.elastic.co/t/no-option-for-managing-index-patterns-after-kibana-upgrade/278201)
**Author:** [@Toumal](https://discuss.elastic.co/u/Toumal)\ **Replies:** 1\ **Last updated:** [July 8, 2021, 2:55pm UTC](https://discuss.elastic.co/t/no-option-for-managing-index-patterns-after-kibana-upgrade/278201 "2021-07-08T14:55:31Z")
I've recently upgraded to the latest Kibana version (7.13) and now I don't see any option to manage index patterns. Any hints what I can do here? I have quite a few dashboards set up and simply starting over is not r… --- ## [Kibana server is not ready yet](https://discuss.elastic.co/t/kibana-server-is-not-ready-yet/277844)
**Author:** [@sagar.pattnayak](https://discuss.elastic.co/u/sagar.pattnayak)\ **Replies:** 7\ **Last updated:** [July 8, 2021, 2:17pm UTC](https://discuss.elastic.co/t/kibana-server-is-not-ready-yet/277844 "2021-07-08T14:17:09Z")
Hi There, I have recently enabled SSL for my elastic instance using out company provided SSL certificate. The elasticsearch is running fine and i can query it using https url. However when I open Kibana it says "Kibana … --- ## [Unable to send email alert using email connector in kibana](https://discuss.elastic.co/t/unable-to-send-email-alert-using-email-connector-in-kibana/278059)
**Author:** [@cuongnp](https://discuss.elastic.co/u/cuongnp)\ **Replies:** 5\ **Last updated:** [July 8, 2021, 12:15pm UTC](https://discuss.elastic.co/t/unable-to-send-email-alert-using-email-connector-in-kibana/278059 "2021-07-08T12:15:39Z")
Hi Community, After enable TLS connection between kibana and Elasticsearch ,I'm unable to send email alert using email connector. When send test mail, the result is "Error upgrading connection with STARTTLS: 454 4.7.0 … --- ## [Show fields by eventID](https://discuss.elastic.co/t/show-fields-by-eventid/278149)
**Author:** [@Arethusa](https://discuss.elastic.co/u/Arethusa)\ **Replies:** 1\ **Last updated:** [July 8, 2021, 8:14am UTC](https://discuss.elastic.co/t/show-fields-by-eventid/278149 "2021-07-08T08:14:11Z")
Hello, I'm on Kibana V 7.12.0 I have lot of Fields on Kibana : "Kibana\> Index Patterns" (1500+). I this case the logs are from Windows (nxlog). I have a field with windows event ID (5447 for example). Is it possibl… --- ## [Kibana lens](https://discuss.elastic.co/t/kibana-lens/277807)
**Author:** [@Krunal](https://discuss.elastic.co/u/Krunal)\ **Replies:** 3\ **Last updated:** [July 8, 2021, 7:39am UTC](https://discuss.elastic.co/t/kibana-lens/277807 "2021-07-08T07:39:56Z")
Hello Expert, Is there any possibility that to do changes in the tool tip... in lens it shows all the values which is correspondence to the data. But i need just focused like in TSVB Thanks --- ## [Kibana dashboard DSL aggregations problem](https://discuss.elastic.co/t/kibana-dashboard-dsl-aggregations-problem/278014)
**Author:** [@harryb](https://discuss.elastic.co/u/harryb)\ **Replies:** 3\ **Last updated:** [July 8, 2021, 7:35am UTC](https://discuss.elastic.co/t/kibana-dashboard-dsl-aggregations-problem/278014 "2021-07-08T07:35:35Z")
I am trying to filter an Elastic index to only return one record per doc\_id and which I want to base the visualization on. If I use this in a Kibana dashboard visualization filter I get an error: '\[size\] query malformed,… --- ## [Auto fit map to bounds does not work consistently in watchers](https://discuss.elastic.co/t/auto-fit-map-to-bounds-does-not-work-consistently-in-watchers/277805)
**Author:** [@MAvD](https://discuss.elastic.co/u/MAvD)\ **Replies:** 2\ **Last updated:** [July 8, 2021, 7:14am UTC](https://discuss.elastic.co/t/auto-fit-map-to-bounds-does-not-work-consistently-in-watchers/277805 "2021-07-08T07:14:05Z")
Hi, We are using elastic watchers to automatically generate pdf reports of our dashboards. In this dashboard we use a Maps visualisation with Auto fit map to bounds selected. In most of the generated pdf reports this wo… --- ## [Kibana Search Question](https://discuss.elastic.co/t/kibana-search-question/277689)
**Author:** [@azulgrana](https://discuss.elastic.co/u/azulgrana)\ **Replies:** 2\ **Last updated:** [July 7, 2021, 11:24pm UTC](https://discuss.elastic.co/t/kibana-search-question/277689 "2021-07-07T23:24:48Z")
Hi there! I have an index that has ID + Description and another index that has ID + Status. Would it be possible to report on the first index and subtract any document where the ID exist on the 2nd index and the Status … --- ## [Update filter when changing index pattern](https://discuss.elastic.co/t/update-filter-when-changing-index-pattern/278103)
**Author:** [@xolob](https://discuss.elastic.co/u/xolob)\ **Replies:** 0\ **Last updated:** [July 7, 2021, 6:05pm UTC](https://discuss.elastic.co/t/update-filter-when-changing-index-pattern/278103 "2021-07-07T18:05:53Z")
Hi everyone, i'm working on a kibana plugin (Kibana 7.10.3) wich should display data in a chart for a selected index pattern. In the line chart, a selection of the available indices is displayed at the beginning. In pri… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=305) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=307)