# Kibana

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

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

**Page:** 436

---

## [Session Counter over time Visualisation](https://discuss.elastic.co/t/session-counter-over-time-visualisation/246299)

<div class="topic-metadata">

**Author:** [@gruselglatz](https://discuss.elastic.co/u/gruselglatz)\
**Replies:** 4\
**Last updated:** [August 28, 2020, 5:05am UTC](https://discuss.elastic.co/t/session-counter-over-time-visualisation/246299 "2020-08-28T05:05:15Z")

</div>

Hi, I have the following Data: Timestamp, SessionState (Opened), SessionID Timestamp, SessionState (Closed), SessionID And I need to visualize the amount of open sessions at "timeframe". Is this somehow possible with…

---

## [Kibana - HTTP 500 error - circuit\_breaking\_exception](https://discuss.elastic.co/t/kibana-http-500-error-circuit-breaking-exception/246708)

<div class="topic-metadata">

**Author:** [@parthmaniar](https://discuss.elastic.co/u/parthmaniar)\
**Replies:** 1\
**Last updated:** [August 28, 2020, 5:00am UTC](https://discuss.elastic.co/t/kibana-http-500-error-circuit-breaking-exception/246708 "2020-08-28T05:00:23Z")

</div>

Hello, I hope you and your loved ones are safe and healthy. I have Kibana and Elasticsearch installed on the same VM. I am getting following error post successful login to Kibana instance using root privileged account. …

---

## [Custom metric calculation in Kibana](https://discuss.elastic.co/t/custom-metric-calculation-in-kibana/241905)

<div class="topic-metadata">

**Author:** [@paolinux](https://discuss.elastic.co/u/paolinux)\
**Replies:** 2\
**Last updated:** [August 27, 2020, 4:34pm UTC](https://discuss.elastic.co/t/custom-metric-calculation-in-kibana/241905 "2020-08-27T16:34:56Z")

</div>

Hi, SHORT VERSION: I need to create a visualization in Kibana that shows an index given as a ratio between a "sum" metric over a given period and a "filtered-count" metric over the same period. What is the best approach…

---

## [Unable to visualize span.http.response.status\_code](https://discuss.elastic.co/t/unable-to-visualize-span-http-response-status-code/246522)

<div class="topic-metadata">

**Author:** [@adamS](https://discuss.elastic.co/u/adamS)\
**Replies:** 1\
**Last updated:** [August 27, 2020, 4:34pm UTC](https://discuss.elastic.co/t/unable-to-visualize-span-http-response-status-code/246522 "2020-08-27T16:34:09Z")

</div>

I'm unable to use the span.http.response.status\_code field (or any of the span.http fields) on APM span documents when building a custom visualization. I can see the info I want in Discover, but it says that it is type …

---

## [Widen date filter on embedded dashboard](https://discuss.elastic.co/t/widen-date-filter-on-embedded-dashboard/245390)

<div class="topic-metadata">

**Author:** [@buncieboy](https://discuss.elastic.co/u/buncieboy)\
**Replies:** 7\
**Last updated:** [August 27, 2020, 4:17pm UTC](https://discuss.elastic.co/t/widen-date-filter-on-embedded-dashboard/245390 "2020-08-27T16:17:32Z")

</div>

I have several visualizations as an embedded dashboard. When a user clicks on part of the dashboard it adds a filter to the bar at the top and they can remove it. However if they select a date range on the record frequen…

---

## [Alerts based on a field](https://discuss.elastic.co/t/alerts-based-on-a-field/246548)

<div class="topic-metadata">

**Author:** [@bevano](https://discuss.elastic.co/u/bevano)\
**Replies:** 3\
**Last updated:** [August 27, 2020, 3:46pm UTC](https://discuss.elastic.co/t/alerts-based-on-a-field/246548 "2020-08-27T15:46:59Z")

</div>

Hi All, Is it possible to create either an alert or a watcher, that is based off the count of a specific field. I currently have application logs that ingest into elasticsearch. I then have a timelion graph that graphs…

---

## [Visualization filter DSL query](https://discuss.elastic.co/t/visualization-filter-dsl-query/246210)

<div class="topic-metadata">

**Author:** [@Incauto](https://discuss.elastic.co/u/Incauto)\
**Replies:** 1\
**Last updated:** [August 27, 2020, 11:36am UTC](https://discuss.elastic.co/t/visualization-filter-dsl-query/246210 "2020-08-27T11:36:46Z")

</div>

Hi, in an index I have fields for interface and host, a host has many interfaces: HOST-01 : interface01, interface02 HOST-02 : interface01, interface02 and I want to filter a specific interface for a es…

---

## [Elasticsearch Indices not showing on Kibana](https://discuss.elastic.co/t/elasticsearch-indices-not-showing-on-kibana/246532)

<div class="topic-metadata">

**Author:** [@PaulMess](https://discuss.elastic.co/u/PaulMess)\
**Replies:** 3\
**Last updated:** [August 27, 2020, 10:25am UTC](https://discuss.elastic.co/t/elasticsearch-indices-not-showing-on-kibana/246532 "2020-08-27T10:25:37Z")

</div>

Hello, I created a index in Elastisearch and look good (creen) But do not appears in Kibana what are the possible reasons for this?

---

## [Large CSV export issue](https://discuss.elastic.co/t/large-csv-export-issue/245976)

<div class="topic-metadata">

**Author:** [@adnanahmed](https://discuss.elastic.co/u/adnanahmed)\
**Replies:** 4\
**Last updated:** [August 27, 2020, 10:09am UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976 "2020-08-27T10:09:45Z")

</div>

Hi Friends, we are using ELK 7.9 version. We are having problem with CSV export of "Saved search" through our Dashboard, it got hanged if size of CSV gets more than 150 MB nevertheless we are able to export c…

---

## [How to rebuld Kibana for UI changes](https://discuss.elastic.co/t/how-to-rebuld-kibana-for-ui-changes/246507)

<div class="topic-metadata">

**Author:** [@User4](https://discuss.elastic.co/u/User4)\
**Replies:** 2\
**Last updated:** [August 27, 2020, 9:40am UTC](https://discuss.elastic.co/t/how-to-rebuld-kibana-for-ui-changes/246507 "2020-08-27T09:40:41Z")

</div>

Hi, I need to change the appearance of Kibana - hide the top bar with the .euiHeader class, I make changes to the css file node\_modules \\ @kbn \\ ui-shared-deps \\ target \\ kbn-ui-shared-deps.light.css, but the changes are…

---

## [Kibana 7.8 is it possible to use JSON input to filter the aggregated column in data table?](https://discuss.elastic.co/t/kibana-7-8-is-it-possible-to-use-json-input-to-filter-the-aggregated-column-in-data-table/246262)

<div class="topic-metadata">

**Author:** [@JasonYangJY](https://discuss.elastic.co/u/JasonYangJY)\
**Replies:** 1\
**Last updated:** [August 27, 2020, 9:12am UTC](https://discuss.elastic.co/t/kibana-7-8-is-it-possible-to-use-json-input-to-filter-the-aggregated-column-in-data-table/246262 "2020-08-27T09:12:18Z")

</div>

Update: I have used the enhanced table plugin to solve this.Thank you very much! I am using kibana 7.8,and try to do some log analyzing.I try to create a data table like bellow and I only want the rows that "access\_cou…

---

## [Picking up document which contains first recorded timestamp](https://discuss.elastic.co/t/picking-up-document-which-contains-first-recorded-timestamp/246518)

<div class="topic-metadata">

**Author:** [@Gauti](https://discuss.elastic.co/u/Gauti)\
**Replies:** 2\
**Last updated:** [August 27, 2020, 8:56am UTC](https://discuss.elastic.co/t/picking-up-document-which-contains-first-recorded-timestamp/246518 "2020-08-27T08:56:45Z")

</div>

Hi All, We are pulling data from servicenow, where all the incident records are been pulled and there are duplicate incidents as well, and all the incidents are tagged with different different created time. We need to …

---

## [Read only access](https://discuss.elastic.co/t/read-only-access/246555)

<div class="topic-metadata">

**Author:** [@akhil\_mogaram](https://discuss.elastic.co/u/akhil_mogaram)\
**Replies:** 1\
**Last updated:** [August 27, 2020, 7:59am UTC](https://discuss.elastic.co/t/read-only-access/246555 "2020-08-27T07:59:49Z")

</div>

Hello Team, I have Kibana 7.7.0 14 days trial version. How do i give read only access to other users without login credentials. Can you help me with it Thanks and Regards, Akhil

---

## [Kibana login page with aws elasticsearch service](https://discuss.elastic.co/t/kibana-login-page-with-aws-elasticsearch-service/245815)

<div class="topic-metadata">

**Author:** [@messi](https://discuss.elastic.co/u/messi)\
**Replies:** 1\
**Last updated:** [August 27, 2020, 7:05am UTC](https://discuss.elastic.co/t/kibana-login-page-with-aws-elasticsearch-service/245815 "2020-08-27T07:05:46Z")

</div>

good afternoon guys, i just integrated kibana with the elasticsearch service from amazon and i would like to know if there is any way to enable some login page when accessing kibana? And how can I do that since the elsat…

---

## [TimeZone issue in GET API](https://discuss.elastic.co/t/timezone-issue-in-get-api/246462)

<div class="topic-metadata">

**Author:** [@subash](https://discuss.elastic.co/u/subash)\
**Replies:** 4\
**Last updated:** [August 27, 2020, 4:49am UTC](https://discuss.elastic.co/t/timezone-issue-in-get-api/246462 "2020-08-27T04:49:34Z")

</div>

Hi, I am facing a challenge in displaying the dateTime field in local time zone. When I filter the data in kibana 'Discover' I am getting the date and time in local time zone. But when I query using the GET API in dev…

---

## [ML job rare function to detect anomaly on IP address will report IP on same network as anomaly](https://discuss.elastic.co/t/ml-job-rare-function-to-detect-anomaly-on-ip-address-will-report-ip-on-same-network-as-anomaly/246213)

<div class="topic-metadata">

**Author:** [@nameisnotimportant](https://discuss.elastic.co/u/nameisnotimportant)\
**Replies:** 2\
**Last updated:** [August 27, 2020, 2:05am UTC](https://discuss.elastic.co/t/ml-job-rare-function-to-detect-anomaly-on-ip-address-will-report-ip-on-same-network-as-anomaly/246213 "2020-08-27T02:05:55Z")

</div>

Hi, Referring to https://discuss.elastic.co/t/ml-how-to-find-anomaly-from-ip-address/239996 I found that IP address on same network will be detected as anomaly. e.g. let say 10.180.1.161 is the regularly used IP addre…

---

## [How to hide top and side menus](https://discuss.elastic.co/t/how-to-hide-top-and-side-menus/246444)

<div class="topic-metadata">

**Author:** [@User4](https://discuss.elastic.co/u/User4)\
**Replies:** 1\
**Last updated:** [August 26, 2020, 10:58pm UTC](https://discuss.elastic.co/t/how-to-hide-top-and-side-menus/246444 "2020-08-26T22:58:26Z")

</div>

Tell me how can I hide the red menus, leaving only the green area?

---

## [Imports Charts From Kibana To PowerPoint](https://discuss.elastic.co/t/imports-charts-from-kibana-to-powerpoint/246438)

<div class="topic-metadata">

**Author:** [@vignesh23041991](https://discuss.elastic.co/u/vignesh23041991)\
**Replies:** 1\
**Last updated:** [August 26, 2020, 10:02pm UTC](https://discuss.elastic.co/t/imports-charts-from-kibana-to-powerpoint/246438 "2020-08-26T22:02:00Z")

</div>

We have an option to build the chart in Excel and modify the Data using VBA in Excel.Like wise do we have any option similar to export the charts from kibana to power point and edit the data?

---

## [TypeError: Cannot read property 'key' of undefined](https://discuss.elastic.co/t/typeerror-cannot-read-property-key-of-undefined/246461)

<div class="topic-metadata">

**Author:** [@balajiduddu](https://discuss.elastic.co/u/balajiduddu)\
**Replies:** 1\
**Last updated:** [August 26, 2020, 9:20pm UTC](https://discuss.elastic.co/t/typeerror-cannot-read-property-key-of-undefined/246461 "2020-08-26T21:20:43Z")

</div>

HI , I am new to kibana and in our project we are using kibana of version 6.2.3 while launching kibana dashboard there we are getting error at the top of the page and in developer page could see the below error Prom…

---

## [Multiple Index Filters](https://discuss.elastic.co/t/multiple-index-filters/246501)

<div class="topic-metadata">

**Author:** [@adwaitjoshi](https://discuss.elastic.co/u/adwaitjoshi)\
**Replies:** 1\
**Last updated:** [August 26, 2020, 9:16pm UTC](https://discuss.elastic.co/t/multiple-index-filters/246501 "2020-08-26T21:16:05Z")

</div>

I have two elastic indexes Parent Child I have created a dashboard with visualizations that use both those indexes. Both of the indexes have a field "family\_id". I can apply the family ID filter to filter the entire …

---

## [Getting unauthorized when doing GET on indices with a read-only user](https://discuss.elastic.co/t/getting-unauthorized-when-doing-get-on-indices-with-a-read-only-user/246129)

<div class="topic-metadata">

**Author:** [@cotjoey](https://discuss.elastic.co/u/cotjoey)\
**Replies:** 3\
**Last updated:** [August 26, 2020, 8:07pm UTC](https://discuss.elastic.co/t/getting-unauthorized-when-doing-get-on-indices-with-a-read-only-user/246129 "2020-08-26T20:07:47Z")

</div>

Hello, I am using Kibana/Elasticsearch 7.9.0, and testing enabling security on the stack. I am starting with a test user that gets the following on the GET API call: GET \_cat/indices { "error" : { "root\_cause" …

---

## [Kibana 7.9.0 - 403 Forbidden on /api/kibana/settings](https://discuss.elastic.co/t/kibana-7-9-0-403-forbidden-on-api-kibana-settings/246201)

<div class="topic-metadata">

**Author:** [@cotjoey](https://discuss.elastic.co/u/cotjoey)\
**Replies:** 2\
**Last updated:** [August 26, 2020, 8:06pm UTC](https://discuss.elastic.co/t/kibana-7-9-0-403-forbidden-on-api-kibana-settings/246201 "2020-08-26T20:06:31Z")

</div>

I've been struggling trying to set up a read-only user for Kibana. It seems like I have it working now, with the exception of an error popping up in the Discover app. It seems to be exactly the issue listed here: https:/…

---

## [Create alert per multiple fields](https://discuss.elastic.co/t/create-alert-per-multiple-fields/242706)

<div class="topic-metadata">

**Author:** [@Sergi](https://discuss.elastic.co/u/Sergi)\
**Replies:** 5\
**Last updated:** [August 26, 2020, 7:59pm UTC](https://discuss.elastic.co/t/create-alert-per-multiple-fields/242706 "2020-08-26T19:59:14Z")

</div>

Hi, Currently, when creating an alert, we can set up for example the next scenario: When avg system.cpu.total.pct is above 90% for the last 1 minute. Okey...It will affect to all the hosts which matches this query, th…

---

## [How to change the text color in kibana dashboard widgets?](https://discuss.elastic.co/t/how-to-change-the-text-color-in-kibana-dashboard-widgets/246334)

<div class="topic-metadata">

**Author:** [@DSMilestone](https://discuss.elastic.co/u/DSMilestone)\
**Replies:** 4\
**Last updated:** [August 26, 2020, 7:14pm UTC](https://discuss.elastic.co/t/how-to-change-the-text-color-in-kibana-dashboard-widgets/246334 "2020-08-26T19:14:24Z")

</div>

How to change the text color in kibana dashboard widgets. In the below screenshot, there are three different lens widgets in the dashboard. I want to change the text color of Passed count to green and failed count to…

---

## [Scripted field to find percent of documents to be used in a metric](https://discuss.elastic.co/t/scripted-field-to-find-percent-of-documents-to-be-used-in-a-metric/246338)

<div class="topic-metadata">

**Author:** [@jc034240](https://discuss.elastic.co/u/jc034240)\
**Replies:** 2\
**Last updated:** [August 26, 2020, 4:25pm UTC](https://discuss.elastic.co/t/scripted-field-to-find-percent-of-documents-to-be-used-in-a-metric/246338 "2020-08-26T16:25:45Z")

</div>

I made a scripted field in Kibana using the below which syntactically is fine but doesn't function properly. I want to take the amount of documents with "Execution", divide that hit count by 10, then multiply that numbe…

---

## [Display Metric Visualization in Abbrievated Number Format based on condition](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248)

<div class="topic-metadata">

**Author:** [@antony\_kavin](https://discuss.elastic.co/u/antony_kavin)\
**Replies:** 3\
**Last updated:** [August 26, 2020, 2:48pm UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248 "2020-08-26T14:48:30Z")

</div>

Hi team, I have a question related to number formatting in kibana. I have created a metric visualization(sum) in Kibana using a number field(Sales). I want to display the metric in abbreviated number format(m or k). I…

---

## [Script throwing error on visualisations: Caused by: java.lang.IllegalArgumentException: invalid sequence of tokens near \['}'\]](https://discuss.elastic.co/t/script-throwing-error-on-visualisations-caused-by-java-lang-illegalargumentexception-invalid-sequence-of-tokens-near/246150)

<div class="topic-metadata">

**Author:** [@twright8](https://discuss.elastic.co/u/twright8)\
**Replies:** 3\
**Last updated:** [August 26, 2020, 2:43pm UTC](https://discuss.elastic.co/t/script-throwing-error-on-visualisations-caused-by-java-lang-illegalargumentexception-invalid-sequence-of-tokens-near/246150 "2020-08-26T14:43:49Z")

</div>

My script: if (doc\['companiesHouse.date\_of\_creation'\].size()\>0 && doc\['awards.date'\].size() \> 0) { return ((doc\['awards.date'\].value.getMillis() - doc\['companiesHouse.date\_of\_creation'\].value.getMillis()) / 86400000); }…

---

## [Dynamic Title for Kibana visualization](https://discuss.elastic.co/t/dynamic-title-for-kibana-visualization/246241)

<div class="topic-metadata">

**Author:** [@subash](https://discuss.elastic.co/u/subash)\
**Replies:** 3\
**Last updated:** [August 26, 2020, 2:42pm UTC](https://discuss.elastic.co/t/dynamic-title-for-kibana-visualization/246241 "2020-08-26T14:42:40Z")

</div>

Hi, I have created a visualization for CPU load, Disk load, memory load for the devices in our network. User can filter any particular device and check its load. The requirement is to add the Device name as the title …

---

## [Is it possible combine two index together in Kibana](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345)

<div class="topic-metadata">

**Author:** [@AKumar123](https://discuss.elastic.co/u/AKumar123)\
**Replies:** 12\
**Last updated:** [August 26, 2020, 2:27pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345 "2020-08-26T14:27:44Z")

</div>

I have two index data which i am using in kibana.For that I created Visulazation as well and able to see Data in dashboard. But challange is when i am filtering data for Index1 after clicking on +Button other index data…

---

## [Scale type option in TSVB visualization](https://discuss.elastic.co/t/scale-type-option-in-tsvb-visualization/246460)

<div class="topic-metadata">

**Author:** [@Rizin\_Hussain](https://discuss.elastic.co/u/Rizin_Hussain)\
**Replies:** 1\
**Last updated:** [August 26, 2020, 2:13pm UTC](https://discuss.elastic.co/t/scale-type-option-in-tsvb-visualization/246460 "2020-08-26T14:13:52Z")

</div>

Created a moving average visualization using TSVB, Since Y-Axis is generated large number scale value small digit number is marked on top of the '0' line. So difficult understand the analysis. In this screenshot, both …

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

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