# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=626 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 627 --- ## [Calculate the difference of two entries](https://discuss.elastic.co/t/calculate-the-difference-of-two-entries/193840)
**Author:** [@bruecp](https://discuss.elastic.co/u/bruecp)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 5:40am UTC](https://discuss.elastic.co/t/calculate-the-difference-of-two-entries/193840 "2019-08-06T05:40:11Z")
Hi, for each user we log a message to Elastic when an application starts and stops. With one application we have currently troubles, as at some users, the application crashes. Therefore, I need a simple way to subtrac… --- ## [Scripted fields and nested](https://discuss.elastic.co/t/scripted-fields-and-nested/193587)
**Author:** [@popopo](https://discuss.elastic.co/u/popopo)\ **Replies:** 4\ **Last updated:** [August 6, 2019, 5:34am UTC](https://discuss.elastic.co/t/scripted-fields-and-nested/193587 "2019-08-06T05:34:35Z")
Hi everyone, I'm having trouble using scripted fields in Kibana... Here's my mapping: { "mappings": { "\_doc": { "properties": { "modules": { "type": "nested", "properties": { … --- ## [Pert CPM Chart in Kibana](https://discuss.elastic.co/t/pert-cpm-chart-in-kibana/193766)
**Author:** [@suhasgupta](https://discuss.elastic.co/u/suhasgupta)\ **Replies:** 2\ **Last updated:** [August 6, 2019, 3:50am UTC](https://discuss.elastic.co/t/pert-cpm-chart-in-kibana/193766 "2019-08-06T03:50:33Z")
Hi All, Can we create a Pert CPM chart in kibana to show sequence of events. Kindly help. Any leads will be appreciated. Thanks & Regards Suhas Gupta --- ## [Blank dashboards after setup](https://discuss.elastic.co/t/blank-dashboards-after-setup/193721)
**Author:** [@Buh-Lock-ay](https://discuss.elastic.co/u/Buh-Lock-ay)\ **Replies:** 6\ **Last updated:** [August 6, 2019, 1:57am UTC](https://discuss.elastic.co/t/blank-dashboards-after-setup/193721 "2019-08-06T01:57:24Z")
Hey there, I'm new to the Elastic stack and trying to build a POC in my lab. I've got the foundation created of being 3 Elastic nodes (1 master and 2 ingest) and a Kibana node. I've installed filebeat, metricbeat, and … --- ## [VEGA visual](https://discuss.elastic.co/t/vega-visual/193895)
**Author:** [@aaditya\_alekar](https://discuss.elastic.co/u/aaditya_alekar)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 11:32pm UTC](https://discuss.elastic.co/t/vega-visual/193895 "2019-08-05T23:32:20Z")
{ $schema: https://vega.github.io/schema/vega/v3.0.json config: { kibana: { type: "map" latitude: 37.0902 longitude: 95.7129 zoom: 4 } } data: \[ { "name": "cities", "values": \[ {"city": "Boston", "lon": 42.… --- ## [The problem of using iframe when developing a Kibana plugin that loads remote website](https://discuss.elastic.co/t/the-problem-of-using-iframe-when-developing-a-kibana-plugin-that-loads-remote-website/193858)
**Author:** [@sunminxuan](https://discuss.elastic.co/u/sunminxuan)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 6:50pm UTC](https://discuss.elastic.co/t/the-problem-of-using-iframe-when-developing-a-kibana-plugin-that-loads-remote-website/193858 "2019-08-05T18:50:08Z")
I am developing a Kibana plugin and named it test-3. This is the content of kibana/plugins/test\_3/public/components/main/main.js: import React from 'react'; export class Main extends React.Component { constructor(pro… --- ## [Visualize CPU usage](https://discuss.elastic.co/t/visualize-cpu-usage/193234)
**Author:** [@SirJune](https://discuss.elastic.co/u/SirJune)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 7:55pm UTC](https://discuss.elastic.co/t/visualize-cpu-usage/193234 "2019-08-05T19:55:44Z")
i am trying to create graph like How to visualise cpu usage out of 100% but instead of percent values, I'm getting the integer ones. I am using version 7.2 (Kibana,Elastic,Metricbeat). I use Average for system.cpu.tota… --- ## [Canvas if ... or logic](https://discuss.elastic.co/t/canvas-if-or-logic/193843)
**Author:** [@fpunzo](https://discuss.elastic.co/u/fpunzo)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 7:11pm UTC](https://discuss.elastic.co/t/canvas-if-or-logic/193843 "2019-08-05T19:11:35Z")
Hi I am trying to create a RAG (red, amber green) indicator that is based on the results of a query. I am on Kibana Version 6.8.1. I'm trying to add and "OR" condition within an "IF" statement. I am getting the following… --- ## [WHy is 'Save Visualization' so slow?](https://discuss.elastic.co/t/why-is-save-visualization-so-slow/193820)
**Author:** [@cchapman](https://discuss.elastic.co/u/cchapman)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 7:52pm UTC](https://discuss.elastic.co/t/why-is-save-visualization-so-slow/193820 "2019-08-05T19:52:24Z")
When I save a visualization, it takes about 25 seconds. What factors determine how long it takes to save? Is this normal? --- ## [How to pass Values from Drop-down Filter in to ESSQL Query in Kibana Canvas Workpad](https://discuss.elastic.co/t/how-to-pass-values-from-drop-down-filter-in-to-essql-query-in-kibana-canvas-workpad/190041)
**Author:** [@Sankalan\_Banerjee](https://discuss.elastic.co/u/Sankalan_Banerjee)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 7:19pm UTC](https://discuss.elastic.co/t/how-to-pass-values-from-drop-down-filter-in-to-essql-query-in-kibana-canvas-workpad/190041 "2019-08-05T19:19:09Z")
Hi, We have created a Drop-down Filter in Kibana Canvas Workpad which shows the List of Defect Fix Versions :- \`essql query="SELECT defect\_fix\_version FROM \\"project\_defect\_list\*\\""\` | dropdownControl valueColumn="de… --- ## [Embed Kibana in Custom App](https://discuss.elastic.co/t/embed-kibana-in-custom-app/193680)
**Author:** [@adwaitjoshi](https://discuss.elastic.co/u/adwaitjoshi)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 6:39pm UTC](https://discuss.elastic.co/t/embed-kibana-in-custom-app/193680 "2019-08-05T18:39:35Z")
Hello Community, I have struggled with this for a bit now. How are others embedding Kibana in a custom app? What I am trying to do is as follows. When a user logs in to our internal app, depending on their permission th… --- ## [How to create Read Only Kibana dashboards in AWS?](https://discuss.elastic.co/t/how-to-create-read-only-kibana-dashboards-in-aws/193832)
**Author:** [@Nagendra\_Dattatreya](https://discuss.elastic.co/u/Nagendra_Dattatreya)\ **Replies:** 4\ **Last updated:** [August 5, 2019, 5:44pm UTC](https://discuss.elastic.co/t/how-to-create-read-only-kibana-dashboards-in-aws/193832 "2019-08-05T17:44:32Z")
I am currently using Version 6.7 in AWS Cluster. I want to share readonly dashboards (users should only have access to change time filter) to users. Is there a way to accomplish this? --- ## [Data visualizer asks for licence](https://discuss.elastic.co/t/data-visualizer-asks-for-licence/193790)
**Author:** [@Mesmer](https://discuss.elastic.co/u/Mesmer)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 4:14pm UTC](https://discuss.elastic.co/t/data-visualizer-asks-for-licence/193790 "2019-08-05T16:14:42Z")
Just upgraded Kibana from version 7.0 to 7.3 and i notice that now Data Visualizer asks for license. After choosing an index pattern i get the following message: You need permission to access Machine Learning You must … --- ## [Kibana MAC oss version shows xpack error](https://discuss.elastic.co/t/kibana-mac-oss-version-shows-xpack-error/193701)
**Author:** [@asthinasthi](https://discuss.elastic.co/u/asthinasthi)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 4:04pm UTC](https://discuss.elastic.co/t/kibana-mac-oss-version-shows-xpack-error/193701 "2019-08-05T16:04:12Z")
I have an Amazon ES with 6.7.0. Recently migrated from 6.2.3 --\> 6.7.0. I have a separate Kibana instance talking to Amazon ES. I am trying to locally setup a kibana to connect to AmazonES (through aws-es-proxy). I see… --- ## [Timelion split() auto creates yaxis()](https://discuss.elastic.co/t/timelion-split-auto-creates-yaxis/193499)
**Author:** [@GitsBdr](https://discuss.elastic.co/u/GitsBdr)\ **Replies:** 4\ **Last updated:** [August 5, 2019, 3:55pm UTC](https://discuss.elastic.co/t/timelion-split-auto-creates-yaxis/193499 "2019-08-05T15:55:20Z")
Hi, Thanks in advance for the time you would take to read this post I was wondering if there is a way to create yaxis() automatically For example, split(value:5) would make more sense on 5 different yaxis I'm current… --- ## [Error in Unable to create Index Pattern](https://discuss.elastic.co/t/error-in-unable-to-create-index-pattern/193700)
**Author:** [@Peter\_Wong](https://discuss.elastic.co/u/Peter_Wong)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 3:50pm UTC](https://discuss.elastic.co/t/error-in-unable-to-create-index-pattern/193700 "2019-08-05T15:50:00Z")
Dear All, I use the Kibana for automation testing live result published but i cannot create the index pattern. The button next step is disable even i put something in it. How to solve it? --- ## [External URLs - Vega in hosted Kibana](https://discuss.elastic.co/t/external-urls-vega-in-hosted-kibana/193664)
**Author:** [@O.S](https://discuss.elastic.co/u/O.S)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 3:42pm UTC](https://discuss.elastic.co/t/external-urls-vega-in-hosted-kibana/193664 "2019-08-05T15:42:08Z")
Hello, I'm pretty new to Kibana and to Vega / Vega-lite in particularity, so I apologize if the question is somehow stupid, but I could't find a solution online. So I'm trying to the Vega visualization interface in my … --- ## [Can't get shape to render with correct color](https://discuss.elastic.co/t/cant-get-shape-to-render-with-correct-color/193552)
**Author:** [@rickardp](https://discuss.elastic.co/u/rickardp)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 3:27pm UTC](https://discuss.elastic.co/t/cant-get-shape-to-render-with-correct-color/193552 "2019-08-05T15:27:06Z")
Just starting out with Canvas so bear with me :slight\_smile: I am trying to get a box colored based on status, and here's what I have so far filters | essql query="SELECT CASE WHEN LAST(\\"kubernetes.pod.status.phas… --- ## [How to allow read only user to report from Kibana](https://discuss.elastic.co/t/how-to-allow-read-only-user-to-report-from-kibana/189807)
**Author:** [@alonsnir](https://discuss.elastic.co/u/alonsnir)\ **Replies:** 9\ **Last updated:** [August 5, 2019, 1:04pm UTC](https://discuss.elastic.co/t/how-to-allow-read-only-user-to-report-from-kibana/189807 "2019-08-05T13:04:03Z")
Hi, I need some of my dashboard read only users to be able to export data. X-Pack documentation says " To access Kibana and generate reports, you need the kibana\_user and reporting\_user roles". The problem is that us… --- ## [Elastic Cloud Kibana SAML Okta not working with groups](https://discuss.elastic.co/t/elastic-cloud-kibana-saml-okta-not-working-with-groups/193571)
**Author:** [@Gavin\_Hardy](https://discuss.elastic.co/u/Gavin_Hardy)\ **Replies:** 6\ **Last updated:** [August 5, 2019, 12:21pm UTC](https://discuss.elastic.co/t/elastic-cloud-kibana-saml-okta-not-working-with-groups/193571 "2019-08-05T12:21:21Z")
Hello, I have setup ES and Kibana to use xpack, and have got it all working. When I create the kibana users like so { "enabled": true, "roles": \[ "kibana\_user" \], "rules": { "field": { "realm.name"… --- ## [User with \`superuser\` permissions doesn't have rights to apply ILM policies](https://discuss.elastic.co/t/user-with-superuser-permissions-doesnt-have-rights-to-apply-ilm-policies/193758)
**Author:** [@antcas](https://discuss.elastic.co/u/antcas)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 10:14am UTC](https://discuss.elastic.co/t/user-with-superuser-permissions-doesnt-have-rights-to-apply-ilm-policies/193758 "2019-08-05T10:14:51Z")
Hello. We introduced authentication in our cluster last week and now ILM does not work anymore. When I look at the errors, I can see security\_exception: action \[indices:monitor/stats\] is unauthorized for user \[read\_on… --- ## [Time builder help](https://discuss.elastic.co/t/time-builder-help/193509)
**Author:** [@Ayden](https://discuss.elastic.co/u/Ayden)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 8:52am UTC](https://discuss.elastic.co/t/time-builder-help/193509 "2019-08-05T08:52:58Z")
Hello I have a doubt about time builder. The data in my index has 1 month and I used 2 intervals 31day and 365day. My question is why the 365day shows me 0% while the 31day shows me correct values. Shouldn't the 365da… --- ## [Count duplicated field value by doc](https://discuss.elastic.co/t/count-duplicated-field-value-by-doc/193567)
**Author:** [@chaymaa](https://discuss.elastic.co/u/chaymaa)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 8:36am UTC](https://discuss.elastic.co/t/count-duplicated-field-value-by-doc/193567 "2019-08-05T08:36:53Z")
Hi All, I have already aggregate and filter my message into elastic search, and i have now a problem to display the results on a kibana bar chart, This is the final filtered message: { "features" =\> \[ \[0\] { "action… --- ## [Unable to create Custom Kibana Visualisation](https://discuss.elastic.co/t/unable-to-create-custom-kibana-visualisation/193045)
**Author:** [@adityaPsl](https://discuss.elastic.co/u/adityaPsl)\ **Replies:** 4\ **Last updated:** [August 5, 2019, 8:18am UTC](https://discuss.elastic.co/t/unable-to-create-custom-kibana-visualisation/193045 "2019-08-05T08:18:37Z")
Hello Team, I am trying to build Kibana custom visualisation. I am trying to reuse the markdown\_vis from SRC/legacy/core\_plugins , and copied the folder in plugins directory and changed the name from markdown\_vis to cu… --- ## [Install Kibana as a service in centos](https://discuss.elastic.co/t/install-kibana-as-a-service-in-centos/193244)
**Author:** [@cool\_guy99](https://discuss.elastic.co/u/cool_guy99)\ **Replies:** 2\ **Last updated:** [August 4, 2019, 3:06am UTC](https://discuss.elastic.co/t/install-kibana-as-a-service-in-centos/193244 "2019-08-04T03:06:08Z")
Hi, I am using rpm to install kibana. For starting the service, Im using another user and not "kibana" user. Its throwing an error mentioning that "kibana" user does not exist. Is it possible for editing the option and … --- ## [Canvas: preview shows data, elements don't](https://discuss.elastic.co/t/canvas-preview-shows-data-elements-dont/193246)
**Author:** [@joaociocca](https://discuss.elastic.co/u/joaociocca)\ **Replies:** 5\ **Last updated:** [August 3, 2019, 4:15am UTC](https://discuss.elastic.co/t/canvas-preview-shows-data-elements-dont/193246 "2019-08-03T04:15:25Z")
My first time trying out Canvas and I'm feeling lost. Amazingly lost. No matter what I try, I can get data showing up on preview just fine, even a simple metric shows up nicely on preview... but when I save, I get nothi… --- ## [Canvas markdown is not showing data](https://discuss.elastic.co/t/canvas-markdown-is-not-showing-data/193442)
**Author:** [@syedsfayaz](https://discuss.elastic.co/u/syedsfayaz)\ **Replies:** 5\ **Last updated:** [August 2, 2019, 11:52pm UTC](https://discuss.elastic.co/t/canvas-markdown-is-not-showing-data/193442 "2019-08-02T23:52:06Z")
Hi In canvas markdown. I am using elastic sql to pull data from metric beat and sorting it to latest document as I wanted to see the latest result of the jenkins job. SELECT http.json\_test.building,http.json\_test.url,h… --- ## [Unable to change the datatype of an existing field](https://discuss.elastic.co/t/unable-to-change-the-datatype-of-an-existing-field/193598)
**Author:** [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\ **Replies:** 2\ **Last updated:** [August 2, 2019, 11:08pm UTC](https://discuss.elastic.co/t/unable-to-change-the-datatype-of-an-existing-field/193598 "2019-08-02T23:08:05Z")
Please take a look at this one . --- ## [Visual builder interval vs date filter](https://discuss.elastic.co/t/visual-builder-interval-vs-date-filter/193330)
**Author:** [@Ayden](https://discuss.elastic.co/u/Ayden)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 10:33pm UTC](https://discuss.elastic.co/t/visual-builder-interval-vs-date-filter/193330 "2019-08-02T22:33:13Z")
Hello, I'm using visual builder to build a table since I need to use the filter ratio. My problem is when adding the visual builder table to a dashboard, since the interval (auto) of the visual builder is different of … --- ## [Getting full string in Kibana Datatable](https://discuss.elastic.co/t/getting-full-string-in-kibana-datatable/193368)
**Author:** [@Abdul\_Jaleel](https://discuss.elastic.co/u/Abdul_Jaleel)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 10:01pm UTC](https://discuss.elastic.co/t/getting-full-string-in-kibana-datatable/193368 "2019-08-02T22:01:34Z")
One of the field I have with value is listed below "Category": \[ "Book", "Novel", "English" \] Creating datatable visualization with term shows only Category.keyword. since Category is non Aggregatable . Creating d… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=625) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=627)