# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=230 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 231 --- ## [Need help with Kibana Visual](https://discuss.elastic.co/t/need-help-with-kibana-visual/298224)
**Author:** [@mohitspacee](https://discuss.elastic.co/u/mohitspacee)\ **Replies:** 1\ **Last updated:** [March 16, 2022, 2:50pm UTC](https://discuss.elastic.co/t/need-help-with-kibana-visual/298224 "2022-03-16T14:50:41Z")
Hello! I am trying to set up a simple Kibana line chart with these conditions - I'm trying to set up a Power vs Timestamp chart. In elastic, I have the metrics Current and Voltage. I'll calculate the Power from that. P… --- ## [\[Kibana\]Data from Multiple Tables MySQL](https://discuss.elastic.co/t/kibana-data-from-multiple-tables-mysql/299867)
**Author:** [@legolas\_bilbao](https://discuss.elastic.co/u/legolas_bilbao)\ **Replies:** 0\ **Last updated:** [March 16, 2022, 2:23pm UTC](https://discuss.elastic.co/t/kibana-data-from-multiple-tables-mysql/299867 "2022-03-16T14:23:49Z")
Good morning, I've several tables assets (hostname, idos,oss, lastview) rules( idrule,idos,value) compliance(idrule,idos,date,valueserver) and i wanna make / visualice tables like this Assets OSSS Date1 Date2 Date3… --- ## [Canvas Expression Syntax NewLine & Comments](https://discuss.elastic.co/t/canvas-expression-syntax-newline-comments/299796)
**Author:** [@GoncaloCarvalho](https://discuss.elastic.co/u/GoncaloCarvalho)\ **Replies:** 1\ **Last updated:** [March 16, 2022, 1:59pm UTC](https://discuss.elastic.co/t/canvas-expression-syntax-newline-comments/299796 "2022-03-16T13:59:34Z")
Greetings, I need help with two specific features, would greatly appreciate any help you could hand me. I'm setting up a canvas Workpad and I wanted to add some sort of documentation through comments in my code, so oth… --- ## [How to generate /Fetch report in pdf or excel for APM logs, transection data from Kibana](https://discuss.elastic.co/t/how-to-generate-fetch-report-in-pdf-or-excel-for-apm-logs-transection-data-from-kibana/299865)
**Author:** [@Sharma3007](https://discuss.elastic.co/u/Sharma3007)\ **Replies:** 0\ **Last updated:** [March 16, 2022, 1:56pm UTC](https://discuss.elastic.co/t/how-to-generate-fetch-report-in-pdf-or-excel-for-apm-logs-transection-data-from-kibana/299865 "2022-03-16T13:56:17Z")
Hi Team, We are successfully able to configure APM transection log in Kibana & we are able to see all the APM logs related information on Kibana. But our requirement is to export all those logs in one excel or pdf rep… --- ## [Login loop and error 401 on /api/licensing/info](https://discuss.elastic.co/t/login-loop-and-error-401-on-api-licensing-info/298933)
**Author:** [@ETspielberg](https://discuss.elastic.co/u/ETspielberg)\ **Replies:** 1\ **Last updated:** [March 16, 2022, 10:44am UTC](https://discuss.elastic.co/t/login-loop-and-error-401-on-api-licensing-info/298933 "2022-03-16T10:44:53Z")
Hi everyone, I have a strange problem with kibana, which I cannot figure out. It is similar to a number of topics here (e.g. https://discuss.elastic.co/t/http-error-401-on-api-licensing-info/281542, https://discuss.elas… --- ## [Kibana lens visualization is very slow](https://discuss.elastic.co/t/kibana-lens-visualization-is-very-slow/299198)
**Author:** [@notgurev](https://discuss.elastic.co/u/notgurev)\ **Replies:** 10\ **Last updated:** [March 16, 2022, 9:45am UTC](https://discuss.elastic.co/t/kibana-lens-visualization-is-very-slow/299198 "2022-03-16T09:45:25Z")
I have a cluster consisting of 1 hot (40 cores, 2 SSDs) and 2 cold nodes. I use a data stream to index a lot of data into 50gb one-shard indices with rollover, ILM, etc. Data is also sorted by @timestamp (asc) -- so I be… --- ## [Kibana Panel Filter](https://discuss.elastic.co/t/kibana-panel-filter/299468)
**Author:** [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)\ **Replies:** 1\ **Last updated:** [March 16, 2022, 8:25am UTC](https://discuss.elastic.co/t/kibana-panel-filter/299468 "2022-03-16T08:25:33Z")
Hello All, Can some tell me how can this can be achieved,just show all CPU ,Memory,Diskusage ,Process Memory etc with host name that are critical based on threshhold.Currently I am able to achieve this but issue is some… --- ## [Your browser does not meet the security requirements for kibana?](https://discuss.elastic.co/t/your-browser-does-not-meet-the-security-requirements-for-kibana/299813)
**Author:** [@pinehk](https://discuss.elastic.co/u/pinehk)\ **Replies:** 1\ **Last updated:** [March 16, 2022, 7:31am UTC](https://discuss.elastic.co/t/your-browser-does-not-meet-the-security-requirements-for-kibana/299813 "2022-03-16T07:31:30Z")
There is a small popup with the message "your browser does not meet the security requirements for kibana" everytime opening Kibana. From related posts it seems to be complaining a non-CSP compliant browser and especially… --- ## [Cannot add 10 or more rows to Visualize Library in table view in Kibana](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350)
**Author:** [@Stek\_new](https://discuss.elastic.co/u/Stek_new)\ **Replies:** 2\ **Last updated:** [March 16, 2022, 5:12am UTC](https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350 "2022-03-16T05:12:27Z")
Hello! I cannot add 10 or more rows to Visualize Library in table view in Kibana Steps on how to reproduce the issue: Go Dev Tools and run the following query: POST logs-my\_app-default/\_doc { "@timestamp": "2099-… --- ## [Kibana multi-line chart with legend help](https://discuss.elastic.co/t/kibana-multi-line-chart-with-legend-help/299769)
**Author:** [@Tingda\_Du](https://discuss.elastic.co/u/Tingda_Du)\ **Replies:** 2\ **Last updated:** [March 15, 2022, 9:38pm UTC](https://discuss.elastic.co/t/kibana-multi-line-chart-with-legend-help/299769 "2022-03-15T21:38:11Z")
I would like to draw a multi-line chart with legend from a query with format like the following: "aggregations": { "time\_buckets": { "buckets": \[ { "key\_as\_string": "2022-02-22T00:00:00.000… --- ## [Use elasticsearch requests in kibana (with double/tripple aggregation)](https://discuss.elastic.co/t/use-elasticsearch-requests-in-kibana-with-double-tripple-aggregation/299648)
**Author:** [@sebneu](https://discuss.elastic.co/u/sebneu)\ **Replies:** 2\ **Last updated:** [March 15, 2022, 4:10pm UTC](https://discuss.elastic.co/t/use-elasticsearch-requests-in-kibana-with-double-tripple-aggregation/299648 "2022-03-15T16:10:09Z")
Hi given: documents with a timestamp try: I have a working requests which first rounds the timestamps to 10 minutes (date\_histogram) and than sums up six 10 minute windows. (Rolling hour). here is the request: POST… --- ## [Different between view and edit mode on several vizualization](https://discuss.elastic.co/t/different-between-view-and-edit-mode-on-several-vizualization/299633)
**Author:** [@sylvain\_fr](https://discuss.elastic.co/u/sylvain_fr)\ **Replies:** 2\ **Last updated:** [March 15, 2022, 1:41pm UTC](https://discuss.elastic.co/t/different-between-view-and-edit-mode-on-several-vizualization/299633 "2022-03-15T13:41:07Z")
Hello, I build a dashboard about an internal website. An interesting vizualization is the purcentage of user-agent. So I created a bucket with user\_agent.name and count aggregation metrics. It's OK when i'm on edit mode… --- ## [How to delete all Docs count or remove the Storage Size and bring it to "Zero" for created index patterns in Kibana?](https://discuss.elastic.co/t/how-to-delete-all-docs-count-or-remove-the-storage-size-and-bring-it-to-zero-for-created-index-patterns-in-kibana/299598)
**Author:** [@hitnalli\_praveen](https://discuss.elastic.co/u/hitnalli_praveen)\ **Replies:** 4\ **Last updated:** [March 15, 2022, 12:31pm UTC](https://discuss.elastic.co/t/how-to-delete-all-docs-count-or-remove-the-storage-size-and-bring-it-to-zero-for-created-index-patterns-in-kibana/299598 "2022-03-15T12:31:04Z")
I've created an Index Pattern in Kibana - "cscsv212previousbuild-perfdata" and currently it has some content of Documents (seems to be total count of Docs 177193) and has the Storage Space - 661.9MB. I would like to del… --- ## [How to exclude repeating values while creating an Area Vizualization and using Unique Count?](https://discuss.elastic.co/t/how-to-exclude-repeating-values-while-creating-an-area-vizualization-and-using-unique-count/299718)
**Author:** [@iraidalavrovaa](https://discuss.elastic.co/u/iraidalavrovaa)\ **Replies:** 3\ **Last updated:** [March 15, 2022, 11:54am UTC](https://discuss.elastic.co/t/how-to-exclude-repeating-values-while-creating-an-area-vizualization-and-using-unique-count/299718 "2022-03-15T11:54:33Z")
Hi all! I want to visualize a trend of appearing of new users over time. Username is a text field. I decided to use Area Visualization with Cumulative Sum and Unique count of username aggregations. I specified it in Me… --- ## [How to get params date into fitler Kibana by scripted field?](https://discuss.elastic.co/t/how-to-get-params-date-into-fitler-kibana-by-scripted-field/299607)
**Author:** [@vuhai\_fo4](https://discuss.elastic.co/u/vuhai_fo4)\ **Replies:** 5\ **Last updated:** [March 15, 2022, 8:48am UTC](https://discuss.elastic.co/t/how-to-get-params-date-into-fitler-kibana-by-scripted-field/299607 "2022-03-15T08:48:06Z")
I have a filter date in dashboard Kibana and I need get param end date in this filter by scripted field. Please support me if you can! --- ## [How to fix this data ingesting data from mysql to filebeat to kafka to elastic?](https://discuss.elastic.co/t/how-to-fix-this-data-ingesting-data-from-mysql-to-filebeat-to-kafka-to-elastic/299681)
**Author:** [@leyleynewt](https://discuss.elastic.co/u/leyleynewt)\ **Replies:** 0\ **Last updated:** [March 15, 2022, 5:57am UTC](https://discuss.elastic.co/t/how-to-fix-this-data-ingesting-data-from-mysql-to-filebeat-to-kafka-to-elastic/299681 "2022-03-15T05:57:39Z")
Data are encrypted and now can't ingest to kafka. Dev Console: CLI Kafka Thank you in advance! --- ## [Can Kibana monitor two indexes at the same time?](https://discuss.elastic.co/t/can-kibana-monitor-two-indexes-at-the-same-time/299655)
**Author:** [@Michael\_Santos](https://discuss.elastic.co/u/Michael_Santos)\ **Replies:** 1\ **Last updated:** [March 14, 2022, 9:48pm UTC](https://discuss.elastic.co/t/can-kibana-monitor-two-indexes-at-the-same-time/299655 "2022-03-14T21:48:44Z")
I am curios if Kibana can monitor two indexes at the same time in the Alerting section. Like in the image below. I declared two indexes, so does that mean it monitors the documents in both indexes ? --- ## [Index lifecycle error - illegal\_argument\_exception:index name does not match pattern '^.\*-\\d+$' -Use Retry But Getting same error after sometime](https://discuss.elastic.co/t/index-lifecycle-error-illegal-argument-exception-index-name-does-not-match-pattern-d-use-retry-but-getting-same-error-after-sometime/299660)
**Author:** [@musku](https://discuss.elastic.co/u/musku)\ **Replies:** 0\ **Last updated:** [March 14, 2022, 7:50pm UTC](https://discuss.elastic.co/t/index-lifecycle-error-illegal-argument-exception-index-name-does-not-match-pattern-d-use-retry-but-getting-same-error-after-sometime/299660 "2022-03-14T19:50:33Z")
Hi Team, I have created ilm , Template and alias respectively as i am getting illegal\_argument\_exception: index name \[rebalance\_index\_001\] does not match pattern '^.\*-\\d+$'. error. I have run retry ilm command . I don't… --- ## [Couldn't find any Elasticsearch data](https://discuss.elastic.co/t/couldnt-find-any-elasticsearch-data/299464)
**Author:** [@tilchl](https://discuss.elastic.co/u/tilchl)\ **Replies:** 3\ **Last updated:** [March 14, 2022, 4:24pm UTC](https://discuss.elastic.co/t/couldnt-find-any-elasticsearch-data/299464 "2022-03-14T16:24:48Z")
Im trying to create a new index pattern in Kibana but I get Couldn't find any Elasticsearch data elasticsearch::9200 returns: { "name" : "rechenmonster-es01", "cluster\_name" : "elasticsearch", "cluster\_uuid" : "S… --- ## [Display count of tomcat down -metric visualization](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477)
**Author:** [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 3:45pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477 "2022-03-14T15:45:44Z")
Trying to create a visulization in kibana that should only display no of tomcat which are down. I guess I'm using wrong aggregation and not getting exactly wht can help out here. ''''''''''''''''' logs: Filelds: 1)t… --- ## [System health based on multiple metrics](https://discuss.elastic.co/t/system-health-based-on-multiple-metrics/299531)
**Author:** [@Garry](https://discuss.elastic.co/u/Garry)\ **Replies:** 3\ **Last updated:** [March 14, 2022, 3:44pm UTC](https://discuss.elastic.co/t/system-health-based-on-multiple-metrics/299531 "2022-03-14T15:44:40Z")
I am looking to display the health of a system based on multiple metrics, e.g. cpu/memory/page load times via iis/uptime etc. So I have multiple beats and Elasticsearch ingesting multiple data points. Ideally I want to… --- ## [Deleting Kibana Index patterns and dependencies](https://discuss.elastic.co/t/deleting-kibana-index-patterns-and-dependencies/299111)
**Author:** [@nkuntla](https://discuss.elastic.co/u/nkuntla)\ **Replies:** 5\ **Last updated:** [March 14, 2022, 3:09pm UTC](https://discuss.elastic.co/t/deleting-kibana-index-patterns-and-dependencies/299111 "2022-03-14T15:09:52Z")
Trying to delete multiple index patterns in our kibana instance that are junk. Some questions related to this. Will deleting the index pattern delete dependent visualizations and dashboards? Will the delete fail if th… --- ## [Error when clone index](https://discuss.elastic.co/t/error-when-clone-index/299504)
**Author:** [@Muhammad\_Fhadli](https://discuss.elastic.co/u/Muhammad_Fhadli)\ **Replies:** 1\ **Last updated:** [March 14, 2022, 1:31pm UTC](https://discuss.elastic.co/t/error-when-clone-index/299504 "2022-03-14T13:31:08Z")
I want to clone my index, i have done what shown in this page to clone the index using this command. POST /my\_index/\_clone/my\_index\_clone I also tried to make the index read-only first with this command PUT /my\_index… --- ## [Pie chart - show last string value of two records with same ID](https://discuss.elastic.co/t/pie-chart-show-last-string-value-of-two-records-with-same-id/299614)
**Author:** [@Jakub\_Polcar](https://discuss.elastic.co/u/Jakub_Polcar)\ **Replies:** 0\ **Last updated:** [March 14, 2022, 12:22pm UTC](https://discuss.elastic.co/t/pie-chart-show-last-string-value-of-two-records-with-same-id/299614 "2022-03-14T12:22:15Z")
Hello, is there an option how to set up a pie chart to show count of last string values, but if there are two records with same ID, count only last one based on timestamp? Test records: record 1: ID: 123, variable: "v… --- ## [Dashboard Watcher URL](https://discuss.elastic.co/t/dashboard-watcher-url/299613)
**Author:** [@Angad\_Panesar1](https://discuss.elastic.co/u/Angad_Panesar1)\ **Replies:** 0\ **Last updated:** [March 14, 2022, 12:18pm UTC](https://discuss.elastic.co/t/dashboard-watcher-url/299613 "2022-03-14T12:18:27Z")
Hi Is there an option that can allow me to generate a dashboard PDF in landscape mode? When I printed it, it only prints it in A4 portrait mode. Also, in the post URL shown below. I want the watcher to automatically ge… --- ## [Hide field of document in Kibana](https://discuss.elastic.co/t/hide-field-of-document-in-kibana/299599)
**Author:** [@Voula\_Mikr](https://discuss.elastic.co/u/Voula_Mikr)\ **Replies:** 1\ **Last updated:** [March 14, 2022, 10:56am UTC](https://discuss.elastic.co/t/hide-field-of-document-in-kibana/299599 "2022-03-14T10:56:37Z")
Hi, We have made some dashboards in Kibana that also include the table with all the data of a specific index pattern. There is a new field ("hash") added in documents of some index patterns but we need to "hide" it in … --- ## [Can I create a Visualization from two different indices?](https://discuss.elastic.co/t/can-i-create-a-visualization-from-two-different-indices/299556)
**Author:** [@Blason](https://discuss.elastic.co/u/Blason)\ **Replies:** 3\ **Last updated:** [March 14, 2022, 3:06am UTC](https://discuss.elastic.co/t/can-i-create-a-visualization-from-two-different-indices/299556 "2022-03-14T03:06:50Z")
Hi Team, I wanted to plot a data in a table and need to pick up a fields from different indices. Can that be possible with Kibana? If not then any other alternatives you can think of? --- ## [How to curl this query to shell script](https://discuss.elastic.co/t/how-to-curl-this-query-to-shell-script/299292)
**Author:** [@leyleynewt](https://discuss.elastic.co/u/leyleynewt)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 2:30am UTC](https://discuss.elastic.co/t/how-to-curl-this-query-to-shell-script/299292 "2022-03-14T02:30:03Z")
I want to delete the 5 days old data of all my indexes. How to curl this query to shell script POST \_all/\_delete\_by\_query { "query": { "range": { "@timestamp": { "lte": "now-5d" } } } } Than… --- ## [How to convert KQL to curl command in bash](https://discuss.elastic.co/t/how-to-convert-kql-to-curl-command-in-bash/299207)
**Author:** [@leyleynewt](https://discuss.elastic.co/u/leyleynewt)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 2:26am UTC](https://discuss.elastic.co/t/how-to-convert-kql-to-curl-command-in-bash/299207 "2022-03-14T02:26:18Z")
How can I run this KQL in the bash command POST \_all/\_delete\_by\_query { "query": { "range": { "@timestamp": { "lte": "now-5d" } } } } Thank you in advance! --- ## [Errors getting started with Kibana dev](https://discuss.elastic.co/t/errors-getting-started-with-kibana-dev/299335)
**Author:** [@drnw](https://discuss.elastic.co/u/drnw)\ **Replies:** 3\ **Last updated:** [March 12, 2022, 10:02am UTC](https://discuss.elastic.co/t/errors-getting-started-with-kibana-dev/299335 "2022-03-12T10:02:42Z")
I'm unsuccessful when following the guidance at Getting started | Kibana Guide \[master\] | Elastic I have tried with my MacBook and with a VM on Azure both end up with the same result. Kibana starts and visiting in the b… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=229) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=231)