# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=219 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 220 --- ## [Importing and querying against a list](https://discuss.elastic.co/t/importing-and-querying-against-a-list/301896)
**Author:** [@chin1](https://discuss.elastic.co/u/chin1)\ **Replies:** 1\ **Last updated:** [April 28, 2022, 10:35am UTC](https://discuss.elastic.co/t/importing-and-querying-against-a-list/301896 "2022-04-28T10:35:09Z")
Hey, i'm trying to query against a large list, so apposed to copying and pasting data in KQL, and running something user: ("name","name2","name3") Is there away of importing that list and making it into a variable? the… --- ## [How to compare two aggregations (Apr 2022)](https://discuss.elastic.co/t/how-to-compare-two-aggregations-apr-2022/303480)
**Author:** [@jurisn](https://discuss.elastic.co/u/jurisn)\ **Replies:** 0\ **Last updated:** [April 28, 2022, 8:39am UTC](https://discuss.elastic.co/t/how-to-compare-two-aggregations-apr-2022/303480 "2022-04-28T08:39:24Z")
Three years ago I asked the question: How to compare two aggregations Hi, I have list for 24 hour period: PC1 PC2 PC3 PC4 I have list for 1 hour period: PC3 PC4 as result I will receive such list: PC1 PC2 Do… --- ## [Kibana dashboard with "message" filter as a user input](https://discuss.elastic.co/t/kibana-dashboard-with-message-filter-as-a-user-input/303408)
**Author:** [@melkamar](https://discuss.elastic.co/u/melkamar)\ **Replies:** 2\ **Last updated:** [April 28, 2022, 8:39am UTC](https://discuss.elastic.co/t/kibana-dashboard-with-message-filter-as-a-user-input/303408 "2022-04-28T08:39:32Z")
Hi! I am in the process of setting up Filebeat-based monitoring of our Kubernetes workloads' logs. For starters, I want to have a simple page where devs and PMs can go to to view the logs ingested from our deployments. I… --- ## [Kibana gauge visualization](https://discuss.elastic.co/t/kibana-gauge-visualization/303244)
**Author:** [@wagnar](https://discuss.elastic.co/u/wagnar)\ **Replies:** 2\ **Last updated:** [April 28, 2022, 8:25am UTC](https://discuss.elastic.co/t/kibana-gauge-visualization/303244 "2022-04-28T08:25:58Z")
I am trying to achieve one usecase, i want to see the sales per country vs targeted sales for that particular country with the help of guage chart. But I'm not able to see add the targeted value for each country. |Count… --- ## [Authenticate using google firebase](https://discuss.elastic.co/t/authenticate-using-google-firebase/303469)
**Author:** [@Krishna\_Teja](https://discuss.elastic.co/u/Krishna_Teja)\ **Replies:** 0\ **Last updated:** [April 28, 2022, 6:57am UTC](https://discuss.elastic.co/t/authenticate-using-google-firebase/303469 "2022-04-28T06:57:09Z")
Hi I am working on an app that needs user to login to kibana using GCP firebase as my application runs on GCP and users are already imported to firebase. I was considering to use SAML method. There are a few issues I ne… --- ## [Kibana HeatMap Layer not displaying](https://discuss.elastic.co/t/kibana-heatmap-layer-not-displaying/303288)
**Author:** [@Alessandro\_Agnello](https://discuss.elastic.co/u/Alessandro_Agnello)\ **Replies:** 4\ **Last updated:** [April 27, 2022, 10:55pm UTC](https://discuss.elastic.co/t/kibana-heatmap-layer-not-displaying/303288 "2022-04-27T22:55:49Z")
I have tried with version 8.1.2 and upgraded to 8.1.3, I cannot get any heat maps to work. I do have it working for Documents Layer type without any problems. Thanks --- ## [Elastalert-kibana plugin for kibana 6.8.23](https://discuss.elastic.co/t/elastalert-kibana-plugin-for-kibana-6-8-23/303006)
**Author:** [@Vishnu\_Vijay](https://discuss.elastic.co/u/Vishnu_Vijay)\ **Replies:** 1\ **Last updated:** [April 27, 2022, 11:58am UTC](https://discuss.elastic.co/t/elastalert-kibana-plugin-for-kibana-6-8-23/303006 "2022-04-27T11:58:24Z")
Hello, We have upgraded our kibana to 6.8.23. We require compatible elastalert plugin for connecting to our elastalert system. Please let us know, whether the elastalert plugin for kibana 6.8.23 is available --- ## [Geo-IP Map visualization](https://discuss.elastic.co/t/geo-ip-map-visualization/302914)
**Author:** [@Bo-Wyatt](https://discuss.elastic.co/u/Bo-Wyatt)\ **Replies:** 10\ **Last updated:** [April 27, 2022, 11:07am UTC](https://discuss.elastic.co/t/geo-ip-map-visualization/302914 "2022-04-27T11:07:03Z")
Hello, I have different fields with Geo-IP data: Latitude, Longitude, Country Code, Continent code and more. How can I build a map based on that? I've tried the "Create new Maps" option but all the visualization options … --- ## [Can I transform rows into columns or vice versa with the help of pivot transformation](https://discuss.elastic.co/t/can-i-transform-rows-into-columns-or-vice-versa-with-the-help-of-pivot-transformation/302617)
**Author:** [@sukhwinder\_kumar](https://discuss.elastic.co/u/sukhwinder_kumar)\ **Replies:** 3\ **Last updated:** [April 27, 2022, 10:46am UTC](https://discuss.elastic.co/t/can-i-transform-rows-into-columns-or-vice-versa-with-the-help-of-pivot-transformation/302617 "2022-04-27T10:46:40Z")
Can I transform rows into columns or vice versa with the help of pivot transformations or with the help of any other visualization. Attached image is my requirement: --- ## [Getting error while creating template in kibana 5.3](https://discuss.elastic.co/t/getting-error-while-creating-template-in-kibana-5-3/303289)
**Author:** [@mangeshmj1992](https://discuss.elastic.co/u/mangeshmj1992)\ **Replies:** 2\ **Last updated:** [April 27, 2022, 8:22am UTC](https://discuss.elastic.co/t/getting-error-while-creating-template-in-kibana-5-3/303289 "2022-04-27T08:22:16Z")
Hello team, I am using below query in kibana 5.3 to create template but getting below error: { "error": { "root\_cause": \[ { "type": "action\_request\_validation\_exception", "reason": "Validati… --- ## [Setup elastic fleet server with wildcard cert](https://discuss.elastic.co/t/setup-elastic-fleet-server-with-wildcard-cert/303301)
**Author:** [@philshilling](https://discuss.elastic.co/u/philshilling)\ **Replies:** 0\ **Last updated:** [April 26, 2022, 2:52pm UTC](https://discuss.elastic.co/t/setup-elastic-fleet-server-with-wildcard-cert/303301 "2022-04-26T14:52:35Z")
I've looked at the documentation and i'm unsure where to start to setup a fleet server using a custom wildcard certificate. I currently have the certificate in PFX format. Any suggestion, advice or how to guides would be… --- ## [How to join values from 2 different fields to one and manage it further?](https://discuss.elastic.co/t/how-to-join-values-from-2-different-fields-to-one-and-manage-it-further/303050)
**Author:** [@Stek\_new](https://discuss.elastic.co/u/Stek_new)\ **Replies:** 3\ **Last updated:** [April 26, 2022, 7:09pm UTC](https://discuss.elastic.co/t/how-to-join-values-from-2-different-fields-to-one-and-manage-it-further/303050 "2022-04-26T19:09:37Z")
Hello, I am curious if anybody faced the issue I have I have 5 documents with the following fields and values in table view: +++++++++++++++++++++++++++++++++ | src\_ch | tgt\_ch | extra\_field | ++++++++++++++++++++++++… --- ## [How to use match and term in DSL Query?](https://discuss.elastic.co/t/how-to-use-match-and-term-in-dsl-query/303248)
**Author:** [@Fosiul\_Alam](https://discuss.elastic.co/u/Fosiul_Alam)\ **Replies:** 5\ **Last updated:** [April 26, 2022, 2:47pm UTC](https://discuss.elastic.co/t/how-to-use-match-and-term-in-dsl-query/303248 "2022-04-26T14:47:57Z")
Hi, bellow query runs fine in older version of kibana 7.10.1, however same query does not work in 8.1.3, can any one please tell me what i need to change to make it work ? Thanks for the help GET \_search { "query"… --- ## [Update index pattern fields via Kibana REST API fails](https://discuss.elastic.co/t/update-index-pattern-fields-via-kibana-rest-api-fails/303035)
**Author:** [@mpjjonker](https://discuss.elastic.co/u/mpjjonker)\ **Replies:** 1\ **Last updated:** [April 26, 2022, 12:14pm UTC](https://discuss.elastic.co/t/update-index-pattern-fields-via-kibana-rest-api-fails/303035 "2022-04-26T12:14:30Z")
Hi We are using Kibana version 7.17. When I follow the instructions here (Update index pattern fields API | Kibana Guide \[7.17\] | Elastic) to update fields via the REST API , I get the error \[request.body.fields\]: de… --- ## [Metric value issue in Point to Point map](https://discuss.elastic.co/t/metric-value-issue-in-point-to-point-map/303146)
**Author:** [@ahmad\_amir](https://discuss.elastic.co/u/ahmad_amir)\ **Replies:** 3\ **Last updated:** [April 26, 2022, 10:16am UTC](https://discuss.elastic.co/t/metric-value-issue-in-point-to-point-map/303146 "2022-04-26T10:16:47Z")
Hi everyone! I am facing issue while showing metric value on a point to point map in Kibana. On point to point map the metric value is not displayed, however the value exists and can be seen in Kibana's index pattern. T… --- ## [Kibana server is not ready yet](https://discuss.elastic.co/t/kibana-server-is-not-ready-yet/303178)
**Author:** [@Achraf\_MENSI](https://discuss.elastic.co/u/Achraf_MENSI)\ **Replies:** 9\ **Last updated:** [April 26, 2022, 9:33am UTC](https://discuss.elastic.co/t/kibana-server-is-not-ready-yet/303178 "2022-04-26T09:33:25Z")
Hello , i depoyed a multi node cluster with 3 azure vm, the cluster worked on ES and nodes are connected. but i can't work on them with kibana " Kibana server is not ready yet " --- ## [Convert a search JSON into a DSL query](https://discuss.elastic.co/t/convert-a-search-json-into-a-dsl-query/303156)
**Author:** [@kelvins](https://discuss.elastic.co/u/kelvins)\ **Replies:** 1\ **Last updated:** [April 26, 2022, 9:19am UTC](https://discuss.elastic.co/t/convert-a-search-json-into-a-dsl-query/303156 "2022-04-26T09:19:22Z")
I have created the following search query in Elastic. I am wanting to using it in a Discover query using the Elasticsearch Query DSL. However, I cannot seem to convert it. This is the query that I have using Kibana D… --- ## [Hi All I am Getting this error in the kibana log from yesterday 25 April,2022. Version 8.1.2](https://discuss.elastic.co/t/hi-all-i-am-getting-this-error-in-the-kibana-log-from-yesterday-25-april-2022-version-8-1-2/303233)
**Author:** [@srikanth.tekula](https://discuss.elastic.co/u/srikanth.tekula)\ **Replies:** 0\ **Last updated:** [April 26, 2022, 8:15am UTC](https://discuss.elastic.co/t/hi-all-i-am-getting-this-error-in-the-kibana-log-from-yesterday-25-april-2022-version-8-1-2/303233 "2022-04-26T08:15:21Z")
Hi I have installed 8.1.2 version of Elasticsearch and kibana in centos-7 using this command in my AWS ec2 t2.medium instance : wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-$VERSION-x86\_64.rpm … --- ## [How to setup kibana 8.1 with Elastic Search 8.1under Windows](https://discuss.elastic.co/t/how-to-setup-kibana-8-1-with-elastic-search-8-1under-windows/301835)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 2\ **Last updated:** [April 26, 2022, 9:12am UTC](https://discuss.elastic.co/t/how-to-setup-kibana-8-1-with-elastic-search-8-1under-windows/301835 "2022-04-26T09:12:40Z")
Hi , we have installed Elasticsearch 8.1 windows version as a services , here localhost:9200 will be browse with user name and password . and we are not able to run Kibana , and its asking for to generate the Token, i… --- ## [Kbn webpack compile error and optimization failure](https://discuss.elastic.co/t/kbn-webpack-compile-error-and-optimization-failure/303226)
**Author:** [@HarryX](https://discuss.elastic.co/u/HarryX)\ **Replies:** 0\ **Last updated:** [April 26, 2022, 7:49am UTC](https://discuss.elastic.co/t/kbn-webpack-compile-error-and-optimization-failure/303226 "2022-04-26T07:49:27Z")
I'm on kibana 7.14.2 with wazuh plugin, I got these 2 errors when I started the server. I'm new to this platform please help me with these problems, thank you!!! Here is the log. np bld log \[15:25:12.105\] \[info\]\[@… --- ## [Server crashed with status code 1](https://discuss.elastic.co/t/server-crashed-with-status-code-1/303206)
**Author:** [@HarryX](https://discuss.elastic.co/u/HarryX)\ **Replies:** 11\ **Last updated:** [April 26, 2022, 7:34am UTC](https://discuss.elastic.co/t/server-crashed-with-status-code-1/303206 "2022-04-26T07:34:14Z")
I'm running kibana 7.14.2 on Linux from my localhost and with wazuh installed, however the server keep crashing after some time functioning properly. I have tried different approaches including limit the memory use from … --- ## [No ML nodes with sufficient capacity](https://discuss.elastic.co/t/no-ml-nodes-with-sufficient-capacity/303150)
**Author:** [@S-elk](https://discuss.elastic.co/u/S-elk)\ **Replies:** 2\ **Last updated:** [April 26, 2022, 7:27am UTC](https://discuss.elastic.co/t/no-ml-nodes-with-sufficient-capacity/303150 "2022-04-26T07:27:40Z")
Hello ! I am trying to create a job that handles a large amount of information and the recommended memory is 19 GB. I currently have 2 ml nodes with 64gb each. When executing the job with that memory, the following erro… --- ## [Can't use average agg on number lower than 1](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091)
**Author:** [@xxk](https://discuss.elastic.co/u/xxk)\ **Replies:** 5\ **Last updated:** [April 26, 2022, 7:07am UTC](https://discuss.elastic.co/t/cant-use-average-agg-on-number-lower-than-1/303091 "2022-04-26T07:07:48Z")
I have a field pctr which values are all between (0,1). But i can't use average agg on pctr in visualize --- ## [Anomaly Detection Categorization: Kibana Signs used for Severities(warning, minor, major, critical)](https://discuss.elastic.co/t/anomaly-detection-categorization-kibana-signs-used-for-severities-warning-minor-major-critical/303039)
**Author:** [@aviral\_srivastava](https://discuss.elastic.co/u/aviral_srivastava)\ **Replies:** 4\ **Last updated:** [April 26, 2022, 5:59am UTC](https://discuss.elastic.co/t/anomaly-detection-categorization-kibana-signs-used-for-severities-warning-minor-major-critical/303039 "2022-04-26T05:59:51Z")
Hi, I am using Elasticsearch 8.1.0 and kibana 8.1.0 I have created a Categorization job in kibana. As input, I have given the index field which contains the log messages. After the job gets completed processing, I can… --- ## [Help create ILM policy](https://discuss.elastic.co/t/help-create-ilm-policy/302876)
**Author:** [@vladislav](https://discuss.elastic.co/u/vladislav)\ **Replies:** 1\ **Last updated:** [April 26, 2022, 1:34am UTC](https://discuss.elastic.co/t/help-create-ilm-policy/302876 "2022-04-26T01:34:41Z")
Good day! Please advice! I have a couple of indices - filebeat-current and filebeat-old I need to create ILM policy, which will copy data that is more than 7 days old from filebeat-current to filebeat-old. New incoming… --- ## [Elastic Index is getting delete automatically without any policy configuration in Amazon opensearch service](https://discuss.elastic.co/t/elastic-index-is-getting-delete-automatically-without-any-policy-configuration-in-amazon-opensearch-service/303153)
**Author:** [@Mayur\_Jain2](https://discuss.elastic.co/u/Mayur_Jain2)\ **Replies:** 2\ **Last updated:** [April 26, 2022, 12:59am UTC](https://discuss.elastic.co/t/elastic-index-is-getting-delete-automatically-without-any-policy-configuration-in-amazon-opensearch-service/303153 "2022-04-26T00:59:28Z")
We have setup Elasticsearch engine in amazon open service. Some how multiple times around 60 days of gaps , all indexes got deleted automatically. We are not able to find any configuration or solution for preventing the … --- ## [Custom Plugin: New visualization toast showing "undefined" added](https://discuss.elastic.co/t/custom-plugin-new-visualization-toast-showing-undefined-added/302969)
**Author:** [@Gustavo\_Llermaly](https://discuss.elastic.co/u/Gustavo_Llermaly)\ **Replies:** 2\ **Last updated:** [April 25, 2022, 11:48pm UTC](https://discuss.elastic.co/t/custom-plugin-new-visualization-toast-showing-undefined-added/302969 "2022-04-25T23:48:07Z")
Hello, I'm creating a new visualization type, but when I add it to the dashboard , the toast shows "undefined" added. How can I set an initial value for this component to show it in the Toast? Thanks! --- ## [Using distinct state containers (global/local) for the same component](https://discuss.elastic.co/t/using-distinct-state-containers-global-local-for-the-same-component/303045)
**Author:** [@Specialist](https://discuss.elastic.co/u/Specialist)\ **Replies:** 1\ **Last updated:** [April 25, 2022, 11:28pm UTC](https://discuss.elastic.co/t/using-distinct-state-containers-global-local-for-the-same-component/303045 "2022-04-25T23:28:50Z")
Hi there, let's say I have a custom Kibana plugin that should access global (\_g) as well as application-specific state. To do so, have have created two state containers via createStateContainer from create\_state\_contain… --- ## [Watcher PDF reporting fails on dockerised 7.17.x](https://discuss.elastic.co/t/watcher-pdf-reporting-fails-on-dockerised-7-17-x/301572)
**Author:** [@cafuego](https://discuss.elastic.co/u/cafuego)\ **Replies:** 1\ **Last updated:** [April 25, 2022, 11:25pm UTC](https://discuss.elastic.co/t/watcher-pdf-reporting-fails-on-dockerised-7-17-x/301572 "2022-04-25T23:25:29Z")
Since my ELK stack upate from 7.16.2 to 7.17.1 (and 7.17.2 after that) Watcher has been unable to generate PDF reports. I run a dockerised ELK on Amazon EC2- using the Elastic-provided docker images. When I went to look… --- ## [Error when exporting saved objects](https://discuss.elastic.co/t/error-when-exporting-saved-objects/303079)
**Author:** [@jeremyross](https://discuss.elastic.co/u/jeremyross)\ **Replies:** 2\ **Last updated:** [April 25, 2022, 6:45pm UTC](https://discuss.elastic.co/t/error-when-exporting-saved-objects/303079 "2022-04-25T18:45:24Z")
I'm getting the following error when attempting to export saved objects: { "statusCode": 400, "error": "Bad Request", "message": "\[request body.attributes\]: expected value of type \[object\] but got \[undefined\]" } I… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=218) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=220)