# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=759 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 760 --- ## [How to setup pki auth for kibana and elasticsearch](https://discuss.elastic.co/t/how-to-setup-pki-auth-for-kibana-and-elasticsearch/154729)
**Author:** [@rmadoori](https://discuss.elastic.co/u/rmadoori)\ **Replies:** 7\ **Last updated:** [November 2, 2018, 1:36pm UTC](https://discuss.elastic.co/t/how-to-setup-pki-auth-for-kibana-and-elasticsearch/154729 "2018-11-02T13:36:37Z")
Hello. I would like to set Kibana to use PKI auth instead of username/password. I have added realms in elasticsearch.yml file. but it dint work . \` elasticsearch.yml cluster.name: cluster node.master: false node.data… --- ## [How use .p12 key for TLS in Kibana](https://discuss.elastic.co/t/how-use-p12-key-for-tls-in-kibana/154917)
**Author:** [@rijinmp](https://discuss.elastic.co/u/rijinmp)\ **Replies:** 2\ **Last updated:** [November 2, 2018, 12:11pm UTC](https://discuss.elastic.co/t/how-use-p12-key-for-tls-in-kibana/154917 "2018-11-02T12:11:03Z")
Hi all , I know how to use .key and .rt files for enable TLS in KIbana with ES. Can you explain how use .p12 file in kibana for TLS. My current Kibana working conf mentioning below. xpack.monitoring.enabled: true se… --- ## [Filter to query bar](https://discuss.elastic.co/t/filter-to-query-bar/154771)
**Author:** [@omoulin](https://discuss.elastic.co/u/omoulin)\ **Replies:** 2\ **Last updated:** [November 2, 2018, 9:35am UTC](https://discuss.elastic.co/t/filter-to-query-bar/154771 "2018-11-02T09:35:20Z")
Hi, To make a query in Kibana, we used to write a request like @fields.CPAID:"KO\_GEKKO" AND @fields.CUSTID:"12", or select the "+" button to add a part of the request in the query in Kibana 3 But know (Kibana 6) we hav… --- ## [Kibana Metric with simple query](https://discuss.elastic.co/t/kibana-metric-with-simple-query/155021)
**Author:** [@hugohendriks](https://discuss.elastic.co/u/hugohendriks)\ **Replies:** 4\ **Last updated:** [November 2, 2018, 8:55am UTC](https://discuss.elastic.co/t/kibana-metric-with-simple-query/155021 "2018-11-02T08:55:21Z")
Hi, Í am trying to get a simple metric visualization going by making a Metric, with a count aggregation and then selecting a filter in wich I set the query...something like: operation : Validatie\* and httpresponse : 50… --- ## [I do not understand why 'kibana' does not work](https://discuss.elastic.co/t/i-do-not-understand-why-kibana-does-not-work/155110)
**Author:** [@ksb304](https://discuss.elastic.co/u/ksb304)\ **Replies:** 7\ **Last updated:** [November 2, 2018, 6:33am UTC](https://discuss.elastic.co/t/i-do-not-understand-why-kibana-does-not-work/155110 "2018-11-02T06:33:31Z")
Kibana does not work after rebooting the server. I do not understand why 'kibana' does not work. What's the problem? --- ## [Request to Elasticsearch failed](https://discuss.elastic.co/t/request-to-elasticsearch-failed/154947)
**Author:** [@SteveNeedsHelp](https://discuss.elastic.co/u/SteveNeedsHelp)\ **Replies:** 1\ **Last updated:** [November 2, 2018, 3:39am UTC](https://discuss.elastic.co/t/request-to-elasticsearch-failed/154947 "2018-11-02T03:39:58Z")
Kibana 6.4.2 ElasticSearch 6.4.2 We are getting this error in Kibana having left a dashboard connected overnight Version: 6.4.2 Build: 18010 Error: Request to Elasticsearch failed: {"error":{"root\_cause":,"type":"se… --- ## [Multiple Kibana instances - again](https://discuss.elastic.co/t/multiple-kibana-instances-again/155011)
**Author:** [@wheelq](https://discuss.elastic.co/u/wheelq)\ **Replies:** 1\ **Last updated:** [November 2, 2018, 3:27am UTC](https://discuss.elastic.co/t/multiple-kibana-instances-again/155011 "2018-11-02T03:27:05Z")
Are there any cons for having multiple Kibana instances? I read that it might cause some issues due to sharing single .kibana config stored inside the ES cluster/node. Also, earlier it made sense as Kibana could talk to… --- ## [Vega Viz - Displaying data in Bytes](https://discuss.elastic.co/t/vega-viz-displaying-data-in-bytes/154929)
**Author:** [@nyssa](https://discuss.elastic.co/u/nyssa)\ **Replies:** 2\ **Last updated:** [November 1, 2018, 4:58pm UTC](https://discuss.elastic.co/t/vega-viz-displaying-data-in-bytes/154929 "2018-11-01T16:58:49Z")
Goal : Need to display data in Bytes. I am trying to use numeral.js on Kibana for a vega viz but am not able to get the data to display in bytes. This is the library http://numeraljs.com/ and this is my signal "signal"… --- ## [Date time in index name, Kibana searching across non relevant indexes](https://discuss.elastic.co/t/date-time-in-index-name-kibana-searching-across-non-relevant-indexes/154669)
**Author:** [@amageek](https://discuss.elastic.co/u/amageek)\ **Replies:** 7\ **Last updated:** [November 1, 2018, 3:14pm UTC](https://discuss.elastic.co/t/date-time-in-index-name-kibana-searching-across-non-relevant-indexes/154669 "2018-11-01T15:14:16Z")
Hi, I've read so much on this, but dated information, and wondered if things have changed or anyone knows of a good way to handle this in kibana/elastic. So given an index name that has a date in it e.g events\_10\_2018 … --- ## [RESOLVED: Search Bug in 5.6.12 when searching with an Alias](https://discuss.elastic.co/t/resolved-search-bug-in-5-6-12-when-searching-with-an-alias/155034)
**Author:** [@tebriel](https://discuss.elastic.co/u/tebriel)\ **Replies:** 2\ **Last updated:** [November 1, 2018, 2:59pm UTC](https://discuss.elastic.co/t/resolved-search-bug-in-5-6-12-when-searching-with-an-alias/155034 "2018-11-01T14:59:04Z")
I'm running 5.6.12 (both Kibana and ES). I have an alias that points to 31 indices. In Kibana I have two index patterns.: panorama-staging -- an alias \*staging\*-ivr-auth-master-\* -- the raw pattern used to create the… --- ## [Timelion count with a condition](https://discuss.elastic.co/t/timelion-count-with-a-condition/154925)
**Author:** [@Joseph\_Mak](https://discuss.elastic.co/u/Joseph_Mak)\ **Replies:** 2\ **Last updated:** [November 1, 2018, 2:48pm UTC](https://discuss.elastic.co/t/timelion-count-with-a-condition/154925 "2018-11-01T14:48:07Z")
I have a need for doing a timelion count of a certain field (myField)... but only if another field (errorField) is not 0. So I made a scripted field: myFieldIfNoError if (doc\['errorField'\].value != null && doc\['errorFi… --- ## [Visualisation Help](https://discuss.elastic.co/t/visualisation-help/154809)
**Author:** [@dawiro](https://discuss.elastic.co/u/dawiro)\ **Replies:** 2\ **Last updated:** [November 1, 2018, 9:44am UTC](https://discuss.elastic.co/t/visualisation-help/154809 "2018-11-01T09:44:30Z")
Hi, Could someone explain to me how I can visualise bulk rejections in kibana based on x-pack monitoring data please? Bulks rejections are a cumulative total for each node. How I can graph this isn't clear to me. Regar… --- ## [Visualize website usage by users](https://discuss.elastic.co/t/visualize-website-usage-by-users/154754)
**Author:** [@BlueSpirit](https://discuss.elastic.co/u/BlueSpirit)\ **Replies:** 2\ **Last updated:** [November 1, 2018, 6:34am UTC](https://discuss.elastic.co/t/visualize-website-usage-by-users/154754 "2018-11-01T06:34:04Z")
Goal: I want to create a dashboard which shows user requests made to my website. For this, I created a filter in my java web-app and started capturing user requests and storing them in an ES index. The document is in the… --- ## [Integrating SQL database with Kibana](https://discuss.elastic.co/t/integrating-sql-database-with-kibana/154972)
**Author:** [@karan\_gupta](https://discuss.elastic.co/u/karan_gupta)\ **Replies:** 1\ **Last updated:** [November 1, 2018, 7:39am UTC](https://discuss.elastic.co/t/integrating-sql-database-with-kibana/154972 "2018-11-01T07:39:16Z")
Want to connect SQL Database with Kibana. Kindly provide a Stepwise description. I have found this solution, which involves first connecting SQL with Elasticsearch. Any other solution?? --- ## [KIBANA APM dashboard homepage shows APM server running but I have not ran APM server on my machine so how is it detecting that APM server is running](https://discuss.elastic.co/t/kibana-apm-dashboard-homepage-shows-apm-server-running-but-i-have-not-ran-apm-server-on-my-machine-so-how-is-it-detecting-that-apm-server-is-running/154789)
**Author:** [@user\_elastic](https://discuss.elastic.co/u/user_elastic)\ **Replies:** 2\ **Last updated:** [November 1, 2018, 6:23am UTC](https://discuss.elastic.co/t/kibana-apm-dashboard-homepage-shows-apm-server-running-but-i-have-not-ran-apm-server-on-my-machine-so-how-is-it-detecting-that-apm-server-is-running/154789 "2018-11-01T06:23:08Z")
Is this a bug ? --- ## [Access Control](https://discuss.elastic.co/t/access-control/153790)
**Author:** [@MiddlewareTeam](https://discuss.elastic.co/u/MiddlewareTeam)\ **Replies:** 5\ **Last updated:** [November 1, 2018, 6:08am UTC](https://discuss.elastic.co/t/access-control/153790 "2018-11-01T06:08:30Z")
Is it possible to give user based access control to KIBANA dashboard? Like some user is having access to view specific content only and ADMIN is having visibility to all data? Also is is possible to integrate the users… --- ## [How can I change the rows and columns of a table?](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961)
**Author:** [@ksb304](https://discuss.elastic.co/u/ksb304)\ **Replies:** 6\ **Last updated:** [November 1, 2018, 6:00am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961 "2018-11-01T06:00:08Z")
How can I change the rows and columns of a table? --- ## [Kibana line chart issue](https://discuss.elastic.co/t/kibana-line-chart-issue/154602)
**Author:** [@Wayne\_Du](https://discuss.elastic.co/u/Wayne_Du)\ **Replies:** 4\ **Last updated:** [November 1, 2018, 2:29am UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602 "2018-11-01T02:29:02Z")
I create a line chart, and the X-Axis as Data Histogram, the Interval is Monthly, when there is no data in one month, the value will be ignore in the chart, But I want to it's show 0. Is there any way to set the value i… --- ## [Kibana 6.1.4 fieldless search times out when window is several days](https://discuss.elastic.co/t/kibana-6-1-4-fieldless-search-times-out-when-window-is-several-days/154102)
**Author:** [@Todd\_Lyons](https://discuss.elastic.co/u/Todd_Lyons)\ **Replies:** 3\ **Last updated:** [November 1, 2018, 2:08am UTC](https://discuss.elastic.co/t/kibana-6-1-4-fieldless-search-times-out-when-window-is-several-days/154102 "2018-11-01T02:08:07Z")
Hi, I upgraded our nominally working 5.6.4 ELK stack to 6.1.4 (ES, logstash, and Kibana). We did not use xpack before, and we are not yet using xpack on this 6.1.4 upgrade (we have a license, but haven't installed it ye… --- ## [Change Host name on Kibana Dashboard](https://discuss.elastic.co/t/change-host-name-on-kibana-dashboard/154793)
**Author:** [@Shahid\_Chaudhary](https://discuss.elastic.co/u/Shahid_Chaudhary)\ **Replies:** 1\ **Last updated:** [October 31, 2018, 10:09pm UTC](https://discuss.elastic.co/t/change-host-name-on-kibana-dashboard/154793 "2018-10-31T22:09:01Z")
How can i set a name as beat.name:'MyHostName'. I am getting logs from AWS EC2 machine where host name is set my AWS with IP address for example my machine IP is 10.0.3.99 so my host name will be as "ip-10-0-3-99 " whi… --- ## [Kibana Canvas: How to create workpad from a script (bash/python)?](https://discuss.elastic.co/t/kibana-canvas-how-to-create-workpad-from-a-script-bash-python/154837)
**Author:** [@Dhananjaya\_Gupta](https://discuss.elastic.co/u/Dhananjaya_Gupta)\ **Replies:** 1\ **Last updated:** [October 31, 2018, 10:04pm UTC](https://discuss.elastic.co/t/kibana-canvas-how-to-create-workpad-from-a-script-bash-python/154837 "2018-10-31T22:04:18Z")
I have installed Kibana and Kibana Canvas Plugin, but i saw that i can create the workpad, pages and add elements in it by using the UI of kibana canvas. How about if i can write the code and create the workpad via scrip… --- ## [Truncating String in Data Table](https://discuss.elastic.co/t/truncating-string-in-data-table/154876)
**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\ **Replies:** 5\ **Last updated:** [October 31, 2018, 9:38pm UTC](https://discuss.elastic.co/t/truncating-string-in-data-table/154876 "2018-10-31T21:38:30Z")
I have a data table visualization where I am counting the top hits on a list of URLs. All the URLs have http://www.example.com/index. I am counting top hits on the part after /index. Is it possible to truncate the roo… --- ## [Smooth line visualization goes back to "straight" when adding to a Dashboard](https://discuss.elastic.co/t/smooth-line-visualization-goes-back-to-straight-when-adding-to-a-dashboard/154924)
**Author:** [@jayh](https://discuss.elastic.co/u/jayh)\ **Replies:** 1\ **Last updated:** [October 31, 2018, 9:34pm UTC](https://discuss.elastic.co/t/smooth-line-visualization-goes-back-to-straight-when-adding-to-a-dashboard/154924 "2018-10-31T21:34:19Z")
I created a line graph visualization and under Metrics & Axes \> Metric, set the Line Mode to "smooth". A smooth line curve is created and saved. But when I add this visualization to a dashboard, it's added as a Straigh… --- ## [Kibana User tab is not visible on version 6.3.2 (AWS Elasticsearch)](https://discuss.elastic.co/t/kibana-user-tab-is-not-visible-on-version-6-3-2-aws-elasticsearch/154903)
**Author:** [@Enrique\_Rosales](https://discuss.elastic.co/u/Enrique_Rosales)\ **Replies:** 1\ **Last updated:** [October 31, 2018, 8:11pm UTC](https://discuss.elastic.co/t/kibana-user-tab-is-not-visible-on-version-6-3-2-aws-elasticsearch/154903 "2018-10-31T20:11:50Z")
Hi everyone, i'm using Kibana service through the AWS Elasticsearch service endpoint and login in with a Cognito user. My doubt or issue here is that i have to share a dashboard with some users (read only), after some re… --- ## [Kibana does not store saved data](https://discuss.elastic.co/t/kibana-does-not-store-saved-data/154918)
**Author:** [@leandro\_matos\_pereir](https://discuss.elastic.co/u/leandro_matos_pereir)\ **Replies:** 1\ **Last updated:** [October 31, 2018, 8:09pm UTC](https://discuss.elastic.co/t/kibana-does-not-store-saved-data/154918 "2018-10-31T20:09:52Z")
I would like them to help me, I am developing a project in the company to save a considerable amount of log (250 GB), every day I need to recreate the index of the same due to the disk space. Every time I recreate the i… --- ## [Schedule report and move to different server](https://discuss.elastic.co/t/schedule-report-and-move-to-different-server/154430)
**Author:** [@nandha\_88](https://discuss.elastic.co/u/nandha_88)\ **Replies:** 2\ **Last updated:** [October 31, 2018, 5:39pm UTC](https://discuss.elastic.co/t/schedule-report-and-move-to-different-server/154430 "2018-10-31T17:39:08Z")
Hi All, I need to create a report and move to different server. I am able to create the the report . I dont see something to schedule the report and also the possibility to download that report to the same server or … --- ## [Storing and visualising 'attendance' data](https://discuss.elastic.co/t/storing-and-visualising-attendance-data/153158)
**Author:** [@LeeSyd](https://discuss.elastic.co/u/LeeSyd)\ **Replies:** 2\ **Last updated:** [October 31, 2018, 5:14pm UTC](https://discuss.elastic.co/t/storing-and-visualising-attendance-data/153158 "2018-10-31T17:14:29Z")
Hi all, hope somebody can help. I'd like to store and visualise 'attendance' data so I record a timestamp of when people enter/leave a building and can then visualise a count of people currently inside and with the abil… --- ## [Graph visualization - network packet tracing](https://discuss.elastic.co/t/graph-visualization-network-packet-tracing/154165)
**Author:** [@Petr\_Stepan](https://discuss.elastic.co/u/Petr_Stepan)\ **Replies:** 2\ **Last updated:** [October 31, 2018, 4:40pm UTC](https://discuss.elastic.co/t/graph-visualization-network-packet-tracing/154165 "2018-10-31T16:40:11Z")
HI, I'm starting with graph visualization in Kibana and I would like to known if it is possible to visualize following task. I Have a network consisted of 10 servers, for example and one client which receives messages… --- ## [Heat map from vector of ints and count](https://discuss.elastic.co/t/heat-map-from-vector-of-ints-and-count/154717)
**Author:** [@Mike\_CC](https://discuss.elastic.co/u/Mike_CC)\ **Replies:** 4\ **Last updated:** [October 31, 2018, 4:19pm UTC](https://discuss.elastic.co/t/heat-map-from-vector-of-ints-and-count/154717 "2018-10-31T16:19:50Z")
Hi, I have a variable that consists of vector of integers and I would like to plot a heat map with the count of each element, ideally I would like these to be grouped within bins of variable sizes, due to the fact that … --- ## [filters:pinnedByDefault](https://discuss.elastic.co/t/filters-pinnedbydefault/154854)
**Author:** [@jtebbens](https://discuss.elastic.co/u/jtebbens)\ **Replies:** 1\ **Last updated:** [October 31, 2018, 4:07pm UTC](https://discuss.elastic.co/t/filters-pinnedbydefault/154854 "2018-10-31T16:07:05Z")
Hey, Is this setting a per user account level or is it Kibana global? Reason asking is, when I switch this to true would this also affect the other users or only my login? Thanks, Jeroen [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=758) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=760)