# Kibana

**URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=480

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 481

---

## [How can I calculate difference of count from last day with TSVB metrics?](https://discuss.elastic.co/t/how-can-i-calculate-difference-of-count-from-last-day-with-tsvb-metrics/234062)

<div class="topic-metadata">

**Author:** [@Hugo\_Pires](https://discuss.elastic.co/u/Hugo_Pires)\
**Replies:** 3\
**Last updated:** [June 3, 2020, 7:01pm UTC](https://discuss.elastic.co/t/how-can-i-calculate-difference-of-count-from-last-day-with-tsvb-metrics/234062 "2020-06-03T19:01:39Z")

</div>

Hello I as trying to use derivative of count to calculate difference between count from today and yesterday, but the value shown is 0 Could you help me? Thank you Hugo

---

## [Json script divide sum of two fields and multiple it to get the percentage](https://discuss.elastic.co/t/json-script-divide-sum-of-two-fields-and-multiple-it-to-get-the-percentage/234295)

<div class="topic-metadata">

**Author:** [@akshay\_dindure1994](https://discuss.elastic.co/u/akshay_dindure1994)\
**Replies:** 5\
**Last updated:** [June 3, 2020, 6:58pm UTC](https://discuss.elastic.co/t/json-script-divide-sum-of-two-fields-and-multiple-it-to-get-the-percentage/234295 "2020-06-03T18:58:40Z")

</div>

Trying to calculate percentage for sum of two fields in metric for visulazation { "script": "(doc\['v1'\].sum()/doc\['v2'\].sum())\*100" } But getting wrong result { "script": "(doc\['v1'\].sum()/ 2)" } \`but her…

---

## [Kibana 7.7 Generated Plugin causes kibana to fail](https://discuss.elastic.co/t/kibana-7-7-generated-plugin-causes-kibana-to-fail/235592)

<div class="topic-metadata">

**Author:** [@Paul\_Gege](https://discuss.elastic.co/u/Paul_Gege)\
**Replies:** 4\
**Last updated:** [June 3, 2020, 6:37pm UTC](https://discuss.elastic.co/t/kibana-7-7-generated-plugin-causes-kibana-to-fail/235592 "2020-06-03T18:37:56Z")

</div>

Hi guys, I've been having issues with getting kibana to startup after installing my plugin. I generate the plugin using the kibana plugin generator. I went through all the steps on github and generated my plugin. Howev…

---

## [Modify Kibana and x-pack code](https://discuss.elastic.co/t/modify-kibana-and-x-pack-code/235415)

<div class="topic-metadata">

**Author:** [@dreamspy](https://discuss.elastic.co/u/dreamspy)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 6:22pm UTC](https://discuss.elastic.co/t/modify-kibana-and-x-pack-code/235415 "2020-06-03T18:22:20Z")

</div>

I'm wondering to what degree one can modify Kibana's code for commercial use? I know that some parts of Kibana are licensed under Apache license, and some under Elastic license. But I'm not completely understanding the …

---

## [Visualisation for this index](https://discuss.elastic.co/t/visualisation-for-this-index/235042)

<div class="topic-metadata">

**Author:** [@vijay3](https://discuss.elastic.co/u/vijay3)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 6:01pm UTC](https://discuss.elastic.co/t/visualisation-for-this-index/235042 "2020-06-03T18:01:42Z")

</div>

Hi I have an index which has data like the following: { "team": "Brazil", "goals": "40", "year": "2010" } { "team": "Brazil", "goals": "50" "year": "2010" } { "team": "Argentina", "goals": "50", "year": "20…

---

## [Kibana Query How to Drop Partial Buckets?](https://discuss.elastic.co/t/kibana-query-how-to-drop-partial-buckets/235602)

<div class="topic-metadata">

**Author:** [@vdalvi](https://discuss.elastic.co/u/vdalvi)\
**Replies:** 2\
**Last updated:** [June 3, 2020, 5:49pm UTC](https://discuss.elastic.co/t/kibana-query-how-to-drop-partial-buckets/235602 "2020-06-03T17:49:56Z")

</div>

Hi, I get the below three buckets typically in my query result when I run my query. Is it possible to drop the partial buckets? Lets assume I get 3 buckets (B1, B2, B3). I just want to view results of B2 (please see re…

---

## [Layer information - WMS in Maps](https://discuss.elastic.co/t/layer-information-wms-in-maps/232856)

<div class="topic-metadata">

**Author:** [@hidrovis](https://discuss.elastic.co/u/hidrovis)\
**Replies:** 7\
**Last updated:** [June 3, 2020, 3:52pm UTC](https://discuss.elastic.co/t/layer-information-wms-in-maps/232856 "2020-06-03T15:52:05Z")

</div>

Hi! I'm trying to add a few layers of a WMS to a map and I've run into a problem. I can connect to the WMS and view the layers but I can't access the layer information. Isn't it possible from Kibana Maps? What is the pr…

---

## [Create side by side bar chart for business data](https://discuss.elastic.co/t/create-side-by-side-bar-chart-for-business-data/235500)

<div class="topic-metadata">

**Author:** [@LWine](https://discuss.elastic.co/u/LWine)\
**Replies:** 2\
**Last updated:** [June 3, 2020, 3:16pm UTC](https://discuss.elastic.co/t/create-side-by-side-bar-chart-for-business-data/235500 "2020-06-03T15:16:53Z")

</div>

Hello! I am trying to find a way to visualize monthly revenues with three bars for each month (e.g. January 2020, 2019, 2018, then February 2020, 2019, 2018, and so on). Like this one: I tried with timelion, TSVB and…

---

## [Incorrect Number of Linked Indices for ILM Polices in 7.7](https://discuss.elastic.co/t/incorrect-number-of-linked-indices-for-ilm-polices-in-7-7/235412)

<div class="topic-metadata">

**Author:** [@Alsheh](https://discuss.elastic.co/u/Alsheh)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 3:13pm UTC](https://discuss.elastic.co/t/incorrect-number-of-linked-indices-for-ilm-polices-in-7-7/235412 "2020-06-03T15:13:37Z")

</div>

When inspecting indices from the index management page, it does show that the index is linked to the expected ILM policy. However, when viewing the ILM polices page, it shows that the number of linked indices is zero for…

---

## [Kibana :show all pie label](https://discuss.elastic.co/t/kibana-show-all-pie-label/235290)

<div class="topic-metadata">

**Author:** [@suibgui](https://discuss.elastic.co/u/suibgui)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 3:02pm UTC](https://discuss.elastic.co/t/kibana-show-all-pie-label/235290 "2020-06-03T15:02:36Z")

</div>

hi team , Not all labels are showing up on the pie dashboard (kibana 7.4.0) . I tried expanding the visualization but still not all labels are showing up. Could anyone guide on how to show all labels. any solution ?? t…

---

## [Visualize data table using different indices](https://discuss.elastic.co/t/visualize-data-table-using-different-indices/235581)

<div class="topic-metadata">

**Author:** [@inchirah](https://discuss.elastic.co/u/inchirah)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 2:58pm UTC](https://discuss.elastic.co/t/visualize-data-table-using-different-indices/235581 "2020-06-03T14:58:43Z")

</div>

Hi everyone, I wonder if I can visualize a data table using three different indices. Precisely those indices are different in one field. Thank you.

---

## [Create A Kibana Space All Users Automatically Have Access To](https://discuss.elastic.co/t/create-a-kibana-space-all-users-automatically-have-access-to/235555)

<div class="topic-metadata">

**Author:** [@devops\_guy1](https://discuss.elastic.co/u/devops_guy1)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 2:54pm UTC](https://discuss.elastic.co/t/create-a-kibana-space-all-users-automatically-have-access-to/235555 "2020-06-03T14:54:39Z")

</div>

Hi, Is it possible using Kibana 7.6.1 and Elasticsearch 7.6.1 to create a Kibana Space that all users automatically have access to, without having to give permissions to specific Elasticsearch Roles to that space? (My …

---

## [Minute aggregation using Date histogram not happening](https://discuss.elastic.co/t/minute-aggregation-using-date-histogram-not-happening/235277)

<div class="topic-metadata">

**Author:** [@sarvendras](https://discuss.elastic.co/u/sarvendras)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 2:49pm UTC](https://discuss.elastic.co/t/minute-aggregation-using-date-histogram-not-happening/235277 "2020-06-03T14:49:27Z")

</div>

Hi All, Using Date Histogram I am trying to create daily/hourly count of transactions (y axis) and Timestamp on X axis.Daily/hourly count is working fine but when i am selecting count by minute/second then count is chan…

---

## [Error while configuring Kibana Development setup](https://discuss.elastic.co/t/error-while-configuring-kibana-development-setup/234690)

<div class="topic-metadata">

**Author:** [@anilreddyd](https://discuss.elastic.co/u/anilreddyd)\
**Replies:** 7\
**Last updated:** [June 3, 2020, 2:00pm UTC](https://discuss.elastic.co/t/error-while-configuring-kibana-development-setup/234690 "2020-06-03T14:00:36Z")

</div>

Hi, I am trying to develop Kibana development environment to do the changes and rebuild. During the setup process while executing the command "yarn kbn bootstrap", I am getting the below error ERROR Kibana pre-commit …

---

## [Data aggregation](https://discuss.elastic.co/t/data-aggregation/235524)

<div class="topic-metadata">

**Author:** [@pranavchauhan0110](https://discuss.elastic.co/u/pranavchauhan0110)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 1:58pm UTC](https://discuss.elastic.co/t/data-aggregation/235524 "2020-06-03T13:58:52Z")

</div>

Hi, I want to extract data from an index based on contactDateTime property which is : "type": "date", format": "YYYY-MM-DD HH:mm:ss ZZ". What I want in the data is to filter the matching data between two specified time …

---

## [Filter Kibana for a field in doc that does not exist in all douments](https://discuss.elastic.co/t/filter-kibana-for-a-field-in-doc-that-does-not-exist-in-all-douments/234810)

<div class="topic-metadata">

**Author:** [@sanjaysubramanian](https://discuss.elastic.co/u/sanjaysubramanian)\
**Replies:** 4\
**Last updated:** [June 3, 2020, 1:49pm UTC](https://discuss.elastic.co/t/filter-kibana-for-a-field-in-doc-that-does-not-exist-in-all-douments/234810 "2020-06-03T13:49:20Z")

</div>

Lets say I have 5 docs in my BANDS index. Doc \[1\] { "score" : 100, "band" : "Cream", "genre" : "Blues" } Doc \[2\] { "score" : 90, "band" : "Beatles", "genre" : "Pop" } Doc \[3\] { "score" : 99, "band" : "Eri…

---

## [Map Visualization in kibana with location name](https://discuss.elastic.co/t/map-visualization-in-kibana-with-location-name/235459)

<div class="topic-metadata">

**Author:** [@Gauti](https://discuss.elastic.co/u/Gauti)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 1:20pm UTC](https://discuss.elastic.co/t/map-visualization-in-kibana-with-location-name/235459 "2020-06-03T13:20:20Z")

</div>

HI All, We are trying to create a map visualization in kibana but we dont have latitude and longitude fields, all we have is location name. Is there a possible way to create map with having location name alone? Any sug…

---

## [Pie Manipulate Slices](https://discuss.elastic.co/t/pie-manipulate-slices/235432)

<div class="topic-metadata">

**Author:** [@David\_Samokovlisky](https://discuss.elastic.co/u/David_Samokovlisky)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 1:11pm UTC](https://discuss.elastic.co/t/pie-manipulate-slices/235432 "2020-06-03T13:11:07Z")

</div>

Hi! Creating simple Pie Visualization, which shows the SUM of field X, and split slices by TERMS of field Y. (Field X is a number, and Field Y is a keyword). My question is, can I manipulate existing Slices and make a…

---

## [Average of counts in a grouping](https://discuss.elastic.co/t/average-of-counts-in-a-grouping/235337)

<div class="topic-metadata">

**Author:** [@Abinash\_Gupta](https://discuss.elastic.co/u/Abinash_Gupta)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 12:52pm UTC](https://discuss.elastic.co/t/average-of-counts-in-a-grouping/235337 "2020-06-03T12:52:44Z")

</div>

Hi All, Is it possible to write below SQL query in Jivana Visualization? Below query works fine with Canvas SQL with display as average. Select count (a), b, c from "my-index" where x = 'some value' group by b,c Also …

---

## [Dates ingested to elasticsearch are shown differently in Kibana Discover](https://discuss.elastic.co/t/dates-ingested-to-elasticsearch-are-shown-differently-in-kibana-discover/235365)

<div class="topic-metadata">

**Author:** [@stLalo](https://discuss.elastic.co/u/stLalo)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 12:49pm UTC](https://discuss.elastic.co/t/dates-ingested-to-elasticsearch-are-shown-differently-in-kibana-discover/235365 "2020-06-03T12:49:18Z")

</div>

I am ingesting a CSV file using OpenCSV into POJO with Java. My date format in the file is "yyyy-MM-dd." The Date is read properly and ingested to Elasticsearch as it is. However, whenever I go to Kibana Discover, I will…

---

## [Cannot access Kibana7.7 from remote](https://discuss.elastic.co/t/cannot-access-kibana7-7-from-remote/235496)

<div class="topic-metadata">

**Author:** [@sutra](https://discuss.elastic.co/u/sutra)\
**Replies:** 1\
**Last updated:** [June 3, 2020, 10:04am UTC](https://discuss.elastic.co/t/cannot-access-kibana7-7-from-remote/235496 "2020-06-03T10:04:03Z")

</div>

I haved installed ES7.7. ES runs successfully. Kibana can be installed and started as well. While Kibana connect Elasticsearch through intranet ip address, we want to access Kibana through internet ip address. I just e…

---

## [Histogram Type Support in Metrics Page](https://discuss.elastic.co/t/histogram-type-support-in-metrics-page/234945)

<div class="topic-metadata">

**Author:** [@Vladimiro](https://discuss.elastic.co/u/Vladimiro)\
**Replies:** 3\
**Last updated:** [June 3, 2020, 7:22am UTC](https://discuss.elastic.co/t/histogram-type-support-in-metrics-page/234945 "2020-06-03T07:22:54Z")

</div>

Hi, ES histogram type is now (v 7.7) supported in visualizations (https://github.com/elastic/kibana/pull/59387). Any plans to support it in the Metrics page so to be able to display percentiles for histogram fields for …

---

## [Timelion and split with an if statement help](https://discuss.elastic.co/t/timelion-and-split-with-an-if-statement-help/234451)

<div class="topic-metadata">

**Author:** [@bjeeves](https://discuss.elastic.co/u/bjeeves)\
**Replies:** 2\
**Last updated:** [June 3, 2020, 2:04am UTC](https://discuss.elastic.co/t/timelion-and-split-with-an-if-statement-help/234451 "2020-06-03T02:04:46Z")

</div>

Hi I am looking for some help and not sure if I am doing it right or if it's possible so here I go on my problem. I am monitoring a switch interfaces with netconf/python and storing the values into ES. Then using timel…

---

## [Linux ps command shows Elasticsearch password](https://discuss.elastic.co/t/linux-ps-command-shows-elasticsearch-password/234621)

<div class="topic-metadata">

**Author:** [@silentfilm](https://discuss.elastic.co/u/silentfilm)\
**Replies:** 6\
**Last updated:** [June 3, 2020, 12:38am UTC](https://discuss.elastic.co/t/linux-ps-command-shows-elasticsearch-password/234621 "2020-06-03T00:38:14Z")

</div>

We are running docker versions of Kibana and Elasticsearch. When kibana is running, you can use a Linux "ps" command to see the Elasticsearch password. geo 233087 232961 6 21:11 ? 00:00:06 /usr/share/kiban…

---

## [Kibana multicluster monitoring](https://discuss.elastic.co/t/kibana-multicluster-monitoring/233163)

<div class="topic-metadata">

**Author:** [@chinmoy\_padhi](https://discuss.elastic.co/u/chinmoy_padhi)\
**Replies:** 4\
**Last updated:** [June 2, 2020, 11:00pm UTC](https://discuss.elastic.co/t/kibana-multicluster-monitoring/233163 "2020-06-02T23:00:57Z")

</div>

Hi, Does Kibana support Multicluster monitoring? I have a Rancher 2.x setup which has got two clusters and Kibana has been deployed to each of the clusters. Now as a site requirement we want to monitor the indexes from…

---

## [Where is the quakes\_objects.json file at blog "Aftershock Therapy with Elasticsearch and CSV Data Import"](https://discuss.elastic.co/t/where-is-the-quakes-objects-json-file-at-blog-aftershock-therapy-with-elasticsearch-and-csv-data-import/235040)

<div class="topic-metadata">

**Author:** [@WalterLee](https://discuss.elastic.co/u/WalterLee)\
**Replies:** 1\
**Last updated:** [June 2, 2020, 9:19pm UTC](https://discuss.elastic.co/t/where-is-the-quakes-objects-json-file-at-blog-aftershock-therapy-with-elasticsearch-and-csv-data-import/235040 "2020-06-02T21:19:01Z")

</div>

Hi, I am trying the demo at but unable to download the json below, any help is great ! " I’ve already built and saved as a downloadable json file." Walter

---

## [Fields are not visible in the Discovery panel](https://discuss.elastic.co/t/fields-are-not-visible-in-the-discovery-panel/233915)

<div class="topic-metadata">

**Author:** [@hilo21](https://discuss.elastic.co/u/hilo21)\
**Replies:** 3\
**Last updated:** [June 2, 2020, 7:59pm UTC](https://discuss.elastic.co/t/fields-are-not-visible-in-the-discovery-panel/233915 "2020-06-02T19:59:12Z")

</div>

Hello, I am encountering a "weird" problem with kibana. I am ingesting some few event from an ESXi Vmware through logstash to Elasticsearch. At first I can see the fields that I added with logstash on the discovery pan…

---

## [Percentage Mode - 0-100% min/max Heat Map](https://discuss.elastic.co/t/percentage-mode-0-100-min-max-heat-map/233827)

<div class="topic-metadata">

**Author:** [@cb1kr](https://discuss.elastic.co/u/cb1kr)\
**Replies:** 3\
**Last updated:** [June 2, 2020, 5:09pm UTC](https://discuss.elastic.co/t/percentage-mode-0-100-min-max-heat-map/233827 "2020-06-02T17:09:37Z")

</div>

Newbie here! I am trying to create a dashboard that contains some systems reporting back with Metricbeat. Based on the input, I would like to create a heatmap that using the normalized CPU percent as the metric over tim…

---

## [Getting Kibana docker image to connect to ES](https://discuss.elastic.co/t/getting-kibana-docker-image-to-connect-to-es/235370)

<div class="topic-metadata">

**Author:** [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\
**Replies:** 1\
**Last updated:** [June 2, 2020, 4:19pm UTC](https://discuss.elastic.co/t/getting-kibana-docker-image-to-connect-to-es/235370 "2020-06-02T16:19:34Z")

</div>

I have an elasticsearch cluster running in docker using the elastic images. The cluster responds to request from my localhost. I downloaded the kibana docker image and I can't get it to connect to elasticsearch. I get t…

---

## [Can't create index in Kibana](https://discuss.elastic.co/t/cant-create-index-in-kibana/233398)

<div class="topic-metadata">

**Author:** [@Leonardo\_Posadas](https://discuss.elastic.co/u/Leonardo_Posadas)\
**Replies:** 4\
**Last updated:** [June 2, 2020, 3:37pm UTC](https://discuss.elastic.co/t/cant-create-index-in-kibana/233398 "2020-06-02T15:37:24Z")

</div>

Hi! i'm new in this community, I cant create a index in Kibana. I dont see the button grey of "Create". I just installed ELK. Attach image. Regards!

[Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=479)

[Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=481)
