# Kibana

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

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

**Page:** 346

---

## [How to update the dashboard automatically](https://discuss.elastic.co/t/how-to-update-the-dashboard-automatically/269188)

<div class="topic-metadata">

**Author:** [@pooja1](https://discuss.elastic.co/u/pooja1)\
**Replies:** 7\
**Last updated:** [April 6, 2021, 1:25am UTC](https://discuss.elastic.co/t/how-to-update-the-dashboard-automatically/269188 "2021-04-06T01:25:03Z")

</div>

I want my dashboard to get updated automatically. Whenever I insert data in my csv file and as soon as I press the refresh button it should get updated. I know there is a time filter on the top and I tried using that, b…

---

## [Can someone helps me with this Json input!](https://discuss.elastic.co/t/can-someone-helps-me-with-this-json-input/269122)

<div class="topic-metadata">

**Author:** [@Skander\_Harrabi](https://discuss.elastic.co/u/Skander_Harrabi)\
**Replies:** 4\
**Last updated:** [April 5, 2021, 11:15pm UTC](https://discuss.elastic.co/t/can-someone-helps-me-with-this-json-input/269122 "2021-04-05T23:15:28Z")

</div>

Hello there, So i created an alias based on two indexes, and am creating a visualization with that alias that have a metric (count), what i want do is to make that metric works with documents from only one of indexes …

---

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

<div class="topic-metadata">

**Author:** [@satyabrat\_majhi](https://discuss.elastic.co/u/satyabrat_majhi)\
**Replies:** 3\
**Last updated:** [April 5, 2021, 9:28pm UTC](https://discuss.elastic.co/t/typeerror-cannot-read-property-error-of-undefined/268971 "2021-04-05T21:28:36Z")

</div>

log \[07:40:32.609\] \[warning\]\[config\]\[deprecation\] Config key \[monitoring.cluster\_alerts.email\_notifications.email\_address\] will be required for email notifications to work in 8.0." log \[07:40:33.237\] \[info\]\[plugi…

---

## [How to access emsfile for USA States](https://discuss.elastic.co/t/how-to-access-emsfile-for-usa-states/269110)

<div class="topic-metadata">

**Author:** [@kavorka](https://discuss.elastic.co/u/kavorka)\
**Replies:** 4\
**Last updated:** [April 5, 2021, 8:10pm UTC](https://discuss.elastic.co/t/how-to-access-emsfile-for-usa-states/269110 "2021-04-05T20:10:43Z")

</div>

Trying to get a basic map of USA States to show up via vega. With the following code, I am getting the error "emsfile "USA States" does not exist" Any idea what the emsfile should be, or what could be wrong: { …

---

## [How to compare two fields of two or more documents](https://discuss.elastic.co/t/how-to-compare-two-fields-of-two-or-more-documents/269190)

<div class="topic-metadata">

**Author:** [@Dinesh\_Sharma](https://discuss.elastic.co/u/Dinesh_Sharma)\
**Replies:** 3\
**Last updated:** [April 5, 2021, 5:53pm UTC](https://discuss.elastic.co/t/how-to-compare-two-fields-of-two-or-more-documents/269190 "2021-04-05T17:53:07Z")

</div>

Hi, I have 500 documents and half of them contains "IP.keyword" and half contains "Pim\_IP".keyword. Now I want to filter to get all the document which will have Pim\_IP(from one docuement) == IP.keyword( from other docum…

---

## [Kibana table using data histogram aggregation resulting in counts with decimals](https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249)

<div class="topic-metadata">

**Author:** [@Amphagory](https://discuss.elastic.co/u/Amphagory)\
**Replies:** 1\
**Last updated:** [April 5, 2021, 5:08pm UTC](https://discuss.elastic.co/t/kibana-table-using-data-histogram-aggregation-resulting-in-counts-with-decimals/269249 "2021-04-05T17:08:41Z")

</div>

Hello, I'm using Kibana 7.3.2 where I'm create a simple count table using data histogram aggregation to split the rows into buckets. I am using the timestamp for each event and set the interval to 60 minutes and the in…

---

## [7.4 Embedded Kibana in Iframe Login Page Keeps Reloading and Redirecting to Same Page](https://discuss.elastic.co/t/7-4-embedded-kibana-in-iframe-login-page-keeps-reloading-and-redirecting-to-same-page/269132)

<div class="topic-metadata">

**Author:** [@Ben\_Chen](https://discuss.elastic.co/u/Ben_Chen)\
**Replies:** 1\
**Last updated:** [April 5, 2021, 4:23pm UTC](https://discuss.elastic.co/t/7-4-embedded-kibana-in-iframe-login-page-keeps-reloading-and-redirecting-to-same-page/269132 "2021-04-05T16:23:17Z")

</div>

Possible same issue: Cookies issue while embedding kibana dashboard with iFrame On an embedded, iframed Kibana, the user cannot login on Safari nor Chrome. Opening up the fullscreen dashboard in a separate tab, where …

---

## [Kibana filtering based on some search term](https://discuss.elastic.co/t/kibana-filtering-based-on-some-search-term/268732)

<div class="topic-metadata">

**Author:** [@Darshan\_Kamat](https://discuss.elastic.co/u/Darshan_Kamat)\
**Replies:** 2\
**Last updated:** [April 5, 2021, 3:05pm UTC](https://discuss.elastic.co/t/kibana-filtering-based-on-some-search-term/268732 "2021-04-05T15:05:16Z")

</div>

I am new to Elastic . I have setup like Filebeat-\>ES\<-Kibana Data is unformatted with single lines and multiple lines of logs and inserted into ES from Filebeat. Based on multi line expression new line is inserted int…

---

## [Burndown forecast trendline in Kibana Timelion chart](https://discuss.elastic.co/t/burndown-forecast-trendline-in-kibana-timelion-chart/269245)

<div class="topic-metadata">

**Author:** [@nguggilla](https://discuss.elastic.co/u/nguggilla)\
**Replies:** 0\
**Last updated:** [April 5, 2021, 3:00pm UTC](https://discuss.elastic.co/t/burndown-forecast-trendline-in-kibana-timelion-chart/269245 "2021-04-05T15:00:20Z")

</div>

I am looking to create a forecast trendline based on previous data in timelion chart Here is an example: Things I tried so far, with no luck: mvavg() trend() - close to what we want but not quite correct. Please …

---

## [The content length is bigger than the maximum allowed string](https://discuss.elastic.co/t/the-content-length-is-bigger-than-the-maximum-allowed-string/269223)

<div class="topic-metadata">

**Author:** [@Ivan44785372](https://discuss.elastic.co/u/Ivan44785372)\
**Replies:** 1\
**Last updated:** [April 5, 2021, 2:38pm UTC](https://discuss.elastic.co/t/the-content-length-is-bigger-than-the-maximum-allowed-string/269223 "2021-04-05T14:38:18Z")

</div>

I'm not sure if this error related to Kibana or Elasticsearch . When Try to search in "discovery" I'm getting "The content length (771413825) is bigger than the maximum allowed string (536870888)" How can I fix it ?

---

## [How to put filter inside Vega visualization scatter plot](https://discuss.elastic.co/t/how-to-put-filter-inside-vega-visualization-scatter-plot/267618)

<div class="topic-metadata">

**Author:** [@Shalhevet](https://discuss.elastic.co/u/Shalhevet)\
**Replies:** 2\
**Last updated:** [April 5, 2021, 7:19am UTC](https://discuss.elastic.co/t/how-to-put-filter-inside-vega-visualization-scatter-plot/267618 "2021-04-05T07:19:28Z")

</div>

hi, I want to present the plots for documents with "group"==a, and I only want to present documents with the latest date of the time range applied by the dashboard. How can I do this? here is my script: { $schema: …

---

## [Connect elastic search or Kibana with SQL database](https://discuss.elastic.co/t/connect-elastic-search-or-kibana-with-sql-database/269189)

<div class="topic-metadata">

**Author:** [@pooja1](https://discuss.elastic.co/u/pooja1)\
**Replies:** 4\
**Last updated:** [April 5, 2021, 6:03am UTC](https://discuss.elastic.co/t/connect-elastic-search-or-kibana-with-sql-database/269189 "2021-04-05T06:03:22Z")

</div>

I have a database that is build in MYSQL. I want to connect it with Kibana so that I can access the data by a query Please let me know how should I do it?

---

## [Maps with multiple layer appear not to work as expected](https://discuss.elastic.co/t/maps-with-multiple-layer-appear-not-to-work-as-expected/268959)

<div class="topic-metadata">

**Author:** [@Russell\_Fulton](https://discuss.elastic.co/u/Russell_Fulton)\
**Replies:** 14\
**Last updated:** [April 5, 2021, 4:15am UTC](https://discuss.elastic.co/t/maps-with-multiple-layer-appear-not-to-work-as-expected/268959 "2021-04-05T04:15:12Z")

</div>

Kibaba 7.10 When I create a map with multiple layers and then hide all bar one layer the map always displays the same data when in a dashboard panel: The major difference between the two layers is that the "all auth" h…

---

## [Visualizing json documents](https://discuss.elastic.co/t/visualizing-json-documents/268807)

<div class="topic-metadata">

**Author:** [@Tlm\_Konstantinos](https://discuss.elastic.co/u/Tlm_Konstantinos)\
**Replies:** 2\
**Last updated:** [April 4, 2021, 4:59pm UTC](https://discuss.elastic.co/t/visualizing-json-documents/268807 "2021-04-04T16:59:03Z")

</div>

Hi every one. I have enriched all records in an es index with some json data. ex {'key1':{"key11":val11, "key12":val12}, 'key2': val2} I am looking for a nice way to display that json in Table view or maybe in another…

---

## [How to monitor ILM in canvas](https://discuss.elastic.co/t/how-to-monitor-ilm-in-canvas/268879)

<div class="topic-metadata">

**Author:** [@TheHunter1](https://discuss.elastic.co/u/TheHunter1)\
**Replies:** 8\
**Last updated:** [April 4, 2021, 4:32pm UTC](https://discuss.elastic.co/t/how-to-monitor-ilm-in-canvas/268879 "2021-04-04T16:32:53Z")

</div>

Hello, I would like to create a Canvas where I can see the number of indexs in hot warm and cold and the the total disk used in each phase., and for example the name of index which has been deleted in the last 24 hours …

---

## [Dashboard in vega query elasticsearch and a fixed](https://discuss.elastic.co/t/dashboard-in-vega-query-elasticsearch-and-a-fixed/269075)

<div class="topic-metadata">

**Author:** [@francieliton\_araujo](https://discuss.elastic.co/u/francieliton_araujo)\
**Replies:** 6\
**Last updated:** [April 4, 2021, 12:47pm UTC](https://discuss.elastic.co/t/dashboard-in-vega-query-elasticsearch-and-a-fixed/269075 "2021-04-04T12:47:33Z")

</div>

how to create a dashboard in vega sound an elasticsearch query and a fixed value. { "$schema": "https://vega.github.io/schema/vega-lite/v5.json", "description": "A simple pie chart with labels.", "data": { "v…

---

## [Kibana - Pipeline Editor](https://discuss.elastic.co/t/kibana-pipeline-editor/269134)

<div class="topic-metadata">

**Author:** [@mohsin106](https://discuss.elastic.co/u/mohsin106)\
**Replies:** 1\
**Last updated:** [April 2, 2021, 9:18pm UTC](https://discuss.elastic.co/t/kibana-pipeline-editor/269134 "2021-04-02T21:18:56Z")

</div>

Hi, I'm using Kibana 7.11.1 and I edit my pipelines under the Logstash Pipeline UI. I was wondering if there is a document somewhere that lists available shortcuts that can be used inside of the pipeline editor. Specifi…

---

## [Enhanced Table computed column issue](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000)

<div class="topic-metadata">

**Author:** [@bab](https://discuss.elastic.co/u/bab)\
**Replies:** 3\
**Last updated:** [April 2, 2021, 6:27pm UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000 "2021-04-02T18:27:36Z")

</div>

i'm trying to get the duration in s using the formula but is not working, can someone help pls, thank you.

---

## [FATAL Error: Unable to complete saved object migrations for the \[.kibana\] index. TypeError: Cannot read property 'error' of undefined](https://discuss.elastic.co/t/fatal-error-unable-to-complete-saved-object-migrations-for-the-kibana-index-typeerror-cannot-read-property-error-of-undefined/269066)

<div class="topic-metadata">

**Author:** [@elk\_usr](https://discuss.elastic.co/u/elk_usr)\
**Replies:** 2\
**Last updated:** [April 2, 2021, 6:07pm UTC](https://discuss.elastic.co/t/fatal-error-unable-to-complete-saved-object-migrations-for-the-kibana-index-typeerror-cannot-read-property-error-of-undefined/269066 "2021-04-02T18:07:47Z")

</div>

Hello, I am trying to install Kibana7.12.0 on a new Win10 laptop that has elasticsearch7.12.0 already installed and running. However, Kibana install fails about halfway giving below fatal error Any help on this is g…

---

## [Need help to aggregate a text field into a visualization](https://discuss.elastic.co/t/need-help-to-aggregate-a-text-field-into-a-visualization/269034)

<div class="topic-metadata">

**Author:** [@trubisky](https://discuss.elastic.co/u/trubisky)\
**Replies:** 5\
**Last updated:** [April 2, 2021, 5:14pm UTC](https://discuss.elastic.co/t/need-help-to-aggregate-a-text-field-into-a-visualization/269034 "2021-04-02T17:14:22Z")

</div>

Hi All, I've spent a ton of time on this and I feel like it should be relatively simple but for some reason I'm not able to find the solution. I'll also add that I am fairly novice at visualizations. The docs looks sim…

---

## [Filter one value with other value](https://discuss.elastic.co/t/filter-one-value-with-other-value/269103)

<div class="topic-metadata">

**Author:** [@domra](https://discuss.elastic.co/u/domra)\
**Replies:** 1\
**Last updated:** [April 2, 2021, 2:42pm UTC](https://discuss.elastic.co/t/filter-one-value-with-other-value/269103 "2021-04-02T14:42:38Z")

</div>

Hi! I want to apply a filter to an TSVB metric visualization where I filter all documents, where one value is between a offset of another value. something like this: valueA: \[valueB-1 TO valueB+1\] Is something like th…

---

## [Unable to create scripted filed](https://discuss.elastic.co/t/unable-to-create-scripted-filed/269101)

<div class="topic-metadata">

**Author:** [@Dinesh\_Sharma](https://discuss.elastic.co/u/Dinesh_Sharma)\
**Replies:** 7\
**Last updated:** [April 2, 2021, 2:12pm UTC](https://discuss.elastic.co/t/unable-to-create-scripted-filed/269101 "2021-04-02T14:12:46Z")

</div>

Hi, I was trying to create an scripted field. Where I was implementing the following logic which is return true if IP is equal to Pi\_IP. ''' if (doc\['IP.kayword'\].value == doc\['Pi\_IP.keyword'\].value) { retrun "true"; …

---

## [Unable to start Kibana](https://discuss.elastic.co/t/unable-to-start-kibana/268950)

<div class="topic-metadata">

**Author:** [@maruthi\_Donthi](https://discuss.elastic.co/u/maruthi_Donthi)\
**Replies:** 5\
**Last updated:** [April 2, 2021, 11:33am UTC](https://discuss.elastic.co/t/unable-to-start-kibana/268950 "2021-04-02T11:33:52Z")

</div>

I am trying to start Kibana using a docker. I have already installed elastic search and it is working fine: I can see the elastic search status here: http://localhost:9200/\_cluster/health?pretty But when I run kibana do…

---

## [Where condition](https://discuss.elastic.co/t/where-condition/269072)

<div class="topic-metadata">

**Author:** [@Wolfram\_P](https://discuss.elastic.co/u/Wolfram_P)\
**Replies:** 13\
**Last updated:** [April 2, 2021, 10:22am UTC](https://discuss.elastic.co/t/where-condition/269072 "2021-04-02T10:22:59Z")

</div>

Hi, as a beginner on Kibana this question might be silly, but I cannot get across it: I would like to add a stacked bar graph to my dashboard. Two Y-axis: sum of index abc field1, where field2="1" sum of index abc f…

---

## [Failed to get report](https://discuss.elastic.co/t/failed-to-get-report/269040)

<div class="topic-metadata">

**Author:** [@111456](https://discuss.elastic.co/u/111456)\
**Replies:** 1\
**Last updated:** [April 2, 2021, 9:52am UTC](https://discuss.elastic.co/t/failed-to-get-report/269040 "2021-04-02T09:52:08Z")

</div>

my problem： my yml: server.port: 5601 server.name: "kibana" server.host: "0.0.0.0" elasticsearch.hosts: \["http://192.168.8.142:9200", "http://192.168.8.143:9200", "http://192.168.8.144:9200"\] k…

---

## [How can you enrich and add fields to the correlation event upon rule trigger?](https://discuss.elastic.co/t/how-can-you-enrich-and-add-fields-to-the-correlation-event-upon-rule-trigger/268314)

<div class="topic-metadata">

**Author:** [@fuzzyWedgie](https://discuss.elastic.co/u/fuzzyWedgie)\
**Replies:** 3\
**Last updated:** [April 2, 2021, 7:43am UTC](https://discuss.elastic.co/t/how-can-you-enrich-and-add-fields-to-the-correlation-event-upon-rule-trigger/268314 "2021-04-02T07:43:03Z")

</div>

Hi, When correlating events I want to do enrichment lookups and add extra fields to the correlation event (signal). Also we would like to be able to add fields to the correlation event from the source events that cause…

---

## [Can’t filter Rollup index results](https://discuss.elastic.co/t/can-t-filter-rollup-index-results/268775)

<div class="topic-metadata">

**Author:** [@rokcarl](https://discuss.elastic.co/u/rokcarl)\
**Replies:** 8\
**Last updated:** [April 2, 2021, 5:41am UTC](https://discuss.elastic.co/t/can-t-filter-rollup-index-results/268775 "2021-04-02T05:41:57Z")

</div>

I have a rollup index with some values, e.g. customer. I've created a Kibana dashboard from it. When I try to filter the dashboard with customer : some-customer, I get an error. When I do a custom query, I can filter by …

---

## [Kibana Dashboard - Did this ever get fixed?](https://discuss.elastic.co/t/kibana-dashboard-did-this-ever-get-fixed/268282)

<div class="topic-metadata">

**Author:** [@johnwood](https://discuss.elastic.co/u/johnwood)\
**Replies:** 4\
**Last updated:** [April 1, 2021, 9:47pm UTC](https://discuss.elastic.co/t/kibana-dashboard-did-this-ever-get-fixed/268282 "2021-04-01T21:47:39Z")

</div>

Hi - I am trying to find out if this ever got fixed. I just tried under 7.12 and I get the same result but perhaps there is a switch or option I need to add? Thanks John

---

## [Kibana Alerts - Action on Recovered contains no context.group](https://discuss.elastic.co/t/kibana-alerts-action-on-recovered-contains-no-context-group/268946)

<div class="topic-metadata">

**Author:** [@JMisset88](https://discuss.elastic.co/u/JMisset88)\
**Replies:** 3\
**Last updated:** [April 1, 2021, 7:20pm UTC](https://discuss.elastic.co/t/kibana-alerts-action-on-recovered-contains-no-context-group/268946 "2021-04-01T19:20:19Z")

</div>

Hi, We recently upgraded from Elastic 7.10.0 to 7.12.0. Mainly because I saw the new Alerting/Action functionality to only send an Alert on a Status Change (instead of on an interval). This is a very nice feature, howev…

---

## [A custom role which contains all privileges is not updated after changing to read only role](https://discuss.elastic.co/t/a-custom-role-which-contains-all-privileges-is-not-updated-after-changing-to-read-only-role/268147)

<div class="topic-metadata">

**Author:** [@thiton](https://discuss.elastic.co/u/thiton)\
**Replies:** 13\
**Last updated:** [April 1, 2021, 7:12pm UTC](https://discuss.elastic.co/t/a-custom-role-which-contains-all-privileges-is-not-updated-after-changing-to-read-only-role/268147 "2021-04-01T19:12:54Z")

</div>

Please help to configure how a custom role which contains all privileges is not updated after changing to read only role. Steps to reproduce: First, create a custom role which contains all privileges curl -XPUT http:…

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

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