# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=187 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 188 --- ## [How to iterate through aggregation buckets and send mail corresponding to each bucket using watcher action](https://discuss.elastic.co/t/how-to-iterate-through-aggregation-buckets-and-send-mail-corresponding-to-each-bucket-using-watcher-action/312474)
**Author:** [@bhavya](https://discuss.elastic.co/u/bhavya)\ **Replies:** 2\ **Last updated:** [August 19, 2022, 6:14pm UTC](https://discuss.elastic.co/t/how-to-iterate-through-aggregation-buckets-and-send-mail-corresponding-to-each-bucket-using-watcher-action/312474 "2022-08-19T18:14:12Z")
I am trying to iterate through the aggregation bucket results. The aggregation response is : "aggregations" : { "agg1" : { "doc\_count\_error\_upper\_bound" : 0, "sum\_other\_doc\_count" : 0, "buckets" : … --- ## [Rule status is always pending](https://discuss.elastic.co/t/rule-status-is-always-pending/312424)
**Author:** [@alexus](https://discuss.elastic.co/u/alexus)\ **Replies:** 6\ **Last updated:** [August 19, 2022, 4:11pm UTC](https://discuss.elastic.co/t/rule-status-is-always-pending/312424 "2022-08-19T16:11:51Z")
Hello World! Via Kibana -\> Management -\> Alerts and Insights -\> Rules and Connectors - all of my rules status is always Pending. per Get Alerting framework health API | Kibana Guide \[7.17\] | Elastic GET /api/alerting… --- ## [Line graph with split by chart is not drawing all data points](https://discuss.elastic.co/t/line-graph-with-split-by-chart-is-not-drawing-all-data-points/312484)
**Author:** [@lachlann562](https://discuss.elastic.co/u/lachlann562)\ **Replies:** 0\ **Last updated:** [August 19, 2022, 3:50pm UTC](https://discuss.elastic.co/t/line-graph-with-split-by-chart-is-not-drawing-all-data-points/312484 "2022-08-19T15:50:46Z")
I have created a line graph that shows the response time of our webservice in categories of 2-4 sec, 4-8, 8-16,16-32,32-64, 64+ seconds. We have set the visualization to split the chart by server so its easy to see which… --- ## [Kibana \<---\> Elasticsearch integration with SSL enable](https://discuss.elastic.co/t/kibana-elasticsearch-integration-with-ssl-enable/312298)
**Author:** [@Diego\_Lopes\_Penna](https://discuss.elastic.co/u/Diego_Lopes_Penna)\ **Replies:** 5\ **Last updated:** [August 19, 2022, 2:07pm UTC](https://discuss.elastic.co/t/kibana-elasticsearch-integration-with-ssl-enable/312298 "2022-08-19T14:07:00Z")
Hello, I've tried to find a solution for this on this forum but I was not able to find a solution that solves the problem. I'm trying to configure a Kibana/Elasticsearch integration. Each one of them is running on its … --- ## [Importing CoreSetup, CoreStart, etc](https://discuss.elastic.co/t/importing-coresetup-corestart-etc/312449)
**Author:** [@Sheereen](https://discuss.elastic.co/u/Sheereen)\ **Replies:** 0\ **Last updated:** [August 19, 2022, 9:31am UTC](https://discuss.elastic.co/t/importing-coresetup-corestart-etc/312449 "2022-08-19T09:31:18Z")
We have to import CoreSetup, CoreStart,.... from @kbn/core/server or ../../src/core/public I found importing libraries in the above 2 ways in different documents. Which one should I use? I am creating a plugin exte… --- ## [Kibana PagerDuty Connector - ability to select document field as DedupKey option](https://discuss.elastic.co/t/kibana-pagerduty-connector-ability-to-select-document-field-as-dedupkey-option/311530)
**Author:** [@sivanov](https://discuss.elastic.co/u/sivanov)\ **Replies:** 4\ **Last updated:** [August 19, 2022, 7:46am UTC](https://discuss.elastic.co/t/kibana-pagerduty-connector-ability-to-select-document-field-as-dedupkey-option/311530 "2022-08-19T07:46:55Z")
Hi, As part of PagerDuty integration, we would like to use a document field as a DedupKey field in the setup. I am struggling to find documentation that explains how to reach out, if possible at all, to document fields… --- ## [Filtering directly from data table - Kibana dashboard](https://discuss.elastic.co/t/filtering-directly-from-data-table-kibana-dashboard/312075)
**Author:** [@SaraAlshamsi](https://discuss.elastic.co/u/SaraAlshamsi)\ **Replies:** 3\ **Last updated:** [August 18, 2022, 6:03pm UTC](https://discuss.elastic.co/t/filtering-directly-from-data-table-kibana-dashboard/312075 "2022-08-18T18:03:57Z")
Hello, I have an issue in filtering directly from a data table in Kibana dashboard. Case 1: When I select an item, to filter it, from the first page of the table, I can filter without any problem and the filter is app… --- ## [Controls on Dashboards not showing all the options](https://discuss.elastic.co/t/controls-on-dashboards-not-showing-all-the-options/312115)
**Author:** [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\ **Replies:** 4\ **Last updated:** [August 18, 2022, 2:02pm UTC](https://discuss.elastic.co/t/controls-on-dashboards-not-showing-all-the-options/312115 "2022-08-18T14:02:33Z")
I've been trying to make use of the Controls in the Kibana Dashboards but it keeps eliminating some information. It's saying to change the configuration on Kibana.yml but I'm using the Elastic Cloud so I'm not sure what … --- ## [Is there something to Filter metrics on Lens?](https://discuss.elastic.co/t/is-there-something-to-filter-metrics-on-lens/312319)
**Author:** [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\ **Replies:** 1\ **Last updated:** [August 18, 2022, 1:54pm UTC](https://discuss.elastic.co/t/is-there-something-to-filter-metrics-on-lens/312319 "2022-08-18T13:54:22Z")
I've been exploring some data on Lens and got to the point where negative values ended up showing up on my data, I just want to pick the ones with "1" on it. I know that in canvas a simple "WHERE" would work but I don't … --- ## [Controlling Elasticsearch hidden indices .kibana\*](https://discuss.elastic.co/t/controlling-elasticsearch-hidden-indices-kibana/312391)
**Author:** [@Mark\_S](https://discuss.elastic.co/u/Mark_S)\ **Replies:** 0\ **Last updated:** [August 18, 2022, 1:31pm UTC](https://discuss.elastic.co/t/controlling-elasticsearch-hidden-indices-kibana/312391 "2022-08-18T13:31:24Z")
Elasticsearch hidden indices .kibana\_task\_manager and .kibana\_event\_logs are periodically updated. How to change this frequency? Maybe it is some index setting e.g. translog {sync\_interval : "5s"}, or maybe "refresh\_int… --- ## [What governs visibility of configured rules in Rules and Connectors tab?](https://discuss.elastic.co/t/what-governs-visibility-of-configured-rules-in-rules-and-connectors-tab/312297)
**Author:** [@Adriann](https://discuss.elastic.co/u/Adriann)\ **Replies:** 3\ **Last updated:** [August 18, 2022, 12:34pm UTC](https://discuss.elastic.co/t/what-governs-visibility-of-configured-rules-in-rules-and-connectors-tab/312297 "2022-08-18T12:34:03Z")
Hello, I wanted to allow low lvl user to see configured rules. The rules are configured in separated to user main dashboard so I had to start by adding rights to see the rules's dashboard. So I added the right to check … --- ## [Converting React JS website to Kibana plugin](https://discuss.elastic.co/t/converting-react-js-website-to-kibana-plugin/311793)
**Author:** [@Sheereen](https://discuss.elastic.co/u/Sheereen)\ **Replies:** 10\ **Last updated:** [August 18, 2022, 11:30am UTC](https://discuss.elastic.co/t/converting-react-js-website-to-kibana-plugin/311793 "2022-08-18T11:30:21Z")
I have developed a small dashboard and website in React JS. I want to insert it as a plugin into Kibana. I have some queries regarding the same. They are: Can I convert a website to a plugin? Or should I start coding … --- ## [Searching array for empty string causes tab lockup and shows garbage](https://discuss.elastic.co/t/searching-array-for-empty-string-causes-tab-lockup-and-shows-garbage/312149)
**Author:** [@nisow95612](https://discuss.elastic.co/u/nisow95612)\ **Replies:** 4\ **Last updated:** [August 18, 2022, 7:52am UTC](https://discuss.elastic.co/t/searching-array-for-empty-string-causes-tab-lockup-and-shows-garbage/312149 "2022-08-18T07:52:35Z")
Hello. I have a keyword field in elastic. I index arrays of string into it. I usually search with KQL like field: value and it works. But how I search for empty string? I tried field:, but that gives Search Error. … --- ## [Value Mapping in Kibana](https://discuss.elastic.co/t/value-mapping-in-kibana/311902)
**Author:** [@saif.khan](https://discuss.elastic.co/u/saif.khan)\ **Replies:** 17\ **Last updated:** [August 18, 2022, 6:52am UTC](https://discuss.elastic.co/t/value-mapping-in-kibana/311902 "2022-08-18T06:52:42Z")
Hi, I'm setting up a dashboard and receiving data from prometheus through metricbeat, I'm facing problem when it comes to value mapping, in my case for "DoorStatus" i want to map the default integer values in 0 and 1 to… --- ## [Value not greater 20% of the average value of the same job](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832)
**Author:** [@eddieyee](https://discuss.elastic.co/u/eddieyee)\ **Replies:** 2\ **Last updated:** [August 18, 2022, 6:23am UTC](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832 "2022-08-18T06:23:11Z")
Hi I'm trying to create a data table as seem in the screenshot below. Basically I need to compare the current document duration field value not higher than 20% of the average duration of the same job. Have tried using … --- ## [Transform is not created when a particular field is not available in the index](https://discuss.elastic.co/t/transform-is-not-created-when-a-particular-field-is-not-available-in-the-index/312214)
**Author:** [@Amol](https://discuss.elastic.co/u/Amol)\ **Replies:** 2\ **Last updated:** [August 18, 2022, 2:31am UTC](https://discuss.elastic.co/t/transform-is-not-created-when-a-particular-field-is-not-available-in-the-index/312214 "2022-08-18T02:31:14Z")
Hello Team, I'm trying to create a transform, it is creating the transform index, but when the particular (Year column) is blank or not available in the Data set document, that document is not index. Could any one help… --- ## [KQL to elastic query string](https://discuss.elastic.co/t/kql-to-elastic-query-string/312216)
**Author:** [@Drpkton](https://discuss.elastic.co/u/Drpkton)\ **Replies:** 0\ **Last updated:** [August 16, 2022, 7:30pm UTC](https://discuss.elastic.co/t/kql-to-elastic-query-string/312216 "2022-08-16T19:30:59Z")
When I perform a Kibana Query, ie, I know it is converted to a json blob which represents a valid elasticsearch json query, ie, { "version": true, "size": 500, "sort": \[ { "@timest… --- ## [Disable regex in Lucene search](https://discuss.elastic.co/t/disable-regex-in-lucene-search/311907)
**Author:** [@Leventi](https://discuss.elastic.co/u/Leventi)\ **Replies:** 2\ **Last updated:** [August 17, 2022, 9:03am UTC](https://discuss.elastic.co/t/disable-regex-in-lucene-search/311907 "2022-08-17T09:03:31Z")
Hi How I could disable regex in Lucene search? My problem is when I search something like that 32/22-ЕКТ I cant't find anything. It's working just when I write in quotes like this "32/22-ЕКТ" or 32/22-ЕКТ It's becaus… --- ## [How to upgrade node.js (from v10.23.1 to v16.13.2) in Kibana 7.10.2](https://discuss.elastic.co/t/how-to-upgrade-node-js-from-v10-23-1-to-v16-13-2-in-kibana-7-10-2/307409)
**Author:** [@mridul.tamuli](https://discuss.elastic.co/u/mridul.tamuli)\ **Replies:** 2\ **Last updated:** [August 17, 2022, 9:02am UTC](https://discuss.elastic.co/t/how-to-upgrade-node-js-from-v10-23-1-to-v16-13-2-in-kibana-7-10-2/307409 "2022-08-17T09:02:19Z")
Hi, We are using Kibana 7.10.2 with Elasticsearch of the same version. Currently we have a urgent need to upgrade the node.js version of Kibana to 16.13.2. We tried but unable to get the desired result. Is it possible t… --- ## [Ratio visualization](https://discuss.elastic.co/t/ratio-visualization/312257)
**Author:** [@Mikhail\_M](https://discuss.elastic.co/u/Mikhail_M)\ **Replies:** 0\ **Last updated:** [August 17, 2022, 8:23am UTC](https://discuss.elastic.co/t/ratio-visualization/312257 "2022-08-17T08:23:57Z")
Hello! Can you pls give a hint how to create this kind of timeserial visualization. Let's say I've got documents like this: doc1:(term = 'term1', value = 1) doc2:(term = 'term2', value = 2) doc3:(term = 'term3', valu… --- ## [Comparison of data between two time points](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172)
**Author:** [@RonGros](https://discuss.elastic.co/u/RonGros)\ **Replies:** 3\ **Last updated:** [August 17, 2022, 6:39am UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172 "2022-08-17T06:39:24Z")
Hi, I think the answer is "no can do" but I will ask anyhow in case I am missing something (and if I'm right it's surprising that I'm the only one to need it) We are monitoring results of tests on a daily basis. we have… --- ## [Elasticsearch snapshot for starting Kibana as a developer](https://discuss.elastic.co/t/elasticsearch-snapshot-for-starting-kibana-as-a-developer/312135)
**Author:** [@Sheereen](https://discuss.elastic.co/u/Sheereen)\ **Replies:** 3\ **Last updated:** [August 17, 2022, 5:56am UTC](https://discuss.elastic.co/t/elasticsearch-snapshot-for-starting-kibana-as-a-developer/312135 "2022-08-17T05:56:27Z")
To create a custom plugin, I 1. I cloned the kibana git hub repo 2. yarn kbn bootstrap ----\> was succesfull The next step as per the documentation, (Getting started | Kibana Guide \[master\] | Elastic) yarn es snapsh… --- ## [Starting Kibana as a developer](https://discuss.elastic.co/t/starting-kibana-as-a-developer/312138)
**Author:** [@Sheereen](https://discuss.elastic.co/u/Sheereen)\ **Replies:** 1\ **Last updated:** [August 17, 2022, 5:55am UTC](https://discuss.elastic.co/t/starting-kibana-as-a-developer/312138 "2022-08-17T05:55:44Z")
To create a custom plugin, I I cloned the kibana git hub repo yarn kbn bootstrap ----\> was successful Now to connect to Elasticsearch, I can either use Option: 1 yarn es snapshot -\> results in error (Elasticsearc… --- ## [Can't start fleet server](https://discuss.elastic.co/t/cant-start-fleet-server/312210)
**Author:** [@chaishiqi1](https://discuss.elastic.co/u/chaishiqi1)\ **Replies:** 2\ **Last updated:** [August 17, 2022, 1:45am UTC](https://discuss.elastic.co/t/cant-start-fleet-server/312210 "2022-08-17T01:45:13Z")
I want to start fleet server as the command generated by kibana. The CA files I have filled, but when execute this command, it failed with the information {"log.level":"info","@timestamp":"2022-08-16T18:32:24.… --- ## [Python and kibana](https://discuss.elastic.co/t/python-and-kibana/312212)
**Author:** [@5k\_pwc](https://discuss.elastic.co/u/5k_pwc)\ **Replies:** 1\ **Last updated:** [August 16, 2022, 10:27pm UTC](https://discuss.elastic.co/t/python-and-kibana/312212 "2022-08-16T22:27:27Z")
Hi all , as a beginner, I would like to know in what condition I use python and kibana together. --- ## [How to divide two doc\_count values in aggregations](https://discuss.elastic.co/t/how-to-divide-two-doc-count-values-in-aggregations/312035)
**Author:** [@Chandana\_P](https://discuss.elastic.co/u/Chandana_P)\ **Replies:** 5\ **Last updated:** [August 16, 2022, 10:26pm UTC](https://discuss.elastic.co/t/how-to-divide-two-doc-count-values-in-aggregations/312035 "2022-08-16T22:26:44Z")
I want to perform division between two doc\_count values of unique fields obtained through "terms" bucket aggregation. Is there a way to do that? --- ## [How to get first file and last file in data?](https://discuss.elastic.co/t/how-to-get-first-file-and-last-file-in-data/311945)
**Author:** [@MLsuper](https://discuss.elastic.co/u/MLsuper)\ **Replies:** 3\ **Last updated:** [August 16, 2022, 7:47pm UTC](https://discuss.elastic.co/t/how-to-get-first-file-and-last-file-in-data/311945 "2022-08-16T19:47:18Z")
I have a index pattern with data with files for every business day(i have a run time field named business time/day) which is the business day and time everyday. Now I want to show a visualization/dashboard to get the ba… --- ## [Splitting table based on text value](https://discuss.elastic.co/t/splitting-table-based-on-text-value/312208)
**Author:** [@Marius\_Kunauskas](https://discuss.elastic.co/u/Marius_Kunauskas)\ **Replies:** 1\ **Last updated:** [August 16, 2022, 6:37pm UTC](https://discuss.elastic.co/t/splitting-table-based-on-text-value/312208 "2022-08-16T18:37:16Z")
As a complete elastic-newbie, how could I split a column based on its text value? I.e. Instead of splitting rows on different Field values (e.g. country), I want to split it based on WHETHER a field starts with a certai… --- ## [Alerts on derivatives in elastic](https://discuss.elastic.co/t/alerts-on-derivatives-in-elastic/312170)
**Author:** [@Anmol\_Dubey](https://discuss.elastic.co/u/Anmol_Dubey)\ **Replies:** 1\ **Last updated:** [August 16, 2022, 4:03pm UTC](https://discuss.elastic.co/t/alerts-on-derivatives-in-elastic/312170 "2022-08-16T16:03:08Z")
I am trying to create an alert when average of my derivative data exceeds a threshold, but am not able to figure out how to do calculations on returned values in kibana Grafana graph of the data looks like this , i am t… --- ## [Kibana Table visualization for different weeks,showing reports for current date](https://discuss.elastic.co/t/kibana-table-visualization-for-different-weeks-showing-reports-for-current-date/311485)
**Author:** [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)\ **Replies:** 2\ **Last updated:** [August 16, 2022, 2:34pm UTC](https://discuss.elastic.co/t/kibana-table-visualization-for-different-weeks-showing-reports-for-current-date/311485 "2022-08-16T14:34:45Z")
Hello All, I'm not sure how this can be achieved through kibana table visualization,I want to display the converter details in accordance to week wise and the date displayed should always be current date. KW-calendar … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=186) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=188)