# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=534 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 535 --- ## [Need query to filter two field and get the unique count bases on one field](https://discuss.elastic.co/t/need-query-to-filter-two-field-and-get-the-unique-count-bases-on-one-field/220129)
**Author:** [@Prateek\_Bajaj](https://discuss.elastic.co/u/Prateek_Bajaj)\ **Replies:** 4\ **Last updated:** [February 20, 2020, 1:03pm UTC](https://discuss.elastic.co/t/need-query-to-filter-two-field-and-get-the-unique-count-bases-on-one-field/220129 "2020-02-20T13:03:52Z")
Hi , I want to write a \_search or \_count query (kql) that will give the unique count based on one field after filtering two other fields. It will be really helpful if you guys can help me with it. --- ## [Remove null values from aggregated table visualization](https://discuss.elastic.co/t/remove-null-values-from-aggregated-table-visualization/220190)
**Author:** [@opellulo](https://discuss.elastic.co/u/opellulo)\ **Replies:** 0\ **Last updated:** [February 20, 2020, 12:58pm UTC](https://discuss.elastic.co/t/remove-null-values-from-aggregated-table-visualization/220190 "2020-02-20T12:58:25Z")
Hi all, I have a simple visualization issue in Kibana that i suspect it's harder to fix than i thought, here is my situation: I have an index where the docs have different fields, however one of this field is common fo… --- ## [Error loading data](https://discuss.elastic.co/t/error-loading-data/220160)
**Author:** [@tennaen](https://discuss.elastic.co/u/tennaen)\ **Replies:** 2\ **Last updated:** [February 20, 2020, 11:54am UTC](https://discuss.elastic.co/t/error-loading-data/220160 "2020-02-20T11:54:10Z")
Starting from today, i receive this error: SyntaxError: Unexpected token u in JSON at position 0 at JSON.parse (\) at http://10.2.202.116:5601/bundles/commons.bundle.js:3:3378900 at http://10.2.202… --- ## [Can I use wildcards in Machine Learning Filter Lists](https://discuss.elastic.co/t/can-i-use-wildcards-in-machine-learning-filter-lists/220120)
**Author:** [@willemdh](https://discuss.elastic.co/u/willemdh)\ **Replies:** 1\ **Last updated:** [February 20, 2020, 11:40am UTC](https://discuss.elastic.co/t/can-i-use-wildcards-in-machine-learning-filter-lists/220120 "2020-02-20T11:40:26Z")
Hello, Noticed that the packetbeat\_rare\_server\_domain ml job has a lot of noise / false positive anomalies. Most of the server.domain values are for internal url's, so I was thinking to add a filter list to limit where … --- ## [Creating a TSVB chart with unique count of ID's across all fields in Kibana](https://discuss.elastic.co/t/creating-a-tsvb-chart-with-unique-count-of-ids-across-all-fields-in-kibana/220155)
**Author:** [@dmomi](https://discuss.elastic.co/u/dmomi)\ **Replies:** 0\ **Last updated:** [February 20, 2020, 10:22am UTC](https://discuss.elastic.co/t/creating-a-tsvb-chart-with-unique-count-of-ids-across-all-fields-in-kibana/220155 "2020-02-20T10:22:28Z")
Hi I am new to Kibana and TSVB. I am trying to create a filter ratio using unique number of records for transaction\_status = 2 / \*. I am able to find out till unique no of records using cardinality of ID column not the … --- ## [Change indices on discover](https://discuss.elastic.co/t/change-indices-on-discover/220154)
**Author:** [@andras.vecsi](https://discuss.elastic.co/u/andras.vecsi)\ **Replies:** 1\ **Last updated:** [February 20, 2020, 10:26am UTC](https://discuss.elastic.co/t/change-indices-on-discover/220154 "2020-02-20T10:26:08Z")
Hello, I have two spaces: Users and IT In the IT space I am able to change the indices on the discover page: In the Users space I am not able to change the indices Under Management/Spaces I can see this In the… --- ## [React](https://discuss.elastic.co/t/react/219601)
**Author:** [@Gangesh](https://discuss.elastic.co/u/Gangesh)\ **Replies:** 5\ **Last updated:** [February 20, 2020, 10:17am UTC](https://discuss.elastic.co/t/react/219601 "2020-02-20T10:17:30Z")
Hi @ Monfera, Actually i want try to use reactjs for our existing angularjs application where i am using kibana5.1.1 and elasticsearch5. when i import prop-type in our js file it is throw error. --- ## [How to pass multiple values from Data Table for next drilldown to filter data?](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801)
**Author:** [@venkata.kodapaka](https://discuss.elastic.co/u/venkata.kodapaka)\ **Replies:** 4\ **Last updated:** [February 20, 2020, 9:54am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801 "2020-02-20T09:54:46Z")
Hi Team, I've built a Visualization as Data Table as Summary report in which I have multiple columns. When I click on any cell, it has to open the respective drilldown data where in which Column1 and Column2 have to be … --- ## [Extracting docs with whitespaces between words in a field](https://discuss.elastic.co/t/extracting-docs-with-whitespaces-between-words-in-a-field/220116)
**Author:** [@Ramya\_Tanikanti](https://discuss.elastic.co/u/Ramya_Tanikanti)\ **Replies:** 2\ **Last updated:** [February 20, 2020, 8:53am UTC](https://discuss.elastic.co/t/extracting-docs-with-whitespaces-between-words-in-a-field/220116 "2020-02-20T08:53:29Z")
I have a field with zipcodes, some zipcodes are continuous without any whitespace some have whitespaces in between. Ex: "abc 123". How can filter out or extract the docs with whitespace in between words using either the… --- ## [Huge json data update in kibana using python](https://discuss.elastic.co/t/huge-json-data-update-in-kibana-using-python/220121)
**Author:** [@SangeethaSivakumar](https://discuss.elastic.co/u/SangeethaSivakumar)\ **Replies:** 1\ **Last updated:** [February 20, 2020, 8:24am UTC](https://discuss.elastic.co/t/huge-json-data-update-in-kibana-using-python/220121 "2020-02-20T08:24:50Z")
{ "statusCode": 413, "error": "Request Entity Too Large", "message": "Payload content length greater than maximum allowed: 1048576" } Getting the above error while updating the json data in kibana. File size is huge… --- ## [Compare fields of different documents in the same index](https://discuss.elastic.co/t/compare-fields-of-different-documents-in-the-same-index/219756)
**Author:** [@JamieUnix](https://discuss.elastic.co/u/JamieUnix)\ **Replies:** 4\ **Last updated:** [February 20, 2020, 6:59am UTC](https://discuss.elastic.co/t/compare-fields-of-different-documents-in-the-same-index/219756 "2020-02-20T06:59:10Z")
There are a lot of discussions around this topic but haven't found a solution for my problem. I am trying to compare fields of different documents in the same index. For example,let's say i have three documents as below… --- ## [Configure Kibana for remote cluster search](https://discuss.elastic.co/t/configure-kibana-for-remote-cluster-search/220041)
**Author:** [@mtudisco](https://discuss.elastic.co/u/mtudisco)\ **Replies:** 5\ **Last updated:** [February 19, 2020, 8:05pm UTC](https://discuss.elastic.co/t/configure-kibana-for-remote-cluster-search/220041 "2020-02-19T20:05:16Z")
Hi, I'm using Elastic stack 7.5 and have several data centers. Not all data centers have a good bandwitch, so setting up a cluster distributed between data centers is not a good option according to: So i was thinkin… --- ## [Not Getting data from Index pattern using SQL](https://discuss.elastic.co/t/not-getting-data-from-index-pattern-using-sql/218031)
**Author:** [@emad101](https://discuss.elastic.co/u/emad101)\ **Replies:** 13\ **Last updated:** [February 19, 2020, 7:25pm UTC](https://discuss.elastic.co/t/not-getting-data-from-index-pattern-using-sql/218031 "2020-02-19T19:25:44Z")
Hello, I am trying to fetch all data in a field to a canvas in the elastic index, but for some reason I am receiving a weird error here is the sql query I send SELECT app\_code FROM "devops\_et\*" But I receive this err… --- ## [Kibana.crt, no such file or directory](https://discuss.elastic.co/t/kibana-crt-no-such-file-or-directory/219913)
**Author:** [@Prashant\_Kumar3](https://discuss.elastic.co/u/Prashant_Kumar3)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 4:22pm UTC](https://discuss.elastic.co/t/kibana-crt-no-such-file-or-directory/219913 "2020-02-19T16:22:22Z")
I have existing cert in config/certs/kibana.crt and I have also mentioned it into kibana.yml as server.ssl.certificate : config/certs/kibana.crt. Still I am not able to start my Kibana instance. Getting Error like log … --- ## [How aggregatable fields are defined in Kibana](https://discuss.elastic.co/t/how-aggregatable-fields-are-defined-in-kibana/219957)
**Author:** [@Alexandros888](https://discuss.elastic.co/u/Alexandros888)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 4:00pm UTC](https://discuss.elastic.co/t/how-aggregatable-fields-are-defined-in-kibana/219957 "2020-02-19T16:00:52Z")
Hello i created an index and i saw that even some string or boolean fields are aggregatable. That helped a lot because i created aggs during alert creation even on those string and boolean fields. My question is the … --- ## [Create conditional field based on aggregation in table view](https://discuss.elastic.co/t/create-conditional-field-based-on-aggregation-in-table-view/219962)
**Author:** [@Dani\_Ruse](https://discuss.elastic.co/u/Dani_Ruse)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 3:55pm UTC](https://discuss.elastic.co/t/create-conditional-field-based-on-aggregation-in-table-view/219962 "2020-02-19T15:55:45Z")
Hello all, I want to create a table with an "Error" column which will be populated with the values "YES" or "NO", depending on whether a sum aggregation has the value lower or greater than 0. My metric looks as such: … --- ## [Array : sum of to request in one line](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809)
**Author:** [@Bruno1](https://discuss.elastic.co/u/Bruno1)\ **Replies:** 4\ **Last updated:** [February 19, 2020, 3:37pm UTC](https://discuss.elastic.co/t/array-sum-of-to-request-in-one-line/219809 "2020-02-19T15:37:18Z")
Hello, I want add a variable on timelion request like $myvar=1,.es(index="filebeat-\*",q='netflow.egress\_interface:'+$myvar ,metric="\[...\] What is the correct syntax please ? --- ## [API response time visualization](https://discuss.elastic.co/t/api-response-time-visualization/219981)
**Author:** [@Madhu19](https://discuss.elastic.co/u/Madhu19)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 3:09pm UTC](https://discuss.elastic.co/t/api-response-time-visualization/219981 "2020-02-19T15:09:55Z")
Hi, Is it possible to visualize response time V/s API calls graph in Kibana --- ## [Tooltip - timelion](https://discuss.elastic.co/t/tooltip-timelion/218715)
**Author:** [@ROHINI13](https://discuss.elastic.co/u/ROHINI13)\ **Replies:** 5\ **Last updated:** [February 19, 2020, 10:23am UTC](https://discuss.elastic.co/t/tooltip-timelion/218715 "2020-02-19T10:23:19Z")
Hi guys, Good afternoon , Can I create a tooptip cursor for the timelion kibana for new release elastic search 7.5 version ? If so , can you anyone help me thanks in advance --- ## [Timelion graph - average with a condition](https://discuss.elastic.co/t/timelion-graph-average-with-a-condition/219728)
**Author:** [@gash25](https://discuss.elastic.co/u/gash25)\ **Replies:** 2\ **Last updated:** [February 19, 2020, 9:53am UTC](https://discuss.elastic.co/t/timelion-graph-average-with-a-condition/219728 "2020-02-19T09:53:08Z")
Hi, i am trying to create a graph in timelion that shows the average value of a field as long as the field is greater than 0. For some reason i cannot do that. writing the following command returns all points on the 0… --- ## [Custom legend with for Vertical Bar Chart](https://discuss.elastic.co/t/custom-legend-with-for-vertical-bar-chart/219671)
**Author:** [@willemdh](https://discuss.elastic.co/u/willemdh)\ **Replies:** 2\ **Last updated:** [February 19, 2020, 9:36am UTC](https://discuss.elastic.co/t/custom-legend-with-for-vertical-bar-chart/219671 "2020-02-19T09:36:06Z")
Hello, Some thing I always disliked about Vertical Bar charts legends in kibana is the fact that the legend is half of the time not customizable and has always the same width. The result is that in a lot of graphs, all … --- ## [Kibana SAML integration with Azure](https://discuss.elastic.co/t/kibana-saml-integration-with-azure/219845)
**Author:** [@dbElastic](https://discuss.elastic.co/u/dbElastic)\ **Replies:** 6\ **Last updated:** [February 19, 2020, 9:18am UTC](https://discuss.elastic.co/t/kibana-saml-integration-with-azure/219845 "2020-02-19T09:18:30Z")
Hello @ikakavas We are using elastic cloud hosting version 7.5. We have below configuration for user overrides sections of elasticsearch and kibana.we have created roles in kibana and created a AD user group in Azure c… --- ## [Error: Not Found at http://localhost:5601/bundles/commons.bundle.js:3:1376093](https://discuss.elastic.co/t/error-not-found-at-http-localhost-5601-bundles-commons-bundle-js1376093/218720)
**Author:** [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\ **Replies:** 4\ **Last updated:** [February 19, 2020, 9:07am UTC](https://discuss.elastic.co/t/error-not-found-at-http-localhost-5601-bundles-commons-bundle-js1376093/218720 "2020-02-19T09:07:51Z")
Hello folks, When i click on Discover in kibana i get ther below error, Error: Not Found at http://localhost:5601/bundles/commons.bundle.js:3:1376093. I'm new to kibana and puzzled out trying to figure this out. Lo… --- ## [New plugin for Kibana that exposes data for Mobile apps](https://discuss.elastic.co/t/new-plugin-for-kibana-that-exposes-data-for-mobile-apps/219792)
**Author:** [@tsvet](https://discuss.elastic.co/u/tsvet)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 6:01am UTC](https://discuss.elastic.co/t/new-plugin-for-kibana-that-exposes-data-for-mobile-apps/219792 "2020-02-19T06:01:33Z")
Hello, I wanted to share with you one new plugin which might be useful for you in case you wanted to use Kibana on your mobile phone. It requires 2 components: Kibana Go plugin - https://github.com/OctagonMobile/Kib… --- ## [Nginx with Kibana](https://discuss.elastic.co/t/nginx-with-kibana/217971)
**Author:** [@Saravana37](https://discuss.elastic.co/u/Saravana37)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 5:59am UTC](https://discuss.elastic.co/t/nginx-with-kibana/217971 "2020-02-19T05:59:34Z")
Hello All , I am trying to configure basic authentication for Kibana using nginx. Please find my nginx.conf contents. \> \> #user nobody; \> \> worker\_processes 1; \> \> #error\_log logs/error.log; \> #error\_log logs/e… --- ## [How to Increase Kibana Storage](https://discuss.elastic.co/t/how-to-increase-kibana-storage/219602)
**Author:** [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Replies:** 5\ **Last updated:** [February 19, 2020, 5:24am UTC](https://discuss.elastic.co/t/how-to-increase-kibana-storage/219602 "2020-02-19T05:24:12Z")
My kibana use full memory 195 out of 200gb how to increase space in kibana server i have 50 gb free disk space. Because of full memory i cannot edit anything like deleting old dashboard or visualization or create new vis… --- ## [Controls visualization](https://discuss.elastic.co/t/controls-visualization/219651)
**Author:** [@liorg2](https://discuss.elastic.co/u/liorg2)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 4:42am UTC](https://discuss.elastic.co/t/controls-visualization/219651 "2020-02-19T04:42:51Z")
hello, how can I achieve the following: I have a dashboard with 20 visualizations. (their index pattern is client\*) 1 of them is a dropdown with clients list. can I make the user to select a client from the dropdown,… --- ## [Uber Kibana plugin](https://discuss.elastic.co/t/uber-kibana-plugin/219613)
**Author:** [@trex](https://discuss.elastic.co/u/trex)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 4:19am UTC](https://discuss.elastic.co/t/uber-kibana-plugin/219613 "2020-02-19T04:19:50Z")
I know you can bundle multiple plugins in a single uber plugin for Elasticsearch. https://github.com/elastic/elasticsearch/pull/28022 Do we have something like this for Kibana plugins? If yes, where can I find the imple… --- ## [UI Plugin development - Kibana using React js](https://discuss.elastic.co/t/ui-plugin-development-kibana-using-react-js/219870)
**Author:** [@Deepthi\_Khader](https://discuss.elastic.co/u/Deepthi_Khader)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 4:06am UTC](https://discuss.elastic.co/t/ui-plugin-development-kibana-using-react-js/219870 "2020-02-19T04:06:18Z")
Hi. I am trying to develop a plugin for Kibana (version 7.0.1) with elasticsearch (version 7.3.1). I need to develop a tool that can be embedded into Kibana as a tool. Can anyone suggest a way of doing this from scratch.… --- ## [Customization of Kibana per user/role](https://discuss.elastic.co/t/customization-of-kibana-per-user-role/219611)
**Author:** [@Pablo\_Albertengo](https://discuss.elastic.co/u/Pablo_Albertengo)\ **Replies:** 3\ **Last updated:** [February 18, 2020, 9:23pm UTC](https://discuss.elastic.co/t/customization-of-kibana-per-user-role/219611 "2020-02-18T21:23:42Z")
I have the following situation. I'm indexing information related to the operations of our suppliers in our system. Each document in the index has a supplierId field, which distinguishes one supplier from another. The i… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=533) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=535)