# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=651 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 652 --- ## [Scatterplot in Vega Error](https://discuss.elastic.co/t/scatterplot-in-vega-error/187419)
**Author:** [@dundundundun](https://discuss.elastic.co/u/dundundundun)\ **Replies:** 1\ **Last updated:** [June 25, 2019, 8:26pm UTC](https://discuss.elastic.co/t/scatterplot-in-vega-error/187419 "2019-06-25T20:26:39Z")
Hi! I am trying to create a scatterplot with data from my index "testing" with @timestamp on the x-axis and the field "reboot" on the y-axis through the Vega visualization platform. However, I'm getting the following err… --- ## [Kibana Security](https://discuss.elastic.co/t/kibana-security/187339)
**Author:** [@manosmustang](https://discuss.elastic.co/u/manosmustang)\ **Replies:** 1\ **Last updated:** [June 25, 2019, 6:23pm UTC](https://discuss.elastic.co/t/kibana-security/187339 "2019-06-25T18:23:48Z")
Hello, Is there any document that can help to add/install security at Elastic Kibana 7.1.1? I cannot find something after the latest release and it is not clear how to start. Thank you --- ## [How can i write these sql query in kibana?](https://discuss.elastic.co/t/how-can-i-write-these-sql-query-in-kibana/187208)
**Author:** [@Pramod\_Thakur](https://discuss.elastic.co/u/Pramod_Thakur)\ **Replies:** 1\ **Last updated:** [June 25, 2019, 3:17pm UTC](https://discuss.elastic.co/t/how-can-i-write-these-sql-query-in-kibana/187208 "2019-06-25T15:17:44Z")
How can I write these following query in kibana? SELECT distinct description FROM customers; select description,count(\*) from customers; I am trying with following but not getting expected result. 1st Query GET custo… --- ## [Price of the gold license?](https://discuss.elastic.co/t/price-of-the-gold-license/187217)
**Author:** [@Bachtiar\_Hendro](https://discuss.elastic.co/u/Bachtiar_Hendro)\ **Replies:** 1\ **Last updated:** [June 25, 2019, 3:04pm UTC](https://discuss.elastic.co/t/price-of-the-gold-license/187217 "2019-06-25T15:04:43Z")
what is the elastic price of the gold license for 1 user? i just wanna use thresshold and alerting fitur in this software --- ## [Kibana Discover not Returning Data but Dev Tools Console is](https://discuss.elastic.co/t/kibana-discover-not-returning-data-but-dev-tools-console-is/187137)
**Author:** [@thadc](https://discuss.elastic.co/u/thadc)\ **Replies:** 4\ **Last updated:** [June 25, 2019, 2:45pm UTC](https://discuss.elastic.co/t/kibana-discover-not-returning-data-but-dev-tools-console-is/187137 "2019-06-25T14:45:16Z")
Hi, I have created new indices in the past week that have data based upon my basic searches from kibana (6.4) Dev Tools console. For instance, a basic search: GET /foo-index-2019.06.22/\_search?q=&pretty$size=100 bring… --- ## [Kibana user session tracking](https://discuss.elastic.co/t/kibana-user-session-tracking/186226)
**Author:** [@Yungyoung\_Ok](https://discuss.elastic.co/u/Yungyoung_Ok)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 12:58pm UTC](https://discuss.elastic.co/t/kibana-user-session-tracking/186226 "2019-06-25T12:58:26Z")
I have three questions. I want to track user actions in Kibana. However, the session ID is changed for each request. (I use Kibana6.7.0) First, The session id seems to be encrypted, is that correct? If so, how shou… --- ## [\[Kibana Enhanced Table\] Request for Docs and Tutorials for Scripting Language](https://discuss.elastic.co/t/kibana-enhanced-table-request-for-docs-and-tutorials-for-scripting-language/186615)
**Author:** [@Zany](https://discuss.elastic.co/u/Zany)\ **Replies:** 5\ **Last updated:** [June 25, 2019, 9:56am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-request-for-docs-and-tutorials-for-scripting-language/186615 "2019-06-25T09:56:59Z")
First of all, I would like to thank @fbaligand for creating the awesome Kibana Enhanced Table plugin, it is really useful. I understand that I can use col\[n\] to reference existing columns in the data table to derive a n… --- ## [Logs Timestamp](https://discuss.elastic.co/t/logs-timestamp/186207)
**Author:** [@PritiS](https://discuss.elastic.co/u/PritiS)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 8:47am UTC](https://discuss.elastic.co/t/logs-timestamp/186207 "2019-06-25T08:47:47Z")
Hi , I am trying to fetch total timings taken by a Job from Status A to Status B from logs, extracted Log timestamp column,status, jobid from logs in Kibana, How can we extract the total time taken by the Job ID and vis… --- ## [Authentication with Kibana in HTML Iframe](https://discuss.elastic.co/t/authentication-with-kibana-in-html-iframe/186476)
**Author:** [@Nsaneone](https://discuss.elastic.co/u/Nsaneone)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 8:59am UTC](https://discuss.elastic.co/t/authentication-with-kibana-in-html-iframe/186476 "2019-06-25T08:59:27Z")
Good Afternoon. Been trying to get Kibana Visualisation to load into an Iframe (using the link auto generated). This works however there is Kibana login prompt that occurs. I wanted to ask if there is anyway I could pass… --- ## [Share visualisations with read-only users](https://discuss.elastic.co/t/share-visualisations-with-read-only-users/187166)
**Author:** [@Kult](https://discuss.elastic.co/u/Kult)\ **Replies:** 4\ **Last updated:** [June 25, 2019, 8:54am UTC](https://discuss.elastic.co/t/share-visualisations-with-read-only-users/187166 "2019-06-25T08:54:09Z")
Hi, I'm looking for a way to share visualisations with read-only users. The kibana\_dashboard\_only\_user role works like a charm for dashboards, and since dashboards are basically collections of visualisations I'd think t… --- ## [\[Discussion\] Comparison between Visual Builder (Time Series), Line Chart and Timelion Chart](https://discuss.elastic.co/t/discussion-comparison-between-visual-builder-time-series-line-chart-and-timelion-chart/185783)
**Author:** [@Zany](https://discuss.elastic.co/u/Zany)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 2:03am UTC](https://discuss.elastic.co/t/discussion-comparison-between-visual-builder-time-series-line-chart-and-timelion-chart/185783 "2019-06-25T02:03:08Z")
In Visualize Mode, Visual Builder (Time Series), Line Chart and Timelion Chart are available to the users for building time-series visualizations. As I am new to Kibana, I would like to welcome the community to share vie… --- ## [Scripted Field substring error](https://discuss.elastic.co/t/scripted-field-substring-error/186424)
**Author:** [@Chris4](https://discuss.elastic.co/u/Chris4)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 6:42am UTC](https://discuss.elastic.co/t/scripted-field-substring-error/186424 "2019-06-25T06:42:20Z")
Iam trying to create a an scripted field "MatID" which should contain a substring of another field "epc.keyword" - if this exists. Most of the time this works fine but from time to time i get the following error alert a… --- ## [Kibana LDAP authentication 6.8.0](https://discuss.elastic.co/t/kibana-ldap-authentication-6-8-0/187113)
**Author:** [@akshay\_singh2](https://discuss.elastic.co/u/akshay_singh2)\ **Replies:** 5\ **Last updated:** [June 25, 2019, 6:38am UTC](https://discuss.elastic.co/t/kibana-ldap-authentication-6-8-0/187113 "2019-06-25T06:38:51Z")
Hello Team, We are running ELK stack on 6.8 without any LDAP or AD authentication. Now i want to configure LDAP authentication for Kibana. Any help on this will be very appreciated. Thanks Akshay. --- ## ["root\_cause": \[ { "type": "mapper\_parsing\_exception", "reason": "failed to parse field \[query.sort.school\_year.keyword\] of type \[text\] in document with id '21019'" } \],](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101)
**Author:** [@Sakthivanan](https://discuss.elastic.co/u/Sakthivanan)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 6:02am UTC](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101 "2019-06-25T06:02:24Z")
"query": { "sort": \[ { "school\_year.keyword": { "order": "desc" } } \], "size": 999, "\_source": { "excludes": \[ "@version", "@timestamp", … --- ## [How ElasticDSL connects with Elastic Search API?](https://discuss.elastic.co/t/how-elasticdsl-connects-with-elastic-search-api/187072)
**Author:** [@saravananselvamohan](https://discuss.elastic.co/u/saravananselvamohan)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 3:27am UTC](https://discuss.elastic.co/t/how-elasticdsl-connects-with-elastic-search-api/187072 "2019-06-25T03:27:19Z")
I have a ElasticDSL Query with me. When I execute this query in console How it connects to SearchAPI in Elasticsearch and fetches the data. How the GET,POST methods are managed in Kibana to connect with ElasticSearch --- ## [Customize the title of share link](https://discuss.elastic.co/t/customize-the-title-of-share-link/187202)
**Author:** [@csholic](https://discuss.elastic.co/u/csholic)\ **Replies:** 5\ **Last updated:** [June 25, 2019, 1:51am UTC](https://discuss.elastic.co/t/customize-the-title-of-share-link/187202 "2019-06-25T01:51:06Z")
Hi, I'm currently using Kibana for the visualization of our project, I built some charts using the data from Elasticsearch. My manager wants me to share the link of the dashboard so that anyone who has the link can view… --- ## [Sign-in to Kibana only with Google Account](https://discuss.elastic.co/t/sign-in-to-kibana-only-with-google-account/187133)
**Author:** [@Louis-Clement](https://discuss.elastic.co/u/Louis-Clement)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 1:00am UTC](https://discuss.elastic.co/t/sign-in-to-kibana-only-with-google-account/187133 "2019-06-25T01:00:55Z")
Hi! I followed these guides to sign-in to Kibana with a Google Account using Nginx and OAuth2\_proxy: And it works great! But I have a question: By theses methods I need a common password for Kibana users that I hav… --- ## [Encrypting communications in Kibana](https://discuss.elastic.co/t/encrypting-communications-in-kibana/186369)
**Author:** [@philshikkim](https://discuss.elastic.co/u/philshikkim)\ **Replies:** 4\ **Last updated:** [June 21, 2019, 7:18am UTC](https://discuss.elastic.co/t/encrypting-communications-in-kibana/186369 "2019-06-21T07:18:55Z")
Hello, English is not my native language. I hope you get my drift. I want to make a Kibana secure communication using https. So I made this following: $ openssl genrsa -out server.key 2048 $ openssl req -new -key ser… --- ## [How to calculate daily new users to a website](https://discuss.elastic.co/t/how-to-calculate-daily-new-users-to-a-website/186214)
**Author:** [@Havana](https://discuss.elastic.co/u/Havana)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 11:32pm UTC](https://discuss.elastic.co/t/how-to-calculate-daily-new-users-to-a-website/186214 "2019-06-24T23:32:45Z")
We're using Elasticsearch to visualize our website usage data. Each day there are new users coming into our website. How can I calculate the number of new users and visualize it with a line graph? --- ## [Unable to find EMS tile configuration for id: road\_map](https://discuss.elastic.co/t/unable-to-find-ems-tile-configuration-for-id-road-map/186990)
**Author:** [@karnamonkster](https://discuss.elastic.co/u/karnamonkster)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 8:37pm UTC](https://discuss.elastic.co/t/unable-to-find-ems-tile-configuration-for-id-road-map/186990 "2019-06-24T20:37:13Z")
How do we fix this? Have also tried doing as per the link It was working fine before i upgraded to 6.8.0. I have a setup where we are behind corporate proxy Please help. --- ## [REST API object definitions](https://discuss.elastic.co/t/rest-api-object-definitions/187170)
**Author:** [@Matheu](https://discuss.elastic.co/u/Matheu)\ **Replies:** 8\ **Last updated:** [June 24, 2019, 8:32pm UTC](https://discuss.elastic.co/t/rest-api-object-definitions/187170 "2019-06-24T20:32:39Z")
I'm trying to use the Create Object REST API I want to pass what I have obtained from a find call... "attributes": { "title": "ohip\_request", "timeFieldName": "createdTime", "… --- ## [How to check that index pattern is not synced with mapping using kibana plugin?](https://discuss.elastic.co/t/how-to-check-that-index-pattern-is-not-synced-with-mapping-using-kibana-plugin/183723)
**Author:** [@Riddhesh](https://discuss.elastic.co/u/Riddhesh)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 8:18pm UTC](https://discuss.elastic.co/t/how-to-check-that-index-pattern-is-not-synced-with-mapping-using-kibana-plugin/183723 "2019-06-24T20:18:42Z")
I'm trying to create kibana plugin that refreshes kibana index-pattern. Instead of doing it periodically. Is there any way we can check after user has loaded the discover or visualize page, if the selected index pattern… --- ## [Kibana outputs limit](https://discuss.elastic.co/t/kibana-outputs-limit/184339)
**Author:** [@gurunga011](https://discuss.elastic.co/u/gurunga011)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 7:54pm UTC](https://discuss.elastic.co/t/kibana-outputs-limit/184339 "2019-06-24T19:54:15Z")
Hi everyone. I am trying to see the time it takes to process all of my outputs in kibana console(Version 6x..). My outputs are in millions. And kibana console just shows me only 1002 outputs. How do I fix this? I am usin… --- ## [There is a problem with this saved object A field associated with this object no longer exists in the index pattern. If you know what this error means, go ahead and fix it — otherwise click the delete button above](https://discuss.elastic.co/t/there-is-a-problem-with-this-saved-object-a-field-associated-with-this-object-no-longer-exists-in-the-index-pattern-if-you-know-what-this-error-means-go-ahead-and-fix-it-otherwise-click-the-delete-button-above/187175)
**Author:** [@Analyst](https://discuss.elastic.co/u/Analyst)\ **Replies:** 6\ **Last updated:** [June 24, 2019, 7:32pm UTC](https://discuss.elastic.co/t/there-is-a-problem-with-this-saved-object-a-field-associated-with-this-object-no-longer-exists-in-the-index-pattern-if-you-know-what-this-error-means-go-ahead-and-fix-it-otherwise-click-the-delete-button-above/187175 "2019-06-24T19:32:45Z")
Hi Team, I recently imported a saved object into the kibana, but some of the visualizations are working fine but some of them are throwing the above error. I see that there are few posts on thsi topic but i having troub… --- ## [Splunk query to Kibana](https://discuss.elastic.co/t/splunk-query-to-kibana/187118)
**Author:** [@m.sereda](https://discuss.elastic.co/u/m.sereda)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 5:45pm UTC](https://discuss.elastic.co/t/splunk-query-to-kibana/187118 "2019-06-24T17:45:43Z")
How to convert this to kibana query language? index=visiona "field id=\\"0\\" value=\\"0110\\"" | rex max\_match=0 "field id=\\"39\\" value=\\"(?\(\[0-9A-Z\]+))\\"" | where code = "00" OR code="N0" OR code="91" | timechart co… --- ## [How can i integrate a dashboard kibana in my angular application without using iframe?](https://discuss.elastic.co/t/how-can-i-integrate-a-dashboard-kibana-in-my-angular-application-without-using-iframe/187127)
**Author:** [@leyla1](https://discuss.elastic.co/u/leyla1)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 5:23pm UTC](https://discuss.elastic.co/t/how-can-i-integrate-a-dashboard-kibana-in-my-angular-application-without-using-iframe/187127 "2019-06-24T17:23:44Z")
how can i integrate a dashboard kibana in my angular application without using iframe ? --- ## [Apache Reverse Proxy with Smart Card Login issues](https://discuss.elastic.co/t/apache-reverse-proxy-with-smart-card-login-issues/186321)
**Author:** [@S\_Chase](https://discuss.elastic.co/u/S_Chase)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 5:18pm UTC](https://discuss.elastic.co/t/apache-reverse-proxy-with-smart-card-login-issues/186321 "2019-06-24T17:18:46Z")
Greetings, RHEL7 Elastic Stack 6.8 Apache 2.4 In order to do Multi-Factor Authentication I set up an Apache 2.4 Reverse Proxy with SSL. That part works well, it requests the smartcard pin and successfully checks it. … --- ## [Kibana 7.1.1 - Examples of visualization queries](https://discuss.elastic.co/t/kibana-7-1-1-examples-of-visualization-queries/187179)
**Author:** [@Alexl](https://discuss.elastic.co/u/Alexl)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 5:17pm UTC](https://discuss.elastic.co/t/kibana-7-1-1-examples-of-visualization-queries/187179 "2019-06-24T17:17:57Z")
Hello all! Please, provide some beautiful and clear queries that are needed by some visualizations. Thank you for your assistance. --- ## [Visualization type line with data and non-metric](https://discuss.elastic.co/t/visualization-type-line-with-data-and-non-metric/185980)
**Author:** [@diego\_oliveira](https://discuss.elastic.co/u/diego_oliveira)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 4:38pm UTC](https://discuss.elastic.co/t/visualization-type-line-with-data-and-non-metric/185980 "2019-06-24T16:38:38Z")
I am sending data to the elasticsearch in json directly and would like to create a visualization of the type line with some values that comes in json without applying any metrics, just show the evolution of them values a… --- ## [Failed to poll for work](https://discuss.elastic.co/t/failed-to-poll-for-work/186946)
**Author:** [@HuangJiaRen](https://discuss.elastic.co/u/HuangJiaRen)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 3:59pm UTC](https://discuss.elastic.co/t/failed-to-poll-for-work/186946 "2019-06-24T15:59:53Z")
Failed to poll for work: \[search\_phase\_execution\_exception\] all shards failed :: {"path":"/.kibana\_task\_manager/\_search","query":{"ignore\_unavailable":true},"body":"{\\"query\\":{\\"bool\\":{\\"must\\":\[{\\"term\\":{\\"type\\":\\"t… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=650) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=652)