# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=654 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 655 --- ## [How to find numbers starting with 80?](https://discuss.elastic.co/t/how-to-find-numbers-starting-with-80/186273)
**Author:** [@Gosforth](https://discuss.elastic.co/u/Gosforth)\ **Replies:** 7\ **Last updated:** [June 20, 2019, 3:23am UTC](https://discuss.elastic.co/t/how-to-find-numbers-starting-with-80/186273 "2019-06-20T03:23:48Z")
Hi, Kibana Discover option. I'd like to display all docs that has filed value (number) starting with 20. Possible to do this? In SQL it would be ...WHERE field1 LIKE '20%' How to do this in Kibana? Regards --- ## [Is it possible to sort data table using header in Canvas (7.1.1)?](https://discuss.elastic.co/t/is-it-possible-to-sort-data-table-using-header-in-canvas-7-1-1/186413)
**Author:** [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\ **Replies:** 2\ **Last updated:** [June 20, 2019, 1:29am UTC](https://discuss.elastic.co/t/is-it-possible-to-sort-data-table-using-header-in-canvas-7-1-1/186413 "2019-06-20T01:29:37Z")
Hello. I understand that you could sort fields in Expression editor using sort function but I think it is bit less user friendly since you have to modify the expression everytime you change the sort field. So, I thou… --- ## [Using data from a json document field in a Visualization](https://discuss.elastic.co/t/using-data-from-a-json-document-field-in-a-visualization/186536)
**Author:** [@relentless](https://discuss.elastic.co/u/relentless)\ **Replies:** 5\ **Last updated:** [June 20, 2019, 1:17am UTC](https://discuss.elastic.co/t/using-data-from-a-json-document-field-in-a-visualization/186536 "2019-06-20T01:17:28Z")
Hi Guys I have a log which produces a field called relatedData. This field contains a small json document. e.g "relatedData": "{"method":"Put","StartDateTime":"2019-06-20T07:57:08.9337817+12:00","EndDateTime":"2019-06… --- ## [How to get/use indexPatternService in server side api in kibana plugin](https://discuss.elastic.co/t/how-to-get-use-indexpatternservice-in-server-side-api-in-kibana-plugin/186531)
**Author:** [@Riddhesh](https://discuss.elastic.co/u/Riddhesh)\ **Replies:** 4\ **Last updated:** [June 19, 2019, 11:16pm UTC](https://discuss.elastic.co/t/how-to-get-use-indexpatternservice-in-server-side-api-in-kibana-plugin/186531 "2019-06-19T23:16:10Z")
I want to use indexPatternService on server api side of plugin, e.g. to get fields for a pattern(/api/index\_patterns/\_fields\_for\_wildcard). I know in server there is indexPatternsServiceFactory, but I don't know how to … --- ## [Hiding legend label when no data](https://discuss.elastic.co/t/hiding-legend-label-when-no-data/186541)
**Author:** [@littlexsparkee](https://discuss.elastic.co/u/littlexsparkee)\ **Replies:** 3\ **Last updated:** [June 19, 2019, 10:18pm UTC](https://discuss.elastic.co/t/hiding-legend-label-when-no-data/186541 "2019-06-19T22:18:47Z")
I tried using {"min\_doc\_count":1} in the JSON input section to hide labels for a bar chart but when I pressed save, I got an Internal Service Error message. Ideally what should happen is the legend labels disappear … --- ## [How to get unique count before and after split rows on the same table](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535)
**Author:** [@leeyu](https://discuss.elastic.co/u/leeyu)\ **Replies:** 2\ **Last updated:** [June 19, 2019, 10:15pm UTC](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535 "2019-06-19T22:15:06Z")
Hi all, I am working with some data contain the record of user\_id and event\_id. I want to get the percentage of the unique user encounter each event. i.e. (unique user encount event 1) / (unique user) . I know I can… --- ## [How to plot, default last 30 days data in canvas?](https://discuss.elastic.co/t/how-to-plot-default-last-30-days-data-in-canvas/186196)
**Author:** [@Malini\_Sahoo](https://discuss.elastic.co/u/Malini_Sahoo)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 9:37pm UTC](https://discuss.elastic.co/t/how-to-plot-default-last-30-days-data-in-canvas/186196 "2019-06-19T21:37:21Z")
How to plot, default last 30 days data in canvas without using time filter? --- ## [Order data based on timestamp](https://discuss.elastic.co/t/order-data-based-on-timestamp/186526)
**Author:** [@alejandrox1](https://discuss.elastic.co/u/alejandrox1)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 9:17pm UTC](https://discuss.elastic.co/t/order-data-based-on-timestamp/186526 "2019-06-19T21:17:15Z")
Hi everyone, So i'm brand new to the world of Kibana and its nomenclature. I've been floating through the internet for a while to try to look for a solution to my problems and haven't found much of use. I'm hoping peop… --- ## [Wait on dashboard filters to load for hack plugin in Kibana 6.8](https://discuss.elastic.co/t/wait-on-dashboard-filters-to-load-for-hack-plugin-in-kibana-6-8/186502)
**Author:** [@srbdev](https://discuss.elastic.co/u/srbdev)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 9:03pm UTC](https://discuss.elastic.co/t/wait-on-dashboard-filters-to-load-for-hack-plugin-in-kibana-6-8/186502 "2019-06-19T21:03:25Z")
I'm using a hack-type plugin to run some DOM manipulations on a dashboard's filters to add additional functionality. I have it setup the following way: uiModules .get('kibana') .run(Private =\> { const fi… --- ## [Service Worker React Plugin](https://discuss.elastic.co/t/service-worker-react-plugin/186482)
**Author:** [@dkelsen](https://discuss.elastic.co/u/dkelsen)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 8:41pm UTC](https://discuss.elastic.co/t/service-worker-react-plugin/186482 "2019-06-19T20:41:50Z")
Hi, I was wondering whether it's possible to use a service worker in the ReactJS Kibana plugin? The following command is failing navigator.serviceWorker.register("serviceWorker.js") and I'm assuming the reason is bec… --- ## [ElasticSQL math operation](https://discuss.elastic.co/t/elasticsql-math-operation/184680)
**Author:** [@Woolis\_Xiibil\_Peek](https://discuss.elastic.co/u/Woolis_Xiibil_Peek)\ **Replies:** 6\ **Last updated:** [June 19, 2019, 8:17pm UTC](https://discuss.elastic.co/t/elasticsql-math-operation/184680 "2019-06-19T20:17:41Z")
Hi. I need to substract two queries. I have try this SELECT SUM ((SELECT COUNT () AS "op\_totals" FROM "app20-" WHERE "path" = '/ops/login') - (SELECT COUNT () AS "op\_succ" FROM "app20-" WHERE "operacion" = 79)) AS "op\_… --- ## [Refresh field list button in Kibana](https://discuss.elastic.co/t/refresh-field-list-button-in-kibana/186191)
**Author:** [@vasek](https://discuss.elastic.co/u/vasek)\ **Replies:** 2\ **Last updated:** [June 19, 2019, 6:58pm UTC](https://discuss.elastic.co/t/refresh-field-list-button-in-kibana/186191 "2019-06-19T18:58:33Z")
Hi Elasticians, Is it possible perform refresh of field list (In section Management - Index Pattern) from command line, e.g.: using Curl and Kibana API? Vasek --- ## [One Kibana integrated with multiple Elasticsearch](https://discuss.elastic.co/t/one-kibana-integrated-with-multiple-elasticsearch/186442)
**Author:** [@vageesh](https://discuss.elastic.co/u/vageesh)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 6:04pm UTC](https://discuss.elastic.co/t/one-kibana-integrated-with-multiple-elasticsearch/186442 "2019-06-19T18:04:29Z")
Hi, Pardon me I am new to the ELK stack. So, a basic question: In a scenario where I have 2 AWS instances running Elasticsearch(both of them in different regions, e. g., Oregon and Mumbai) and Kibana running in a diffe… --- ## [Search indices with conflict](https://discuss.elastic.co/t/search-indices-with-conflict/186278)
**Author:** [@Georgk](https://discuss.elastic.co/u/Georgk)\ **Replies:** 3\ **Last updated:** [June 19, 2019, 4:05pm UTC](https://discuss.elastic.co/t/search-indices-with-conflict/186278 "2019-06-19T16:05:00Z")
I have conflicts with some indices and I would like to know what those indice are to be able to re-index --- ## [Kibana Crashes Periodically](https://discuss.elastic.co/t/kibana-crashes-periodically/186497)
**Author:** [@jleezer](https://discuss.elastic.co/u/jleezer)\ **Replies:** 8\ **Last updated:** [June 19, 2019, 3:31pm UTC](https://discuss.elastic.co/t/kibana-crashes-periodically/186497 "2019-06-19T15:31:01Z")
Hello, I'm seeing an issue where Kibana periodically crashes. OS: CentOS Linux release 7.6 Kibana/ES Version: 6.6.2, Base Version Checking in the logs it appears that Kibana might be restarting itself periodically at… --- ## [Is it possible to give a title to visualisation in Kibana](https://discuss.elastic.co/t/is-it-possible-to-give-a-title-to-visualisation-in-kibana/186423)
**Author:** [@kumar4](https://discuss.elastic.co/u/kumar4)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 3:30pm UTC](https://discuss.elastic.co/t/is-it-possible-to-give-a-title-to-visualisation-in-kibana/186423 "2019-06-19T15:30:16Z")
hi,is it possible to give a title to visualisation in Kibana, i mean that i want to have a title on the top or in the bottom of the shart thank you --- ## [How to Set constant Background/Legend color in Kibana Metric](https://discuss.elastic.co/t/how-to-set-constant-background-legend-color-in-kibana-metric/186419)
**Author:** [@vinay.rao](https://discuss.elastic.co/u/vinay.rao)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 3:28pm UTC](https://discuss.elastic.co/t/how-to-set-constant-background-legend-color-in-kibana-metric/186419 "2019-06-19T15:28:48Z")
Hi All, I need to set a constant Background/Legend color in Kibana Metric. As of now we need to set the Range and accordingly color is getting changed. In my Case i dont have Ranges. Since to Set some color, forcefully… --- ## [Kibana not connecting](https://discuss.elastic.co/t/kibana-not-connecting/186490)
**Author:** [@durrellgray](https://discuss.elastic.co/u/durrellgray)\ **Replies:** 11\ **Last updated:** [June 19, 2019, 3:19pm UTC](https://discuss.elastic.co/t/kibana-not-connecting/186490 "2019-06-19T15:19:21Z")
Hello, I am extremely new to elasticsearch and Kibana. I have been able to get my elasticsearch instance running, but my Kibana will not connect. \[root@elasticsearch01 log\]# curl -GET http://x.x.182.5:9200 { "name" :… --- ## [Using geoserver as the offline map in kibana7.1.1 is not loaded](https://discuss.elastic.co/t/using-geoserver-as-the-offline-map-in-kibana7-1-1-is-not-loaded/186397)
**Author:** [@shenshensinian](https://discuss.elastic.co/u/shenshensinian)\ **Replies:** 1\ **Last updated:** [June 19, 2019, 3:14pm UTC](https://discuss.elastic.co/t/using-geoserver-as-the-offline-map-in-kibana7-1-1-is-not-loaded/186397 "2019-06-19T15:14:22Z")
Using geoserver as the offline map in kibana7.0 is not loaded How can I solve it? Using WMS Offline map is GEOSERVER --- ## [Aggregate by Concatenate](https://discuss.elastic.co/t/aggregate-by-concatenate/186123)
**Author:** [@tinyweasel](https://discuss.elastic.co/u/tinyweasel)\ **Replies:** 2\ **Last updated:** [June 19, 2019, 2:46pm UTC](https://discuss.elastic.co/t/aggregate-by-concatenate/186123 "2019-06-19T14:46:00Z")
I was trying to find the most recent value in a metric using this previous forum post but I cannot seem to find a way to do Aggregate by Concatenate. Is it possible I have an older version of Kibana, or has Concatenate b… --- ## [Kibana SAML Session TimeOut](https://discuss.elastic.co/t/kibana-saml-session-timeout/186297)
**Author:** [@SRE1](https://discuss.elastic.co/u/SRE1)\ **Replies:** 2\ **Last updated:** [June 19, 2019, 1:17pm UTC](https://discuss.elastic.co/t/kibana-saml-session-timeout/186297 "2019-06-19T13:17:25Z")
I have SAML configured between a hosted Kibana cluster, ElasticSearch Cloud, and AzureAD. Authentication works perfect but, if a user has a dashboard open and set to auto-refresh, they are logged out after 20 minutes. I… --- ## [Kibana fails to create metricbeat index pattern](https://discuss.elastic.co/t/kibana-fails-to-create-metricbeat-index-pattern/186156)
**Author:** [@alexz00](https://discuss.elastic.co/u/alexz00)\ **Replies:** 3\ **Last updated:** [June 19, 2019, 12:51pm UTC](https://discuss.elastic.co/t/kibana-fails-to-create-metricbeat-index-pattern/186156 "2019-06-19T12:51:24Z")
I tried to create a metricbeat-\* index pattern directly from Kibana, but it fails with the following error: Error: Request Timeout at http://10.99.21.222:15601/bundles/commons.bundle.js:1:315503 at step (http://10.99.21… --- ## [Can We Filter Data at the Chart-level by Column in Visual Mode?](https://discuss.elastic.co/t/can-we-filter-data-at-the-chart-level-by-column-in-visual-mode/185606)
**Author:** [@Zany](https://discuss.elastic.co/u/Zany)\ **Replies:** 4\ **Last updated:** [June 18, 2019, 3:42am UTC](https://discuss.elastic.co/t/can-we-filter-data-at-the-chart-level-by-column-in-visual-mode/185606 "2019-06-18T03:42:43Z")
In the Discovery Mode, I know that we can create a query (e.g. type: http) to filter out data before building visualizations. However, I do not want to do that. I need the unfiltered data. I want to create a Data Table … --- ## [Pareto Chart](https://discuss.elastic.co/t/pareto-chart/185986)
**Author:** [@June](https://discuss.elastic.co/u/June)\ **Replies:** 5\ **Last updated:** [June 19, 2019, 4:50am UTC](https://discuss.elastic.co/t/pareto-chart/185986 "2019-06-19T04:50:16Z")
Greetings! Is there any possibility to create pareto chart in Kibana (v.6.5.1)? Thank you. --- ## [How to update kibana by keeping the visualization data intact?](https://discuss.elastic.co/t/how-to-update-kibana-by-keeping-the-visualization-data-intact/186049)
**Author:** [@Sujata\_Yadav](https://discuss.elastic.co/u/Sujata_Yadav)\ **Replies:** 1\ **Last updated:** [June 18, 2019, 10:21pm UTC](https://discuss.elastic.co/t/how-to-update-kibana-by-keeping-the-visualization-data-intact/186049 "2019-06-18T22:21:00Z")
Hi, How to update kibana to the latest version by keeping the visualization data intact? I have tried rollup upgrade and observed that even though my index data is intact, the visualizations are missing. I have to re-wo… --- ## [Vega-lite - my time axis is not connected correctly to the time changing button on Kibana](https://discuss.elastic.co/t/vega-lite-my-time-axis-is-not-connected-correctly-to-the-time-changing-button-on-kibana/185887)
**Author:** [@jackb7890](https://discuss.elastic.co/u/jackb7890)\ **Replies:** 1\ **Last updated:** [June 18, 2019, 10:18pm UTC](https://discuss.elastic.co/t/vega-lite-my-time-axis-is-not-connected-correctly-to-the-time-changing-button-on-kibana/185887 "2019-06-18T22:18:47Z")
I don't know if this is a bug with Kibana or if my code caused this or if I am misinterpreting something. My issue is that whenever I try to manipulate my time axis to stretch beyond an hour using the buttons on Kibana, … --- ## [Embed Kibana in webapp](https://discuss.elastic.co/t/embed-kibana-in-webapp/186108)
**Author:** [@joao.nzuzi](https://discuss.elastic.co/u/joao.nzuzi)\ **Replies:** 1\ **Last updated:** [June 18, 2019, 10:07pm UTC](https://discuss.elastic.co/t/embed-kibana-in-webapp/186108 "2019-06-18T22:07:44Z")
I'm looking for a way to embed kibana or kibana dashbord in my web application. Can someone help me? --- ## [Bar chart / time steps](https://discuss.elastic.co/t/bar-chart-time-steps/185817)
**Author:** [@wadhah](https://discuss.elastic.co/u/wadhah)\ **Replies:** 1\ **Last updated:** [June 18, 2019, 8:37pm UTC](https://discuss.elastic.co/t/bar-chart-time-steps/185817 "2019-06-18T20:37:50Z")
Hello, I am working on a kibana canvas dashboard and i am using a bar chart to display weekly costs. On X-axis : time ...... I was wondering if it's possible to change time steps : the data is shown correctly, but in t… --- ## [Unable to view the newly added fields in Visualization](https://discuss.elastic.co/t/unable-to-view-the-newly-added-fields-in-visualization/185908)
**Author:** [@ashokchinna](https://discuss.elastic.co/u/ashokchinna)\ **Replies:** 1\ **Last updated:** [June 18, 2019, 8:30pm UTC](https://discuss.elastic.co/t/unable-to-view-the-newly-added-fields-in-visualization/185908 "2019-06-18T20:30:19Z")
I fetched the data from the database using logstash. Further I added a new field in the filter . add\_field =\> { "failure\_reason\_new" =\> "%{failure\_reason}"} } However, I am unable to view the newly added field "failu… --- ## [Weighted Average in a DataTable of Kibana](https://discuss.elastic.co/t/weighted-average-in-a-datatable-of-kibana/185909)
**Author:** [@Henrique\_Santiago](https://discuss.elastic.co/u/Henrique_Santiago)\ **Replies:** 2\ **Last updated:** [June 18, 2019, 7:18pm UTC](https://discuss.elastic.co/t/weighted-average-in-a-datatable-of-kibana/185909 "2019-06-18T19:18:20Z")
I have this index: PUT sales { "settings": { "index": { "number\_of\_shards": 3, "number\_of\_replicas": 0 } }, "mappings": { "properties": { "@timestamp": { "type": "date" … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=653) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=655)