# Kibana

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

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

**Page:** 499

---

## [Integrating Kibana like a microfrontend into a master app](https://discuss.elastic.co/t/integrating-kibana-like-a-microfrontend-into-a-master-app/230502)

<div class="topic-metadata">

**Author:** [@bard0x](https://discuss.elastic.co/u/bard0x)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 8:21am UTC](https://discuss.elastic.co/t/integrating-kibana-like-a-microfrontend-into-a-master-app/230502 "2020-05-04T08:21:48Z")

</div>

Hi Guys, I have a question: how can joinining Kibana into a master app like a microfrontend? It's possibile to achieve this goal without using an iframe option? Thank's in advance

---

## [Kibana Histogram per second basis](https://discuss.elastic.co/t/kibana-histogram-per-second-basis/230751)

<div class="topic-metadata">

**Author:** [@Manjula\_Wanasinghe](https://discuss.elastic.co/u/Manjula_Wanasinghe)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 8:02am UTC](https://discuss.elastic.co/t/kibana-histogram-per-second-basis/230751 "2020-05-04T08:02:29Z")

</div>

Hi All, is t possible to change the histogram type in KIbana in 7.6. it's available as SUM of available values per scaling time. I want to change it int the AVERAGE value. or make the scaling interval as per-second basi…

---

## [Guage Labels Hidden](https://discuss.elastic.co/t/guage-labels-hidden/230865)

<div class="topic-metadata">

**Author:** [@cawoodm](https://discuss.elastic.co/u/cawoodm)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 7:49am UTC](https://discuss.elastic.co/t/guage-labels-hidden/230865 "2020-05-04T07:49:32Z")

</div>

We're missing some labels which are apparently too long: Enabling "Show Labels" on the Viz doesn't help and there seems to be no option to decrease the font size. How can we display the labels?

---

## [Kibana not Loading in Chrome and no error in Console](https://discuss.elastic.co/t/kibana-not-loading-in-chrome-and-no-error-in-console/230889)

<div class="topic-metadata">

**Author:** [@abhir83](https://discuss.elastic.co/u/abhir83)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 7:42am UTC](https://discuss.elastic.co/t/kibana-not-loading-in-chrome-and-no-error-in-console/230889 "2020-05-04T07:42:18Z")

</div>

I am trying to open Kibana in Chrome(On Windows).It does not open.There is no Error in Console.The message "Change in Connection" is displayed on Chrome.I started the kibana.bat file to start Kibana.Is it Mandatory?After…

---

## [KQL search problem](https://discuss.elastic.co/t/kql-search-problem/229451)

<div class="topic-metadata">

**Author:** [@papmik](https://discuss.elastic.co/u/papmik)\
**Replies:** 3\
**Last updated:** [May 4, 2020, 4:55am UTC](https://discuss.elastic.co/t/kql-search-problem/229451 "2020-05-04T04:55:11Z")

</div>

I want to filter it in the logs : message:cod=49 and the result: "No results match your search criteria". I try it like this message:cod?49 the result is same. I try it like this: message:cod=49 the result is Expected …

---

## [ETL/complex data transformations](https://discuss.elastic.co/t/etl-complex-data-transformations/230653)

<div class="topic-metadata">

**Author:** [@dataplatform12345](https://discuss.elastic.co/u/dataplatform12345)\
**Replies:** 3\
**Last updated:** [May 4, 2020, 3:52am UTC](https://discuss.elastic.co/t/etl-complex-data-transformations/230653 "2020-05-04T03:52:26Z")

</div>

Hi, Is it possible or a good pattern to have complex data transformations (ETL like) running behind a visualization/dashboard based on an single index present in Elasticsearch? I would like to understand the data modeli…

---

## [Automation Anywhere BOTS Logs Visualisation using KIbana](https://discuss.elastic.co/t/automation-anywhere-bots-logs-visualisation-using-kibana/227296)

<div class="topic-metadata">

**Author:** [@hem\_sai\_chand](https://discuss.elastic.co/u/hem_sai_chand)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 2:51am UTC](https://discuss.elastic.co/t/automation-anywhere-bots-logs-visualisation-using-kibana/227296 "2020-05-04T02:51:13Z")

</div>

Hello techies, We would like to visualize our Automation anywehere bots using Kibana. Bots usually generates different types of logs with good amount of information. This could be a great oppurtunity for me disscuss and…

---

## [Unable to regex on aggregation filter input box](https://discuss.elastic.co/t/unable-to-regex-on-aggregation-filter-input-box/230059)

<div class="topic-metadata">

**Author:** [@yishagerew](https://discuss.elastic.co/u/yishagerew)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:56pm UTC](https://discuss.elastic.co/t/unable-to-regex-on-aggregation-filter-input-box/230059 "2020-05-03T21:56:50Z")

</div>

I have the following metrics from a aws service: api-name-404, api-name-406, api-name-501,api-name-500. I wrote the aggregation filter query using regex. But since I want to show 5xx and 4xx errors in same graph, I have…

---

## [Kibana - data visualization prevent without control filters](https://discuss.elastic.co/t/kibana-data-visualization-prevent-without-control-filters/229934)

<div class="topic-metadata">

**Author:** [@nb03briceno](https://discuss.elastic.co/u/nb03briceno)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:51pm UTC](https://discuss.elastic.co/t/kibana-data-visualization-prevent-without-control-filters/229934 "2020-05-03T21:51:10Z")

</div>

Good morning everyone, I have two simple questions about dashboard in KIbana. I have been working in a project and for the moment I'm able to depict some graphs in the dashboard, well the project consists in creating a…

---

## [How to get counts of array item in KQL?](https://discuss.elastic.co/t/how-to-get-counts-of-array-item-in-kql/229802)

<div class="topic-metadata">

**Author:** [@chandler](https://discuss.elastic.co/u/chandler)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:48pm UTC](https://discuss.elastic.co/t/how-to-get-counts-of-array-item-in-kql/229802 "2020-05-03T21:48:42Z")

</div>

Is there any way to count how many item in the items field ? In the following case is 3. I would like to filter docs with more than one item within items. Thanks. { "grocery\_name": "Elastic Eats", "items": \[ { "nam…

---

## [Increasing csv.maxSizeBytes beyond 52428800](https://discuss.elastic.co/t/increasing-csv-maxsizebytes-beyond-52428800/230023)

<div class="topic-metadata">

**Author:** [@ebalmeida](https://discuss.elastic.co/u/ebalmeida)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:47pm UTC](https://discuss.elastic.co/t/increasing-csv-maxsizebytes-beyond-52428800/230023 "2020-05-03T21:47:17Z")

</div>

As the topic title says. Is there any feasible way? Documentation warns about increasing it past the default of 10Mb (I've been using 50Mb successfully) but it actually limits me to 50Mb when I try to increase it past th…

---

## [Not able to take field value in email body sentinl kibanaplugin](https://discuss.elastic.co/t/not-able-to-take-field-value-in-email-body-sentinl-kibanaplugin/230863)

<div class="topic-metadata">

**Author:** [@priti](https://discuss.elastic.co/u/priti)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:38pm UTC](https://discuss.elastic.co/t/not-able-to-take-field-value-in-email-body-sentinl-kibanaplugin/230863 "2020-05-03T21:38:56Z")

</div>

I have installed sentinl kibana plugin for alerting. I am trying to send email using sentinl and in email body i have to take some fields from selected index . How can i take index fields in email body? Please help. I t…

---

## [Timelion heartbeat downtime count analysis](https://discuss.elastic.co/t/timelion-heartbeat-downtime-count-analysis/230873)

<div class="topic-metadata">

**Author:** [@hmd\_hmd](https://discuss.elastic.co/u/hmd_hmd)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:37pm UTC](https://discuss.elastic.co/t/timelion-heartbeat-downtime-count-analysis/230873 "2020-05-03T21:37:08Z")

</div>

A spark-streaming data ingestion service sends a heartbeat every batch loop duration (in a field called ingestion\_alive, with a value of 1). So, if the batch loop is 2 minutes, we expect to receive 30 (+-3) heartbeat mes…

---

## [Kibana show field as string in "Table" view and as number in "JSON" view](https://discuss.elastic.co/t/kibana-show-field-as-string-in-table-view-and-as-number-in-json-view/230586)

<div class="topic-metadata">

**Author:** [@111320](https://discuss.elastic.co/u/111320)\
**Replies:** 5\
**Last updated:** [May 3, 2020, 9:24pm UTC](https://discuss.elastic.co/t/kibana-show-field-as-string-in-table-view-and-as-number-in-json-view/230586 "2020-05-03T21:24:28Z")

</div>

I parse my log with grok. Some fields parsed to number with the grok format {BASE10NUM:DB\_time:int}. When I look on the data in Kibana (version 7.6) I see something that looks like bug. In "Table" view the DB\_time fiel…

---

## [Number of buckets in a timelion query](https://discuss.elastic.co/t/number-of-buckets-in-a-timelion-query/230878)

<div class="topic-metadata">

**Author:** [@hmd\_hmd](https://discuss.elastic.co/u/hmd_hmd)\
**Replies:** 1\
**Last updated:** [May 3, 2020, 9:17pm UTC](https://discuss.elastic.co/t/number-of-buckets-in-a-timelion-query/230878 "2020-05-03T21:17:21Z")

</div>

I would like to know how many buckets were there in total when doing a timeline query. For example, if the query range is set for the last 24 hours, and the interval is 1 hour, then there must be 24 buckets. How to get t…

---

## [How to find the port where kibana is running?](https://discuss.elastic.co/t/how-to-find-the-port-where-kibana-is-running/230769)

<div class="topic-metadata">

**Author:** [@Pradeep\_Sanjeewa](https://discuss.elastic.co/u/Pradeep_Sanjeewa)\
**Replies:** 4\
**Last updated:** [May 3, 2020, 9:09pm UTC](https://discuss.elastic.co/t/how-to-find-the-port-where-kibana-is-running/230769 "2020-05-03T21:09:33Z")

</div>

I have Elastic Stack set up in on-prem servers. It is runnnig fine and querying data is possible without any issue. How can I find the port where kibana is running?

---

## [Formula from fields](https://discuss.elastic.co/t/formula-from-fields/229570)

<div class="topic-metadata">

**Author:** [@peretz\_shlomi](https://discuss.elastic.co/u/peretz_shlomi)\
**Replies:** 7\
**Last updated:** [May 3, 2020, 5:42pm UTC](https://discuss.elastic.co/t/formula-from-fields/229570 "2020-05-03T17:42:03Z")

</div>

Hi I need a new column with formula 'NG Amount' / 'Component Qty' \* 1000000 I tried to perform SCRIPTED FIELDS but without success. Thanks for the helpers

---

## [Hide Scrollbars But Keep Functionality in a Kibana app plugin](https://discuss.elastic.co/t/hide-scrollbars-but-keep-functionality-in-a-kibana-app-plugin/229849)

<div class="topic-metadata">

**Author:** [@Nicolap](https://discuss.elastic.co/u/Nicolap)\
**Replies:** 2\
**Last updated:** [May 3, 2020, 3:49pm UTC](https://discuss.elastic.co/t/hide-scrollbars-but-keep-functionality-in-a-kibana-app-plugin/229849 "2020-05-03T15:49:46Z")

</div>

Hi there, In a Kibana app plugin I need to hide the vertical scrollbar, but keep functionality.. I tryed with the following CSS code, but It doesn't works: /\* Hide scrollbar for Chrome, Safari and Opera \*/ .app-wrapp…

---

## [How to create a linegraph chart with different "dot" colors based on column values](https://discuss.elastic.co/t/how-to-create-a-linegraph-chart-with-different-dot-colors-based-on-column-values/230738)

<div class="topic-metadata">

**Author:** [@tenet\_testuser1](https://discuss.elastic.co/u/tenet_testuser1)\
**Replies:** 1\
**Last updated:** [May 2, 2020, 11:55pm UTC](https://discuss.elastic.co/t/how-to-create-a-linegraph-chart-with-different-dot-colors-based-on-column-values/230738 "2020-05-02T23:55:46Z")

</div>

Hi, x-axis - time y-axis - my\_metric (line graph) y-axis - mymetric2 (dots) on the line... I want to create a line graph where one of the columns has 3 possible values (1,2,3) and I want to show a "red", "green", "bl…

---

## [How to hide default space on Kibana for users (basic license)](https://discuss.elastic.co/t/how-to-hide-default-space-on-kibana-for-users-basic-license/230799)

<div class="topic-metadata">

**Author:** [@nino](https://discuss.elastic.co/u/nino)\
**Replies:** 1\
**Last updated:** [May 2, 2020, 7:50pm UTC](https://discuss.elastic.co/t/how-to-hide-default-space-on-kibana-for-users-basic-license/230799 "2020-05-02T19:50:33Z")

</div>

Hello all, i am playing arund roles, spaces & users and i am not be able to hide default space to users. Default space is always present. Is that possible? elastic version: 7.5.0 Thanks

---

## [Apply scripted field to existing data retroactively?](https://discuss.elastic.co/t/apply-scripted-field-to-existing-data-retroactively/230812)

<div class="topic-metadata">

**Author:** [@gthang](https://discuss.elastic.co/u/gthang)\
**Replies:** 1\
**Last updated:** [May 2, 2020, 6:53pm UTC](https://discuss.elastic.co/t/apply-scripted-field-to-existing-data-retroactively/230812 "2020-05-02T18:53:53Z")

</div>

Hello, Is it possible to retroactively create a scripted field retroactively to an index? I have created some visualizations, and it works great with this new field and would like this field available from data capture…

---

## [Using Elastic SQL with Vega](https://discuss.elastic.co/t/using-elastic-sql-with-vega/230455)

<div class="topic-metadata">

**Author:** [@mlehotsky](https://discuss.elastic.co/u/mlehotsky)\
**Replies:** 3\
**Last updated:** [May 1, 2020, 11:29pm UTC](https://discuss.elastic.co/t/using-elastic-sql-with-vega/230455 "2020-05-01T23:29:06Z")

</div>

Hi Kibana team, I have this Elastic SQL query which works as expected: POST /\_sql?format=txt { "query": "SELECT id AS Images, (MAX(pull\_count)-MIN(pull\_count)) AS Pulls\_Added FROM \\"project1\\" GROUP BY id" } Resul…

---

## [Export Multiple Dashboards API](https://discuss.elastic.co/t/export-multiple-dashboards-api/230774)

<div class="topic-metadata">

**Author:** [@Gundam\_Airline](https://discuss.elastic.co/u/Gundam_Airline)\
**Replies:** 1\
**Last updated:** [May 1, 2020, 11:11pm UTC](https://discuss.elastic.co/t/export-multiple-dashboards-api/230774 "2020-05-01T23:11:28Z")

</div>

Hi All, I am trying to export multiple dashboard at once. I have no issue doing an export for 1 dashboard. Two dashboard is where I am seeing an error. I went to https://www.elastic.co/guide/en/kibana/current/dashboard-…

---

## [How to normalize for time in Kibana](https://discuss.elastic.co/t/how-to-normalize-for-time-in-kibana/230624)

<div class="topic-metadata">

**Author:** [@vstevenson](https://discuss.elastic.co/u/vstevenson)\
**Replies:** 6\
**Last updated:** [May 1, 2020, 3:47pm UTC](https://discuss.elastic.co/t/how-to-normalize-for-time-in-kibana/230624 "2020-05-01T15:47:00Z")

</div>

In my index, I am tracking the performance of widgets. I have the install date of each widget. I would like to determine which widgets have had the most number of parts replaced on them per time, accounting for the fact …

---

## [Roles](https://discuss.elastic.co/t/roles/230036)

<div class="topic-metadata">

**Author:** [@jppedals](https://discuss.elastic.co/u/jppedals)\
**Replies:** 2\
**Last updated:** [May 1, 2020, 1:37pm UTC](https://discuss.elastic.co/t/roles/230036 "2020-05-01T13:37:38Z")

</div>

So My issue is I am not very good with using kibana and i have custom roles but the custom roles cant save search and they cant generate a .CSV report for export if anyone can assist with this that would be great.

---

## [Aggregation Wildly Incorrect](https://discuss.elastic.co/t/aggregation-wildly-incorrect/230349)

<div class="topic-metadata">

**Author:** [@cawoodm](https://discuss.elastic.co/u/cawoodm)\
**Replies:** 3\
**Last updated:** [May 1, 2020, 6:29am UTC](https://discuss.elastic.co/t/aggregation-wildly-incorrect/230349 "2020-05-01T06:29:26Z")

</div>

We are seeing Kibana 7.6.1 (ES 7.6.2) return wildly incorrect numbers when calculating the average and maximum of a value. The data in question is 3 values for a field kpi1: timestamp kpi1 2020-04-29T09:…

---

## [APM: joining spans and transactions](https://discuss.elastic.co/t/apm-joining-spans-and-transactions/230645)

<div class="topic-metadata">

**Author:** [@Emanuel\_Velzi](https://discuss.elastic.co/u/Emanuel_Velzi)\
**Replies:** 0\
**Last updated:** [April 30, 2020, 11:05pm UTC](https://discuss.elastic.co/t/apm-joining-spans-and-transactions/230645 "2020-04-30T23:05:46Z")

</div>

Hi! I am using Elastic APM and I need to know how much time spent a transaction accessing to my MongoDB. For that I'm trying to make a table visualisation on Kibana joining data about transactions and spans but I have …

---

## [Which visualization creates this](https://discuss.elastic.co/t/which-visualization-creates-this/230609)

<div class="topic-metadata">

**Author:** [@edvrfn](https://discuss.elastic.co/u/edvrfn)\
**Replies:** 2\
**Last updated:** [April 30, 2020, 9:34pm UTC](https://discuss.elastic.co/t/which-visualization-creates-this/230609 "2020-04-30T21:34:38Z")

</div>

Which visualization creates both bar chart and bubbles.

---

## [Kibana kubernetes dashboard not found](https://discuss.elastic.co/t/kibana-kubernetes-dashboard-not-found/230616)

<div class="topic-metadata">

**Author:** [@111326](https://discuss.elastic.co/u/111326)\
**Replies:** 5\
**Last updated:** [April 30, 2020, 7:10pm UTC](https://discuss.elastic.co/t/kibana-kubernetes-dashboard-not-found/230616 "2020-04-30T19:10:45Z")

</div>

i want use kubernetes dashboard metrics - but get error kibana 7.6.2

---

## [Link to a dashboard on the same site without the domain](https://discuss.elastic.co/t/link-to-a-dashboard-on-the-same-site-without-the-domain/230617)

<div class="topic-metadata">

**Author:** [@bertm81](https://discuss.elastic.co/u/bertm81)\
**Replies:** 1\
**Last updated:** [April 30, 2020, 6:49pm UTC](https://discuss.elastic.co/t/link-to-a-dashboard-on-the-same-site-without-the-domain/230617 "2020-04-30T18:49:09Z")

</div>

I am operating a live and staging system and have links within dashboards for drilldowns. The problem is, I have one domain name for live and a different for staging so when I copy the saved objects from live to staging …

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

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