# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=641 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 642 --- ## [Y axis using unformatted data](https://discuss.elastic.co/t/y-axis-using-unformatted-data/189357)
**Author:** [@Michiele\_Ogbagabir](https://discuss.elastic.co/u/Michiele_Ogbagabir)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:48am UTC](https://discuss.elastic.co/t/y-axis-using-unformatted-data/189357 "2019-07-12T09:48:01Z")
I have duration data that comes in as seconds. I modified the duration field to convert it to hours as follows. This works well and I am able to see the data in hours in the Discover tab. When I try to visualize this … --- ## [Multiple CSS class in visualisation builder markdown](https://discuss.elastic.co/t/multiple-css-class-in-visualisation-builder-markdown/189165)
**Author:** [@pisxx](https://discuss.elastic.co/u/pisxx)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:46am UTC](https://discuss.elastic.co/t/multiple-css-class-in-visualisation-builder-markdown/189165 "2019-07-12T09:46:02Z")
Hi, I wanted to setup visualisation with multiple metric each with other color and if possible do some logic on them, like if metric \< 0, use different CSS class. So far I was able to do it using something like that h… --- ## [Kibana - Import/Export saved objects in V5.3](https://discuss.elastic.co/t/kibana-import-export-saved-objects-in-v5-3/188921)
**Author:** [@mrling](https://discuss.elastic.co/u/mrling)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:43am UTC](https://discuss.elastic.co/t/kibana-import-export-saved-objects-in-v5-3/188921 "2019-07-12T09:43:15Z")
We are using ES, and are on kibana v5.3. Is there a way to import/export saved objects, eg: queries, visualisations/dashboard via a API, rather then the UI itself? --- ## [Kibana visualizations & dashboards lost on upgrade from 6.6.1 to 7.0.1](https://discuss.elastic.co/t/kibana-visualizations-dashboards-lost-on-upgrade-from-6-6-1-to-7-0-1/188899)
**Author:** [@shivani\_aggarwal](https://discuss.elastic.co/u/shivani_aggarwal)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:41am UTC](https://discuss.elastic.co/t/kibana-visualizations-dashboards-lost-on-upgrade-from-6-6-1-to-7-0-1/188899 "2019-07-12T09:41:53Z")
I had deployed kibana-6.6.1-oss and created some visualizations, index patterns and dashboards in kibana. My .kibana\_1 was created as shown below: I upgraded my ELK cluster to 7.0.1 (oss). All my data is retained bu… --- ## [Data table has exclamation triangle icon](https://discuss.elastic.co/t/data-table-has-exclamation-triangle-icon/189927)
**Author:** [@yidaqiang](https://discuss.elastic.co/u/yidaqiang)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:37am UTC](https://discuss.elastic.co/t/data-table-has-exclamation-triangle-icon/189927 "2019-07-12T09:37:49Z")
when i user kibana to veiw data table, it has exclamation triangle icon.like this: What does it mean? --- ## [Can't connect kibana to elasticsearch though https](https://discuss.elastic.co/t/cant-connect-kibana-to-elasticsearch-though-https/189875)
**Author:** [@hjsjar](https://discuss.elastic.co/u/hjsjar)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:34am UTC](https://discuss.elastic.co/t/cant-connect-kibana-to-elasticsearch-though-https/189875 "2019-07-12T09:34:40Z")
I have an elasticsearch cluster running on aws, ive enabled transport ssl to encrypt internode communications and the cluster is behind a load balancer that enforces ssl for external communications I'm trying to run a l… --- ## [Transform boolean values from True / False to 1/0](https://discuss.elastic.co/t/transform-boolean-values-from-true-false-to-1-0/189936)
**Author:** [@MARCO\_RAMBALDI](https://discuss.elastic.co/u/MARCO_RAMBALDI)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 9:25am UTC](https://discuss.elastic.co/t/transform-boolean-values-from-true-false-to-1-0/189936 "2019-07-12T09:25:56Z")
I have IoT alarms in Boolean format: True / False. But I would like to show the trend of these alarms over time. How can I do it? Is it possible to turn True / False into 1/0 on Kibana? In this way it would be more conv… --- ## [Reusing of kibana dashboard for new indices with same old index name](https://discuss.elastic.co/t/reusing-of-kibana-dashboard-for-new-indices-with-same-old-index-name/189536)
**Author:** [@amarpal](https://discuss.elastic.co/u/amarpal)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 9:19am UTC](https://discuss.elastic.co/t/reusing-of-kibana-dashboard-for-new-indices-with-same-old-index-name/189536 "2019-07-12T09:19:10Z")
Hi, How can we reuse .kibana index or dashboards after deleting the data. --- ## [Table with color filter](https://discuss.elastic.co/t/table-with-color-filter/186718)
**Author:** [@optimistic](https://discuss.elastic.co/u/optimistic)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 7:24am UTC](https://discuss.elastic.co/t/table-with-color-filter/186718 "2019-07-12T07:24:22Z")
I have such logic of logs aggregation. My first service send events id: 'user-refresh-test', id: 117 Than other service send: 'user-refresh-test', id: 117, serviceN1: 1 It means than serviceN1 did some job and s… --- ## [Integrating kibana dashboard into react App](https://discuss.elastic.co/t/integrating-kibana-dashboard-into-react-app/187884)
**Author:** [@Vishal\_Kumar2](https://discuss.elastic.co/u/Vishal_Kumar2)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 5:51pm UTC](https://discuss.elastic.co/t/integrating-kibana-dashboard-into-react-app/187884 "2019-07-11T17:51:40Z")
Hi Team, I have a requirement on integrating kibana dashboard into my react application. The dashboard may contains multiple charts(Pie,Time series etc). And, the application will be used by many users .So, the data in … --- ## [How to add scripted field to my custom endpoint?](https://discuss.elastic.co/t/how-to-add-scripted-field-to-my-custom-endpoint/186215)
**Author:** [@masterThomas](https://discuss.elastic.co/u/masterThomas)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 5:48pm UTC](https://discuss.elastic.co/t/how-to-add-scripted-field-to-my-custom-endpoint/186215 "2019-07-11T17:48:38Z")
hi team, my code is like : server.route({ path: '/api/combineindexes', method: 'GET', handler(req, h) { const qqq = { index: "\*index1,\*index2", q: "rule\_id:\*", script\_fields: { "my\_field" : { "scr… --- ## [Unable to build Kibana 6.7 source code](https://discuss.elastic.co/t/unable-to-build-kibana-6-7-source-code/186941)
**Author:** [@adityaPsl](https://discuss.elastic.co/u/adityaPsl)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 4:35pm UTC](https://discuss.elastic.co/t/unable-to-build-kibana-6-7-source-code/186941 "2019-07-11T16:35:35Z")
Hello Team, I am trying to build kibana 6.7 source code. however i am getting 'self signed certificate in certificate chain' error when it tries to get geckodriver. OS: Windows 10 Kibana : 6.7 Node: 10.15.2 Yarn :… --- ## [Aggregations don't work in Kibana after Elastic stack upgrade to 7.2](https://discuss.elastic.co/t/aggregations-dont-work-in-kibana-after-elastic-stack-upgrade-to-7-2/189825)
**Author:** [@Martin\_O](https://discuss.elastic.co/u/Martin_O)\ **Replies:** 3\ **Last updated:** [July 11, 2019, 3:47pm UTC](https://discuss.elastic.co/t/aggregations-dont-work-in-kibana-after-elastic-stack-upgrade-to-7-2/189825 "2019-07-11T15:47:46Z")
Aggregations don't work in Kibana after Elastic stack upgrade to 7.2 from 6.8 version. I use it to visualize logs from postfix , these are shipped ok and I can see the records in ' Discover' just OK. But when I try to vi… --- ## [Kibana service start failed](https://discuss.elastic.co/t/kibana-service-start-failed/189460)
**Author:** [@wenchaodu](https://discuss.elastic.co/u/wenchaodu)\ **Replies:** 8\ **Last updated:** [July 11, 2019, 3:31pm UTC](https://discuss.elastic.co/t/kibana-service-start-failed/189460 "2019-07-11T15:31:00Z")
I install Elasticsearch & Kibana 7.2.0, elasticsearch is working with basic license and enable xpack.security, and I create build-in accounts, all of them working with elasticsearch. But when I start kibana, unfortunate… --- ## [Painless validation returning null giving exception](https://discuss.elastic.co/t/painless-validation-returning-null-giving-exception/189861)
**Author:** [@BrunoSdeMenezes](https://discuss.elastic.co/u/BrunoSdeMenezes)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 1:19pm UTC](https://discuss.elastic.co/t/painless-validation-returning-null-giving-exception/189861 "2019-07-11T13:19:01Z")
Hello everyone, I'm building a painless script for a scripted field, but when I do a check for null using size() (the validation method recommended for Kibana 7.1.0), I'm getting exception error: Request to Elasticsear… --- ## [Using a Discover Saved Search in a Dashboard does not show properly](https://discuss.elastic.co/t/using-a-discover-saved-search-in-a-dashboard-does-not-show-properly/189747)
**Author:** [@davidnavalho](https://discuss.elastic.co/u/davidnavalho)\ **Replies:** 4\ **Last updated:** [July 11, 2019, 12:51pm UTC](https://discuss.elastic.co/t/using-a-discover-saved-search-in-a-dashboard-does-not-show-properly/189747 "2019-07-11T12:51:59Z")
We're adding a simple Saved Search from Discover into a Dashboard, but it does not seem to present data in the same manner it is presented in the actual Discover tab. Specifically, the un-expanded entries seem to be show… --- ## [How to GET an Entity from nested JSON Data using Query](https://discuss.elastic.co/t/how-to-get-an-entity-from-nested-json-data-using-query/189818)
**Author:** [@samyo](https://discuss.elastic.co/u/samyo)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 8:17am UTC](https://discuss.elastic.co/t/how-to-get-an-entity-from-nested-json-data-using-query/189818 "2019-07-11T08:17:51Z")
Hello folks , i have this bellow JSON Data, and i want to write a Query , the Query is , ( Give me all Entities where the "ai\_id" has the Value = 0 ). the JSON Data , { "\_index": "try1", "\_type… --- ## [Kibana 7.1.1 checkbox enable, disable filter values](https://discuss.elastic.co/t/kibana-7-1-1-checkbox-enable-disable-filter-values/189729)
**Author:** [@David\_Ignjic](https://discuss.elastic.co/u/David_Ignjic)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 8:13am UTC](https://discuss.elastic.co/t/kibana-7-1-1-checkbox-enable-disable-filter-values/189729 "2019-07-11T08:13:00Z")
Hi everyone, I was upgrading to kibana 7.1.1. ! thing which form my point of usubility to enable and disable filter i need to click on filter and disable it or reenable it. In previous version was checkbos so I can do i… --- ## [Regex queries don't work in Kibana](https://discuss.elastic.co/t/regex-queries-dont-work-in-kibana/189723)
**Author:** [@kechem](https://discuss.elastic.co/u/kechem)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 7:40am UTC](https://discuss.elastic.co/t/regex-queries-dont-work-in-kibana/189723 "2019-07-11T07:40:25Z")
I have tried several combinations but cannot get regex queries to match the desired search string(s). Sample extract: \[market-feed-render-4\]\[user=xx.Xxxxx.Xxxx\] \[OUT\] {"payload":{"id":"1562500842791.7273668","timestamp… --- ## [Need to decrease Kibana loading time](https://discuss.elastic.co/t/need-to-decrease-kibana-loading-time/189675)
**Author:** [@Atul\_Soni](https://discuss.elastic.co/u/Atul_Soni)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 6:20am UTC](https://discuss.elastic.co/t/need-to-decrease-kibana-loading-time/189675 "2019-07-11T06:20:34Z")
Hi, I am new to ELK and I could not find how I can decrease the kibana loading time, when I load it the first time then vendors.bundle.dll.js files takes almost 1 min to load, its size is 32MB and when I open discover p… --- ## [Browserslist: caniuse-lite is outdated. Please run next command \`npm update caniuse-lite browserslist](https://discuss.elastic.co/t/browserslist-caniuse-lite-is-outdated-please-run-next-command-npm-update-caniuse-lite-browserslist/189216)
**Author:** [@mhsh64](https://discuss.elastic.co/u/mhsh64)\ **Replies:** 21\ **Last updated:** [July 11, 2019, 12:31am UTC](https://discuss.elastic.co/t/browserslist-caniuse-lite-is-outdated-please-run-next-command-npm-update-caniuse-lite-browserslist/189216 "2019-07-11T00:31:56Z")
Hi all, Is the following a bug? Jul 06 10:38:46 vm1.local.com systemd\[1\]: Started Kibana. Jul 06 10:40:42 vm1.local.com kibana\[5454\]: {"type":"log","@timestamp":"2019-07-06T14:40:42Z","tags":\["info","optimize"\],"pid":5… --- ## [Accuracy of Cardinality aggregations within Visual Builder?](https://discuss.elastic.co/t/accuracy-of-cardinality-aggregations-within-visual-builder/189857)
**Author:** [@Andres\_Valencia\_US](https://discuss.elastic.co/u/Andres_Valencia_US)\ **Replies:** 2\ **Last updated:** [July 10, 2019, 10:16pm UTC](https://discuss.elastic.co/t/accuracy-of-cardinality-aggregations-within-visual-builder/189857 "2019-07-10T22:16:16Z")
In older metrics, I was able to add precision\_threshold into the advanced-\>JSON input field However, I can't find a similar field for Visual builder aggregations. Is there any way to specify this? --- ## [How to use json input in my case?](https://discuss.elastic.co/t/how-to-use-json-input-in-my-case/189528)
**Author:** [@Jerry1989](https://discuss.elastic.co/u/Jerry1989)\ **Replies:** 1\ **Last updated:** [July 10, 2019, 9:14pm UTC](https://discuss.elastic.co/t/how-to-use-json-input-in-my-case/189528 "2019-07-10T21:14:55Z")
My kibana version is 5.5 I have splited the slice by specific field, below is the result I got. But I want all sets "/queries/xxxx" to be merged to new category like "get query", and rename the "/queries" to "post quer… --- ## [Filterrows, date column by comparing gte "now-24h"](https://discuss.elastic.co/t/filterrows-date-column-by-comparing-gte-now-24h/189753)
**Author:** [@Vartika\_Srivastava](https://discuss.elastic.co/u/Vartika_Srivastava)\ **Replies:** 1\ **Last updated:** [July 10, 2019, 9:11pm UTC](https://discuss.elastic.co/t/filterrows-date-column-by-comparing-gte-now-24h/189753 "2019-07-10T21:11:01Z")
Hi , how can we filterrows, date column by comparing gte "now-24h" , instead of "timefilter column="time" from="now-24h" to="now" eg. | filterrows fn={ getCell "time"| gte "now-24h"} is not working --- ## [How to make the Y axis show state rather than value](https://discuss.elastic.co/t/how-to-make-the-y-axis-show-state-rather-than-value/189718)
**Author:** [@yess](https://discuss.elastic.co/u/yess)\ **Replies:** 1\ **Last updated:** [July 10, 2019, 9:05pm UTC](https://discuss.elastic.co/t/how-to-make-the-y-axis-show-state-rather-than-value/189718 "2019-07-10T21:05:36Z")
Is there any way for me to use a timeline to show the mains state (either 0 or 1) for a particular gateway over time (i.e. the y-axis will show the state instead of the count) --- ## [Need Help to show the data if count is greater than some value](https://discuss.elastic.co/t/need-help-to-show-the-data-if-count-is-greater-than-some-value/189671)
**Author:** [@yuva\_rajan](https://discuss.elastic.co/u/yuva_rajan)\ **Replies:** 1\ **Last updated:** [July 10, 2019, 8:33pm UTC](https://discuss.elastic.co/t/need-help-to-show-the-data-if-count-is-greater-than-some-value/189671 "2019-07-10T20:33:46Z")
Hi, I would like to show the data in table panel only if the count \> x . is it possible to set the condition in table panel ? --- ## [Enable email Automatic alerts](https://discuss.elastic.co/t/enable-email-automatic-alerts/189656)
**Author:** [@moti.mor](https://discuss.elastic.co/u/moti.mor)\ **Replies:** 1\ **Last updated:** [July 10, 2019, 8:32pm UTC](https://discuss.elastic.co/t/enable-email-automatic-alerts/189656 "2019-07-10T20:32:47Z")
Hi guys, How can i i enable email automatic alerts in my open source kibana? in share section i have only CSV / LINKS ... Please guide me what should i do? --- ## [Upgrade kibana from 5.1.2 to 5.6.15](https://discuss.elastic.co/t/upgrade-kibana-from-5-1-2-to-5-6-15/189866)
**Author:** [@sandipatmca](https://discuss.elastic.co/u/sandipatmca)\ **Replies:** 1\ **Last updated:** [July 10, 2019, 8:15pm UTC](https://discuss.elastic.co/t/upgrade-kibana-from-5-1-2-to-5-6-15/189866 "2019-07-10T20:15:17Z")
We are using 5.1.2 version of Elastic/Kibana/Logstash & xpack & 0.4.0-1 version of logstash-forwarder. We are planning to upgrade Kibana from 5.1.2 to 5.6.15(due to some security issues).Can someone please suggest if … --- ## [Dropdown filter kibana canvas](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082)
**Author:** [@wadhah](https://discuss.elastic.co/u/wadhah)\ **Replies:** 15\ **Last updated:** [July 10, 2019, 7:14pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082 "2019-07-10T19:14:21Z")
Helo, I have a question please : I am at the moment working on a canvas dashboard and I am using a dropdown column that I want it to be applied properly on the whole canvas dashboard knowing that I am querying data from… --- ## [A problem when applying a filter to heat maps](https://discuss.elastic.co/t/a-problem-when-applying-a-filter-to-heat-maps/189762)
**Author:** [@M.alsioufi](https://discuss.elastic.co/u/M.alsioufi)\ **Replies:** 2\ **Last updated:** [July 10, 2019, 7:10pm UTC](https://discuss.elastic.co/t/a-problem-when-applying-a-filter-to-heat-maps/189762 "2019-07-10T19:10:10Z")
I have a field of type date and default format insertion\_time I wanted to create a heat map visualization in Kibana 6.5 where I can have and the day\_of\_month on x-Axis, the hour of the day on y-Axis and the color re… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=640) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=642)