# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=873 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 874 --- ## [Kibana Throwing 502 Error](https://discuss.elastic.co/t/kibana-throwing-502-error/117874)
**Author:** [@john.akash](https://discuss.elastic.co/u/john.akash)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 7:49pm UTC](https://discuss.elastic.co/t/kibana-throwing-502-error/117874 "2018-01-31T19:49:05Z")
Hi Team, We are using Kibana 5.6.0 and ES 5.6.0. Kibana is hosted behind a loadbalancer. The data which we are used to index is cloudtrail data for 19 AWS accounts. As of now a single index is having nearly 75GiB data.… --- ## [Query on jboss log](https://discuss.elastic.co/t/query-on-jboss-log/117779)
**Author:** [@Vigneshprasanna](https://discuss.elastic.co/u/Vigneshprasanna)\ **Replies:** 1\ **Last updated:** [January 31, 2018, 7:12pm UTC](https://discuss.elastic.co/t/query-on-jboss-log/117779 "2018-01-31T19:12:57Z")
Hi, I'm trying to analyse the jboss log using the elk, In this POC now the data is passing from a file in local through logstach elastic search and comes here to kibana. in kibana im viewing the below format of data. I… --- ## [Scripted Fields in kibana not working](https://discuss.elastic.co/t/scripted-fields-in-kibana-not-working/117661)
**Author:** [@cilzzz](https://discuss.elastic.co/u/cilzzz)\ **Replies:** 3\ **Last updated:** [January 31, 2018, 6:37pm UTC](https://discuss.elastic.co/t/scripted-fields-in-kibana-not-working/117661 "2018-01-31T18:37:32Z")
Scripted fields only calculate sum,length and count by line ,not the entire document this is my script below: def sum = 0; for (def i = 0; i \< doc\['Return\_Code'\].length; i++) { sum = sum +doc\['Return\_Code'\]\[i\]; } re… --- ## [No results found / wildcard via Query Bar](https://discuss.elastic.co/t/no-results-found-wildcard-via-query-bar/117275)
**Author:** [@alexus](https://discuss.elastic.co/u/alexus)\ **Replies:** 4\ **Last updated:** [January 31, 2018, 5:41pm UTC](https://discuss.elastic.co/t/no-results-found-wildcard-via-query-bar/117275 "2018-01-31T17:41:37Z")
I'm using Query bar (at the top of Kibana) to search like this: bin: 123456\* I get a lot of hits, however when I add filter; bin -\> is -\> 123456\*, I get 0 hits (No results found), bin field contains 6 OR 7 numbers an… --- ## [Split and use the term in sub operation in Timelion](https://discuss.elastic.co/t/split-and-use-the-term-in-sub-operation-in-timelion/117083)
**Author:** [@anthony-o](https://discuss.elastic.co/u/anthony-o)\ **Replies:** 8\ **Last updated:** [January 31, 2018, 3:17pm UTC](https://discuss.elastic.co/t/split-and-use-the-term-in-sub-operation-in-timelion/117083 "2018-01-31T15:17:44Z")
Here is my index structure: type, from\_host, to\_host, times The "type" field can be either "error" or "valid". I would like to display distinct lines in Timelion corresponding to top 5 "from\_host" keywords, and the y v… --- ## [Kibana fit for purpose](https://discuss.elastic.co/t/kibana-fit-for-purpose/117436)
**Author:** [@Chris\_W](https://discuss.elastic.co/u/Chris_W)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 2:15pm UTC](https://discuss.elastic.co/t/kibana-fit-for-purpose/117436 "2018-01-31T14:15:24Z")
Hey all, I am looking to be sure that Kibana is fit for purpose for us. We use Power BI to pull some data out of a number of XLS spreadsheets. I know Logstash can't deal with XLS, so I will be scripting these to saved t… --- ## [Missing font color in Metric Visualization v 6.x](https://discuss.elastic.co/t/missing-font-color-in-metric-visualization-v-6-x/117812)
**Author:** [@Some\_Knowledge](https://discuss.elastic.co/u/Some_Knowledge)\ **Replies:** 0\ **Last updated:** [January 31, 2018, 1:32pm UTC](https://discuss.elastic.co/t/missing-font-color-in-metric-visualization-v-6-x/117812 "2018-01-31T13:32:48Z")
While upgrading from v5.x to v6.x I noticed missing "font color" section inside Styles under Metric Visualization. Did anything changed in Kibana or my installation has some kind of corruption? If color section should … --- ## [Fresh install kibana Rejecting mapping update to \[.kibana\] as the final mapping would have more than 1 type: \[log, doc\]](https://discuss.elastic.co/t/fresh-install-kibana-rejecting-mapping-update-to-kibana-as-the-final-mapping-would-have-more-than-1-type-log-doc/117413)
**Author:** [@zzchen](https://discuss.elastic.co/u/zzchen)\ **Replies:** 22\ **Last updated:** [January 31, 2018, 11:28am UTC](https://discuss.elastic.co/t/fresh-install-kibana-rejecting-mapping-update-to-kibana-as-the-final-mapping-would-have-more-than-1-type-log-doc/117413 "2018-01-31T11:28:40Z")
Hi, \[Background\] I upgrade ES from 5.6 to 6.1.2 and the kibana version is 6.1.2 (All are docker with OSS distributed version). For some reason, i would like to use a fresh new kibana installation, so i delete '.kibana… --- ## [Wildacard (.\*) is not giving as expected result](https://discuss.elastic.co/t/wildacard-is-not-giving-as-expected-result/114230)
**Author:** [@saravanan\_kutty](https://discuss.elastic.co/u/saravanan_kutty)\ **Replies:** 8\ **Last updated:** [January 31, 2018, 11:21am UTC](https://discuss.elastic.co/t/wildacard-is-not-giving-as-expected-result/114230 "2018-01-31T11:21:46Z")
Recently i used hostname: ".\*" which doesnt give any result surprisingly, since two weeks back it was working perfect. is there anything i am missing here and i need to have work around for it. Thanks in advance --- ## [Is there any way to embed visualization to kibana plugin pages?](https://discuss.elastic.co/t/is-there-any-way-to-embed-visualization-to-kibana-plugin-pages/117622)
**Author:** [@596375269](https://discuss.elastic.co/u/596375269)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 9:11am UTC](https://discuss.elastic.co/t/is-there-any-way-to-embed-visualization-to-kibana-plugin-pages/117622 "2018-01-31T09:11:41Z")
as shown in the title. is it possible in kibana 6.1? i use this document 'https://www.elastic.co/guide/en/kibana/current/development-embedding-visualizations.html' and the plugin template 'https://github.com/elastic… --- ## [Kibana 6.1.0 frame embed does not load](https://discuss.elastic.co/t/kibana-6-1-0-frame-embed-does-not-load/117452)
**Author:** [@ld\_pvl](https://discuss.elastic.co/u/ld_pvl)\ **Replies:** 7\ **Last updated:** [January 31, 2018, 9:52am UTC](https://discuss.elastic.co/t/kibana-6-1-0-frame-embed-does-not-load/117452 "2018-01-31T09:52:29Z")
Hi Everyone, I am embedding a Kibana discover url inside a frame inside my web app. It used to work on 5.x but for 6.1 it just keeps showing the loading circle indefinitely. Nothing has changed on my web app - only the… --- ## [Issue in exporting dashboard with its related visualizations](https://discuss.elastic.co/t/issue-in-exporting-dashboard-with-its-related-visualizations/117756)
**Author:** [@kabali12345](https://discuss.elastic.co/u/kabali12345)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 9:48am UTC](https://discuss.elastic.co/t/issue-in-exporting-dashboard-with-its-related-visualizations/117756 "2018-01-31T09:48:50Z")
Matt Bargar The dashboard saved object document contains the IDs of all its linked visualizations. You can't do joins in ES so there's no way to grab everything in a single query, but you could easily write a script tha… --- ## [Visualizing a prometheus histogram](https://discuss.elastic.co/t/visualizing-a-prometheus-histogram/117669)
**Author:** [@gkle](https://discuss.elastic.co/u/gkle)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 8:51am UTC](https://discuss.elastic.co/t/visualizing-a-prometheus-histogram/117669 "2018-01-31T08:51:32Z")
Hi, I'm receiving through metricbeat and prometheus a snapshot of a histogram. The document looks like this : { ... histBar1 : value1, histBar2 : value2, ... histBarN : valueN } I'd like create a vertical bar vi… --- ## [Changing weekly interval in Visual Builder](https://discuss.elastic.co/t/changing-weekly-interval-in-visual-builder/117509)
**Author:** [@EatYourCake](https://discuss.elastic.co/u/EatYourCake)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 6:07am UTC](https://discuss.elastic.co/t/changing-weekly-interval-in-visual-builder/117509 "2018-01-31T06:07:21Z")
Hi, I am trying to create a graph with the Visual Builder with weekly intervals. The weekly interval that interests us starts on Sunday and not Monday (which is what the graph is currently doing). I've also built a num… --- ## [Kibana Nested Query](https://discuss.elastic.co/t/kibana-nested-query/117716)
**Author:** [@Godacre](https://discuss.elastic.co/u/Godacre)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 4:02am UTC](https://discuss.elastic.co/t/kibana-nested-query/117716 "2018-01-31T04:02:59Z")
Hi, I am currently trying to set up a visualisation in Kibana to monitor the overall number of requests entering the system. I have been looking around extensively to try and find some guidance on how to reach my desire… --- ## [Is it possible to restrict users in Kibana to access ceratin indices?](https://discuss.elastic.co/t/is-it-possible-to-restrict-users-in-kibana-to-access-ceratin-indices/117732)
**Author:** [@amruth](https://discuss.elastic.co/u/amruth)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 3:57am UTC](https://discuss.elastic.co/t/is-it-possible-to-restrict-users-in-kibana-to-access-ceratin-indices/117732 "2018-01-31T03:57:23Z")
Hi, I have setup http authentication using Nginx to Kibana and trying to setup restrictions on certain elasticsearch Indices from Kibana UI. Can someone please suggest if it's possible without using Shield? Thanks --- ## [Elasticsearch's action.auto\_create\_index setting impact on Kibana](https://discuss.elastic.co/t/elasticsearchs-action-auto-create-index-setting-impact-on-kibana/117701)
**Author:** [@pri](https://discuss.elastic.co/u/pri)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 2:29am UTC](https://discuss.elastic.co/t/elasticsearchs-action-auto-create-index-setting-impact-on-kibana/117701 "2018-01-31T02:29:34Z")
Hi, We are on Kibana 6.1 and ES 6.1. In one of our ES production clusters, we have action.auto\_create\_index setting as false. And when I try to create a new index pattern on Kibana, it throws an error saying that this p… --- ## [Log/Track/Monitor Kibana user sessions](https://discuss.elastic.co/t/log-track-monitor-kibana-user-sessions/117700)
**Author:** [@acastellano](https://discuss.elastic.co/u/acastellano)\ **Replies:** 1\ **Last updated:** [January 31, 2018, 2:01am UTC](https://discuss.elastic.co/t/log-track-monitor-kibana-user-sessions/117700 "2018-01-31T02:01:49Z")
I've set up AD integration with Kibana successfully and am able to log in with AD creds. Are user sessions or logins logged anywhere for Kibana? I've turned on verbose logging in /var/log/kibana.log but no session/login… --- ## [Kibana Setup with ElasticSeach Cluster - ELB or Client Node?](https://discuss.elastic.co/t/kibana-setup-with-elasticseach-cluster-elb-or-client-node/117676)
**Author:** [@titan1978](https://discuss.elastic.co/u/titan1978)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 9:40pm UTC](https://discuss.elastic.co/t/kibana-setup-with-elasticseach-cluster-elb-or-client-node/117676 "2018-01-30T21:40:00Z")
Had posted this incorrectly in the elasticsearch forums. Hello - as part of my continuous learning on setting up an AWS EC2 based architecture of my Kibana Stack with ElasticSearch, on trawling forums I've come to under… --- ## [Where is configuration stored?](https://discuss.elastic.co/t/where-is-configuration-stored/117633)
**Author:** [@some7](https://discuss.elastic.co/u/some7)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 9:35pm UTC](https://discuss.elastic.co/t/where-is-configuration-stored/117633 "2018-01-30T21:35:07Z")
When you create index patterns, mappings for fields, visualizations, dashboards, etc in kibana, where are these settings stored? When I reinstall my system I'd like to be able to restore everything to exactly how it was. … --- ## [How to genarate kibana ssl certificate pem format](https://discuss.elastic.co/t/how-to-genarate-kibana-ssl-certificate-pem-format/117569)
**Author:** [@sreenu](https://discuss.elastic.co/u/sreenu)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 9:32pm UTC](https://discuss.elastic.co/t/how-to-genarate-kibana-ssl-certificate-pem-format/117569 "2018-01-30T21:32:44Z")
Hi all, I am using kibana . my requirement is HTTP:localhost:5601 to https:localhost:5601 how can provide secure url? thanks, sreenu. --- ## [How do I create visualizations with data from two indices?](https://discuss.elastic.co/t/how-do-i-create-visualizations-with-data-from-two-indices/117525)
**Author:** [@Runcibleman](https://discuss.elastic.co/u/Runcibleman)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 9:28pm UTC](https://discuss.elastic.co/t/how-do-i-create-visualizations-with-data-from-two-indices/117525 "2018-01-30T21:28:13Z")
I have a common index pattern, say abc-index\*, which captures two indices, for example: abc-index-log and abc-index-users. The log contains data on interactions by known users. The users index contains information abo… --- ## [Visualization confusion - new pie chart layer includes previous layers](https://discuss.elastic.co/t/visualization-confusion-new-pie-chart-layer-includes-previous-layers/117523)
**Author:** [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Replies:** 3\ **Last updated:** [January 30, 2018, 7:12pm UTC](https://discuss.elastic.co/t/visualization-confusion-new-pie-chart-layer-includes-previous-layers/117523 "2018-01-30T19:12:42Z")
Hello, I hope my screenshots can explain the problem simply. I created a pie chart that forms a range (percentage) of a few slices representing 0-100% Each slice counts a separate set. However, see screenshots - each s… --- ## [Creating line chart using datetime values](https://discuss.elastic.co/t/creating-line-chart-using-datetime-values/114979)
**Author:** [@suryagprakash](https://discuss.elastic.co/u/suryagprakash)\ **Replies:** 3\ **Last updated:** [January 30, 2018, 5:54pm UTC](https://discuss.elastic.co/t/creating-line-chart-using-datetime-values/114979 "2018-01-30T17:54:05Z")
Hi All, I am new to ELK stack and need help with creating linechart using time values. I have 3 time fields in a my document and want to plot a line chart using these values. Example I have below fields and values T… --- ## [Kibana X-pack Machine Learning Jobs list could not be retrieved](https://discuss.elastic.co/t/kibana-x-pack-machine-learning-jobs-list-could-not-be-retrieved/117501)
**Author:** [@thirusama](https://discuss.elastic.co/u/thirusama)\ **Replies:** 10\ **Last updated:** [January 30, 2018, 4:38pm UTC](https://discuss.elastic.co/t/kibana-x-pack-machine-learning-jobs-list-could-not-be-retrieved/117501 "2018-01-30T16:38:52Z")
Versions being used ( all are installed on a single node). logstash-6.0.1 elasticsearch-6.1.1 kibana-6.1.1-linux-x86\_64 I am getting the error in Machine learning -\> Job Management Page. Error: Job list could not be… --- ## [Visualizing the count of words in each document(pdf, word) in kibana](https://discuss.elastic.co/t/visualizing-the-count-of-words-in-each-document-pdf-word-in-kibana/116523)
**Author:** [@manasguduri](https://discuss.elastic.co/u/manasguduri)\ **Replies:** 3\ **Last updated:** [January 30, 2018, 4:23pm UTC](https://discuss.elastic.co/t/visualizing-the-count-of-words-in-each-document-pdf-word-in-kibana/116523 "2018-01-30T16:23:56Z")
Hello All, I have to visualize the count of each word in a document and a count of word appearance in each document individually ! Is that possible in kibana ? Please, respond fast, I have been strucked for days in he… --- ## [Hosted geojson file on github but kibana is not loading it](https://discuss.elastic.co/t/hosted-geojson-file-on-github-but-kibana-is-not-loading-it/117491)
**Author:** [@ashishmadeti](https://discuss.elastic.co/u/ashishmadeti)\ **Replies:** 5\ **Last updated:** [January 30, 2018, 4:07pm UTC](https://discuss.elastic.co/t/hosted-geojson-file-on-github-but-kibana-is-not-loading-it/117491 "2018-01-30T16:07:19Z")
Kibana fails with the following error: \[image\] The geojson data is hosted at: https://raw.githubusercontent.com/ashishmadeti/india/master/state/india\_telengana.geojson I am using the field "NAME\_1" and my kibana co… --- ## [To have logs on for Kibana](https://discuss.elastic.co/t/to-have-logs-on-for-kibana/116221)
**Author:** [@nivedita\_singh](https://discuss.elastic.co/u/nivedita_singh)\ **Replies:** 3\ **Last updated:** [January 30, 2018, 8:58am UTC](https://discuss.elastic.co/t/to-have-logs-on-for-kibana/116221 "2018-01-30T08:58:07Z")
Hi , Can someone help to get logs for Kibana , I have changed the kibana yml to verbose logs true. It has only created logs folder but there are no logs there. I need help to have logs for Kibana. Thanks Nivedita S… --- ## [Delete by Query - Based on time](https://discuss.elastic.co/t/delete-by-query-based-on-time/117456)
**Author:** [@ganeshmuralidhar](https://discuss.elastic.co/u/ganeshmuralidhar)\ **Replies:** 4\ **Last updated:** [January 30, 2018, 8:18am UTC](https://discuss.elastic.co/t/delete-by-query-based-on-time/117456 "2018-01-30T08:18:03Z")
Hello, I am trying to delete data from Elastic Search based on timestamp. I could not find a way to do it after giving multiple tries with the below: POST index\_name/\_delete\_by\_query { "query": { "range" : { "@time… --- ## [Timelion not displaying](https://discuss.elastic.co/t/timelion-not-displaying/115503)
**Author:** [@Robert\_Naccache](https://discuss.elastic.co/u/Robert_Naccache)\ **Replies:** 3\ **Last updated:** [January 30, 2018, 7:42am UTC](https://discuss.elastic.co/t/timelion-not-displaying/115503 "2018-01-30T07:42:58Z")
Hello! I'm having a little issue with kibana's (5.6.4) timelion not showing a line at certain points of my visualization. My data looks like this: "monitoringtable": "TD\_INSBRN ", "counter\_entries": 24, … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=872) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=874)