# Kibana

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

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

**Page:** 229

---

## [Sum of all values in table visual kibana](https://discuss.elastic.co/t/sum-of-all-values-in-table-visual-kibana/300522)

<div class="topic-metadata">

**Author:** [@Naga\_Prudhvi](https://discuss.elastic.co/u/Naga_Prudhvi)\
**Replies:** 2\
**Last updated:** [March 24, 2022, 12:33pm UTC](https://discuss.elastic.co/t/sum-of-all-values-in-table-visual-kibana/300522 "2022-03-24T12:33:24Z")

</div>

Hi all, I need to add a table view in my kibana dashboard with a sum for all columns like Excel. (see the picture. Is there any idea.

---

## [Kibana deprecation issues: Source configuration field "host name" is deprecated](https://discuss.elastic.co/t/kibana-deprecation-issues-source-configuration-field-host-name-is-deprecated/299997)

<div class="topic-metadata">

**Author:** [@lusynda](https://discuss.elastic.co/u/lusynda)\
**Replies:** 9\
**Last updated:** [March 24, 2022, 10:44am UTC](https://discuss.elastic.co/t/kibana-deprecation-issues-source-configuration-field-host-name-is-deprecated/299997 "2022-03-24T10:44:03Z")

</div>

Hi all, I am trying to prepare to upgrade my elastic cluster to 8.1. On the Upgrade Assistant tab i've fixed most of the issue but then there is an issue that said: Source configuration field "host name" is deprecated.…

---

## [Why does a kibana lens pretend my fields have no data, when they clearly do?](https://discuss.elastic.co/t/why-does-a-kibana-lens-pretend-my-fields-have-no-data-when-they-clearly-do/300506)

<div class="topic-metadata">

**Author:** [@gcanyon](https://discuss.elastic.co/u/gcanyon)\
**Replies:** 9\
**Last updated:** [March 24, 2022, 10:43am UTC](https://discuss.elastic.co/t/why-does-a-kibana-lens-pretend-my-fields-have-no-data-when-they-clearly-do/300506 "2022-03-24T10:43:11Z")

</div>

I click on kibana I click on visualize I click on Create visualization I click on Lens The left column, under "Individual fields" says: "Looks like you don't have any data. Try extending the time range" I see that I am …

---

## [Kibana 8.0 is not starting up- it says server not ready .. Looking at the logs it says Fatal Error unable to complete Saved Objects migrations](https://discuss.elastic.co/t/kibana-8-0-is-not-starting-up-it-says-server-not-ready-looking-at-the-logs-it-says-fatal-error-unable-to-complete-saved-objects-migrations/300526)

<div class="topic-metadata">

**Author:** [@AKAM14](https://discuss.elastic.co/u/AKAM14)\
**Replies:** 1\
**Last updated:** [March 24, 2022, 7:22am UTC](https://discuss.elastic.co/t/kibana-8-0-is-not-starting-up-it-says-server-not-ready-looking-at-the-logs-it-says-fatal-error-unable-to-complete-saved-objects-migrations/300526 "2022-03-24T07:22:30Z")

</div>

\[2022-03-24T07:14:44.988+00:00\]\[INFO \]\[savedobjects-service\] Waiting until all Elasticsearch nodes are compatible with Kibana before starting saved objects migrations... \[2022-03-24T07:14:44.990+00:00\]\[INFO \]\[savedobjec…

---

## [Show only duplicate documents data table](https://discuss.elastic.co/t/show-only-duplicate-documents-data-table/300328)

<div class="topic-metadata">

**Author:** [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 4:05pm UTC](https://discuss.elastic.co/t/show-only-duplicate-documents-data-table/300328 "2022-03-23T16:05:07Z")

</div>

Hi all, I'm trying to show only duplicate data table for a set of documents. So I want to show count of records \> 1. But I can't filter to show metric as count \> 1. How to show only duplicates data table with fields? …

---

## [Revit Event / Timestamp field problem](https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341)

<div class="topic-metadata">

**Author:** [@bailarch](https://discuss.elastic.co/u/bailarch)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 3:57pm UTC](https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341 "2022-03-23T15:57:15Z")

</div>

Hello, Not sure if anyone is familiar with Revit but I have a problem with '@timestamp' field from Revit Event. Basically I want to see all the projects that have been opened during past 7 days and I did set my Dev too…

---

## [Kibana cannot authenticate with Elasticsearch, stuck in "Kibana server is not ready yet" phase](https://discuss.elastic.co/t/kibana-cannot-authenticate-with-elasticsearch-stuck-in-kibana-server-is-not-ready-yet-phase/300397)

<div class="topic-metadata">

**Author:** [@pritster5](https://discuss.elastic.co/u/pritster5)\
**Replies:** 2\
**Last updated:** [March 23, 2022, 3:27pm UTC](https://discuss.elastic.co/t/kibana-cannot-authenticate-with-elasticsearch-stuck-in-kibana-server-is-not-ready-yet-phase/300397 "2022-03-23T15:27:43Z")

</div>

Quick rundown of what led to my current issue: Index filled EC2 completely, manually deleted nodes, no longer able to start Elasticsearch After wiping the node (i.e Deleting everything inside the /var/lib/elasticsearch …

---

## [Alerting in Kibana : formatting for dates](https://discuss.elastic.co/t/alerting-in-kibana-formatting-for-dates/300470)

<div class="topic-metadata">

**Author:** [@agaucher](https://discuss.elastic.co/u/agaucher)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 2:27pm UTC](https://discuss.elastic.co/t/alerting-in-kibana-formatting-for-dates/300470 "2022-03-23T14:27:44Z")

</div>

Hello, I use the alerting rules that are directly available in Kibana (i don't use "Watcher"). As action, I send an email and i put the field {{context.hits.0.\_source.inventoryDate}} in the body. It works well, but the…

---

## [Aggregation bucket for 1 Million documents in Kibana](https://discuss.elastic.co/t/aggregation-bucket-for-1-million-documents-in-kibana/300420)

<div class="topic-metadata">

**Author:** [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 1:34pm UTC](https://discuss.elastic.co/t/aggregation-bucket-for-1-million-documents-in-kibana/300420 "2022-03-23T13:34:43Z")

</div>

Hi all, I have to process 1M records and download 1M records. So is it practical to use a bucket size of 1Million so that when i download CSV report , it must have 1 Million documents? Or is there another approach for…

---

## [Where are timelion visualizations saved?](https://discuss.elastic.co/t/where-are-timelion-visualizations-saved/300387)

<div class="topic-metadata">

**Author:** [@fcarrasco](https://discuss.elastic.co/u/fcarrasco)\
**Replies:** 2\
**Last updated:** [March 23, 2022, 1:22pm UTC](https://discuss.elastic.co/t/where-are-timelion-visualizations-saved/300387 "2022-03-23T13:22:39Z")

</div>

Hi we have Elasticsearch 7.16.3 Platinum, we create 35 viz in timelion but we need change name of index. Where are timelion visualizations saved? In any system index? Anybody have script to update index name? Any ap…

---

## [Communicate between elk and nagios](https://discuss.elastic.co/t/communicate-between-elk-and-nagios/300439)

<div class="topic-metadata">

**Author:** [@nour41\_nour41](https://discuss.elastic.co/u/nour41_nour41)\
**Replies:** 5\
**Last updated:** [March 23, 2022, 12:21pm UTC](https://discuss.elastic.co/t/communicate-between-elk-and-nagios/300439 "2022-03-23T12:21:29Z")

</div>

how to communicate between elk and nagios

---

## [Kibana server is not ready](https://discuss.elastic.co/t/kibana-server-is-not-ready/300432)

<div class="topic-metadata">

**Author:** [@tharunkumar](https://discuss.elastic.co/u/tharunkumar)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 10:06am UTC](https://discuss.elastic.co/t/kibana-server-is-not-ready/300432 "2022-03-23T10:06:55Z")

</div>

Hi i am using kibana 7.12.0. i am facing this issue frequently.can please help me with a solution \[ FATAL Error: Unable to complete saved object migrations for the \[.kibana\] index. Please check the health of your El…

---

## [\[KIBANA\] Customize the result of a metric in a Data Table Aggregation](https://discuss.elastic.co/t/kibana-customize-the-result-of-a-metric-in-a-data-table-aggregation/298311)

<div class="topic-metadata">

**Author:** [@Sisiniya](https://discuss.elastic.co/u/Sisiniya)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 7:39am UTC](https://discuss.elastic.co/t/kibana-customize-the-result-of-a-metric-in-a-data-table-aggregation/298311 "2022-03-23T07:39:59Z")

</div>

Hello, In my application, each action generates a series of logs. For example : First suite of logs for the same value of data1/data2/data3 : {data1: "val1", data2: "val2", data3: "val3", level: "INFO", level\_value: 2…

---

## [FATAL Error: \[config validation of \[xpack.security\].enabled\]: definition for this key is missing](https://discuss.elastic.co/t/fatal-error-config-validation-of-xpack-security-enabled-definition-for-this-key-is-missing/300396)

<div class="topic-metadata">

**Author:** [@INS](https://discuss.elastic.co/u/INS)\
**Replies:** 1\
**Last updated:** [March 23, 2022, 3:07am UTC](https://discuss.elastic.co/t/fatal-error-config-validation-of-xpack-security-enabled-definition-for-this-key-is-missing/300396 "2022-03-23T03:07:47Z")

</div>

Hi Today I've install kibana 8.1.1 on docker and I'm facing this case with FATAL Error: \[config validation of \[xpack.security\].enabled\]: definition for this key is missing what's wrong with config??? version: '3.3'…

---

## [Role 'reporting\_user' is deprecated. Please use Kibana feature privileges instead](https://discuss.elastic.co/t/role-reporting-user-is-deprecated-please-use-kibana-feature-privileges-instead/294593)

<div class="topic-metadata">

**Author:** [@jsteenkamp](https://discuss.elastic.co/u/jsteenkamp)\
**Replies:** 8\
**Last updated:** [March 22, 2022, 8:38pm UTC](https://discuss.elastic.co/t/role-reporting-user-is-deprecated-please-use-kibana-feature-privileges-instead/294593 "2022-03-22T20:38:19Z")

</div>

latest version 7.16.3 (forever free edition) management \> users How do I grant users reporting permissions without using the deprecated reporting\_user in the forever free edition that does not support sub-featu…

---

## [Cummulative date sum in Kibana Console](https://discuss.elastic.co/t/cummulative-date-sum-in-kibana-console/300315)

<div class="topic-metadata">

**Author:** [@The-morpho](https://discuss.elastic.co/u/The-morpho)\
**Replies:** 1\
**Last updated:** [March 22, 2022, 2:04pm UTC](https://discuss.elastic.co/t/cummulative-date-sum-in-kibana-console/300315 "2022-03-22T14:04:49Z")

</div>

I'm working with a log file,I have a field for timestamp ==\> "timestamp":"2021-12-15T16:06:27.269303Z". I want to perform a cummulative sum on this field in all the document. I have done this aggregation, but the resul…

---

## [Unable to see ESquery while creating Rules and Connectors](https://discuss.elastic.co/t/unable-to-see-esquery-while-creating-rules-and-connectors/300195)

<div class="topic-metadata">

**Author:** [@Ankur\_Jain1](https://discuss.elastic.co/u/Ankur_Jain1)\
**Replies:** 1\
**Last updated:** [March 22, 2022, 12:54pm UTC](https://discuss.elastic.co/t/unable-to-see-esquery-while-creating-rules-and-connectors/300195 "2022-03-22T12:54:30Z")

</div>

Hello, I have created a user in Kibana with some limited permissions. When I am trying to create Rules using that user I cannot see ESquery option. This option is available for superuser account. The user role have fol…

---

## [Visualization of requirement fulfillment during release tests](https://discuss.elastic.co/t/visualization-of-requirement-fulfillment-during-release-tests/300296)

<div class="topic-metadata">

**Author:** [@nikaes](https://discuss.elastic.co/u/nikaes)\
**Replies:** 0\
**Last updated:** [March 22, 2022, 8:26am UTC](https://discuss.elastic.co/t/visualization-of-requirement-fulfillment-during-release-tests/300296 "2022-03-22T08:26:58Z")

</div>

Hi All, I am quite new to Kibana and having some trouble in visualization of a use case. I would like to show a percentage how much of a Requirement is currently covered by tests. Simply I am feeding Elastic with fol…

---

## [Data extraction, Watcher - CSV export with relative time period](https://discuss.elastic.co/t/data-extraction-watcher-csv-export-with-relative-time-period/300287)

<div class="topic-metadata">

**Author:** [@AQ\_Amra](https://discuss.elastic.co/u/AQ_Amra)\
**Replies:** 0\
**Last updated:** [March 22, 2022, 7:54am UTC](https://discuss.elastic.co/t/data-extraction-watcher-csv-export-with-relative-time-period/300287 "2022-03-22T07:54:42Z")

</div>

Hi, I am attempting to extract a CSV of data from ES/Kibana every hour. I've configured a watcher task which runs hourly, and emails a CSV file (based on the discover POST URL form here Automatically generate reports |…

---

## [It was found that users could not generate a report CSV or download logs from the dashboard](https://discuss.elastic.co/t/it-was-found-that-users-could-not-generate-a-report-csv-or-download-logs-from-the-dashboard/298174)

<div class="topic-metadata">

**Author:** [@Bhanuji\_paluri](https://discuss.elastic.co/u/Bhanuji_paluri)\
**Replies:** 2\
**Last updated:** [March 22, 2022, 7:53am UTC](https://discuss.elastic.co/t/it-was-found-that-users-could-not-generate-a-report-csv-or-download-logs-from-the-dashboard/298174 "2022-03-22T07:53:25Z")

</div>

HI Team, It was found that users could not generate a report CSV or download logs from the dashboard, teps to Reproduce Search for logs in Kibana Discover dashboard Attempt to download those logs: Click 'Save' to s…

---

## [Kibana start fail with the error \[ERROR\]\[savedobjects-service\] \[.kibana\_task\_manager\] Action failed with 'security\_exception](https://discuss.elastic.co/t/kibana-start-fail-with-the-error-error-savedobjects-service-kibana-task-manager-action-failed-with-security-exception/300286)

<div class="topic-metadata">

**Author:** [@jack\_jack](https://discuss.elastic.co/u/jack_jack)\
**Replies:** 0\
**Last updated:** [March 22, 2022, 7:48am UTC](https://discuss.elastic.co/t/kibana-start-fail-with-the-error-error-savedobjects-service-kibana-task-manager-action-failed-with-security-exception/300286 "2022-03-22T07:48:09Z")

</div>

when i start kibana ,i get the error \[2022-03-22T07:38:57.371+00:00\]\[INFO \]\[savedobjects-service\] \[.kibana\] UPDATE\_TARGET\_MAPPINGS -\> UPDATE\_TARGET\_MAPPINGS. took: 32015ms. \[2022-03-22T07:38:57.372+00:00\]\[ERROR\]\[savedob…

---

## [Kibana 7.5.2 to 7.17.0 Migration Failure - Migration of Saved Objects Failure](https://discuss.elastic.co/t/kibana-7-5-2-to-7-17-0-migration-failure-migration-of-saved-objects-failure/300126)

<div class="topic-metadata">

**Author:** [@anburethy](https://discuss.elastic.co/u/anburethy)\
**Replies:** 3\
**Last updated:** [March 21, 2022, 11:40pm UTC](https://discuss.elastic.co/t/kibana-7-5-2-to-7-17-0-migration-failure-migration-of-saved-objects-failure/300126 "2022-03-21T23:40:39Z")

</div>

Hi, I am migrating Kibana from 7.5.2 to 7.17.0 and getting the following error when doing so. Kibana isnt starting up due to this failure and hence migration fails. {"type":"log","@timestamp":"2022-03-20T12:32:03+00:00"…

---

## [How create a visualization with the last date of document](https://discuss.elastic.co/t/how-create-a-visualization-with-the-last-date-of-document/299938)

<div class="topic-metadata">

**Author:** [@David\_Oceans](https://discuss.elastic.co/u/David_Oceans)\
**Replies:** 1\
**Last updated:** [March 21, 2022, 1:01pm UTC](https://discuss.elastic.co/t/how-create-a-visualization-with-the-last-date-of-document/299938 "2022-03-21T13:01:01Z")

</div>

Hi, I would like create a dashboard / visualization with the timestamp of even better with the days from the first document in my indexes, like that Option A) First document found 13-03-2022 10:00 Option B) Retenti…

---

## [How to convert null value and empty value to "-"](https://discuss.elastic.co/t/how-to-convert-null-value-and-empty-value-to/300157)

<div class="topic-metadata">

**Author:** [@vuhai\_fo4](https://discuss.elastic.co/u/vuhai_fo4)\
**Replies:** 1\
**Last updated:** [March 21, 2022, 12:46pm UTC](https://discuss.elastic.co/t/how-to-convert-null-value-and-empty-value-to/300157 "2022-03-21T12:46:08Z")

</div>

In my dashboard, I have many data empty value and null value. I want to change them to "-". Please recommend to me some solution for this case

---

## [Kibana Dashboard PDF and PNG reporting options missing](https://discuss.elastic.co/t/kibana-dashboard-pdf-and-png-reporting-options-missing/300167)

<div class="topic-metadata">

**Author:** [@Petteri](https://discuss.elastic.co/u/Petteri)\
**Replies:** 1\
**Last updated:** [March 21, 2022, 12:45pm UTC](https://discuss.elastic.co/t/kibana-dashboard-pdf-and-png-reporting-options-missing/300167 "2022-03-21T12:45:59Z")

</div>

FYI. The original problem Kibana Dashboard PDF and PNG reporting options missing is due to an bug in elastic code: \[Reporting\] Application Privileges for PNG/PDF exports incorrectly require platinum license · Issue #127…

---

## [Migration from scripted to runtime field](https://discuss.elastic.co/t/migration-from-scripted-to-runtime-field/299484)

<div class="topic-metadata">

**Author:** [@rugenl](https://discuss.elastic.co/u/rugenl)\
**Replies:** 1\
**Last updated:** [March 21, 2022, 12:37pm UTC](https://discuss.elastic.co/t/migration-from-scripted-to-runtime-field/299484 "2022-03-21T12:37:36Z")

</div>

We have a scripted field, for example winlogbeat.user\_data.mysf (my snowflake). I guess we are forced to move this to a runtime field, they were deprecated in 7.13, but I'm not sure when they really quit working. My w…

---

## [New visualization plugin with inputs](https://discuss.elastic.co/t/new-visualization-plugin-with-inputs/299616)

<div class="topic-metadata">

**Author:** [@H1gH](https://discuss.elastic.co/u/H1gH)\
**Replies:** 1\
**Last updated:** [March 21, 2022, 12:29pm UTC](https://discuss.elastic.co/t/new-visualization-plugin-with-inputs/299616 "2022-03-21T12:29:08Z")

</div>

Hello, I want to create a new plugin which will make a POST request to an API and will show the response in the view. I created my input using Eui forms \<EuiFlexItem\> \<EuiFieldSearch placeholder="Search.…

---

## [Unable to retrieve version information from Elasticsearch nodes. Kibana v8 MacOS local machine setup](https://discuss.elastic.co/t/unable-to-retrieve-version-information-from-elasticsearch-nodes-kibana-v8-macos-local-machine-setup/300199)

<div class="topic-metadata">

**Author:** [@Gowrishankar\_G](https://discuss.elastic.co/u/Gowrishankar_G)\
**Replies:** 0\
**Last updated:** [March 21, 2022, 11:30am UTC](https://discuss.elastic.co/t/unable-to-retrieve-version-information-from-elasticsearch-nodes-kibana-v8-macos-local-machine-setup/300199 "2022-03-21T11:30:55Z")

</div>

\[ERROR\]\[Elasticsearch-service\] Unable to retrieve version information from Elasticsearch nodes. connect ECONNREFUSED 192.168.1.6:9200 \[ERROR\]\[plugins.ruleRegistry\] Error: Timeout: it took more than 1200000ms \[ERROR\]\[pl…

---

## [Kibana error : "Failed to poll for work: Error: work has timed out"](https://discuss.elastic.co/t/kibana-error-failed-to-poll-for-work-error-work-has-timed-out/300172)

<div class="topic-metadata">

**Author:** [@rodri.gz](https://discuss.elastic.co/u/rodri.gz)\
**Replies:** 0\
**Last updated:** [March 21, 2022, 8:59am UTC](https://discuss.elastic.co/t/kibana-error-failed-to-poll-for-work-error-work-has-timed-out/300172 "2022-03-21T08:59:31Z")

</div>

Hello! I'm repeatedly getting this kind of errors in kibana which I think are hurting the performance. {"type":"log","@timestamp":"2022-03-17T09:14:21+01:00","tags":\["error","plugins","taskManager"\],"pid":96071,"messag…

---

## [Beautify email sent from watcher](https://discuss.elastic.co/t/beautify-email-sent-from-watcher/300080)

<div class="topic-metadata">

**Author:** [@jhanvi](https://discuss.elastic.co/u/jhanvi)\
**Replies:** 1\
**Last updated:** [March 21, 2022, 8:06am UTC](https://discuss.elastic.co/t/beautify-email-sent-from-watcher/300080 "2022-03-21T08:06:03Z")

</div>

Hi, I have a watcher that generates pdf and emails. I want to use formatting for the email body, can someone help on how that can be done? Formatting like making the text bold, italic, and email in the signature clicka…

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

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