# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=652 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 653 --- ## [Custom User couldn't write logs to Elastic](https://discuss.elastic.co/t/custom-user-couldnt-write-logs-to-elastic/187150)
**Author:** [@KatiukOleg](https://discuss.elastic.co/u/KatiukOleg)\ **Replies:** 5\ **Last updated:** [June 24, 2019, 3:54pm UTC](https://discuss.elastic.co/t/custom-user-couldnt-write-logs-to-elastic/187150 "2019-06-24T15:54:26Z")
Hi there, I was creating custom user via Kibana for writing logs to elastic purpose only. Firstly I specify custom role -\> Then I map new user with this role. Then I tried my C# app in debug mode and no logs are ad… --- ## [Metrics in visualization, calculate a field sum in JSON input script](https://discuss.elastic.co/t/metrics-in-visualization-calculate-a-field-sum-in-json-input-script/185781)
**Author:** [@Magnus\_Andersson1](https://discuss.elastic.co/u/Magnus_Andersson1)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 3:50pm UTC](https://discuss.elastic.co/t/metrics-in-visualization-calculate-a-field-sum-in-json-input-script/185781 "2019-06-24T15:50:53Z")
I have a Metric control in Canvas which uses this query: SELECT SUM(AbstractData.no\_of\_assets\_with\_SIR) \* 100.0 / SUM(AbstractData.count\_total\_assets) as percentage FROM cpg\_abstract\_dev\_project\_kpi Now I need to d… --- ## [Time Range in Dashboards not working](https://discuss.elastic.co/t/time-range-in-dashboards-not-working/186915)
**Author:** [@Facundo\_Chambo](https://discuss.elastic.co/u/Facundo_Chambo)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 3:46pm UTC](https://discuss.elastic.co/t/time-range-in-dashboards-not-working/186915 "2019-06-24T15:46:10Z")
Hi, I'm using Metricbeat to save info into an index in ElasticSearch v6.7. The name of the index is classifier. Then, I built a Visualization in Kibana using that index to show the number of requests for a service. Th… --- ## [Change colour of stroke in progress wheel according to value](https://discuss.elastic.co/t/change-colour-of-stroke-in-progress-wheel-according-to-value/186995)
**Author:** [@Ravindra\_Chauhan](https://discuss.elastic.co/u/Ravindra_Chauhan)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 3:43pm UTC](https://discuss.elastic.co/t/change-colour-of-stroke-in-progress-wheel-according-to-value/186995 "2019-06-24T15:43:13Z")
Hi,how to change colour of stroke in progress wheel according to value? --- ## [Handling an empty datatable](https://discuss.elastic.co/t/handling-an-empty-datatable/186963)
**Author:** [@gbarnett](https://discuss.elastic.co/u/gbarnett)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 3:08pm UTC](https://discuss.elastic.co/t/handling-an-empty-datatable/186963 "2019-06-24T15:08:35Z")
In Canvas, i’m Using the expression editor to calculate a percentage for use in a Metric object. After creating the datatable using ply, I’m executing the line: math “mean(percentage)” However, if my datatable is empt… --- ## [Kibana dashboard create api payload](https://discuss.elastic.co/t/kibana-dashboard-create-api-payload/187023)
**Author:** [@lioramilbaum](https://discuss.elastic.co/u/lioramilbaum)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 3:08pm UTC](https://discuss.elastic.co/t/kibana-dashboard-create-api-payload/187023 "2019-06-24T15:08:34Z")
spinned docker elk stack - 7.1.1 Can't figure out how the create dashboard api payload should look like. The documentation is unclear with no examples. Would appreciate references/examples. --- ## [Add or and filter in kibana dashboard to use with Controls(e) in kibana](https://discuss.elastic.co/t/add-or-and-filter-in-kibana-dashboard-to-use-with-controls-e-in-kibana/185926)
**Author:** [@manish\_kaushik](https://discuss.elastic.co/u/manish_kaushik)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 2:42pm UTC](https://discuss.elastic.co/t/add-or-and-filter-in-kibana-dashboard-to-use-with-controls-e-in-kibana/185926 "2019-06-24T14:42:53Z")
I was trying to build a dashboard with Controls in visualization and by default is uses 'and' logical operation between multiple option list available in controls. I ant to create a button that can allow to select which… --- ## [Bad Gateway Error in Kibana 6.8.0](https://discuss.elastic.co/t/bad-gateway-error-in-kibana-6-8-0/186583)
**Author:** [@Neel.Gagan](https://discuss.elastic.co/u/Neel.Gagan)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 2:39pm UTC](https://discuss.elastic.co/t/bad-gateway-error-in-kibana-6-8-0/186583 "2019-06-24T14:39:37Z")
ES 6.8.0 is up and running but while running Kibana error of \[plugin: xpack-main@6.8.0\]-Bad Gateway \[plugin: graph@6.8.0\]-Bad Gateway \[plugin: spaces@6.8.0\]-Bad Gateway Poll Error Bad Gateway i am not using xpack fe… --- ## [How to group the documents which have subset of similar values](https://discuss.elastic.co/t/how-to-group-the-documents-which-have-subset-of-similar-values/185737)
**Author:** [@ashokchinna](https://discuss.elastic.co/u/ashokchinna)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 2:10pm UTC](https://discuss.elastic.co/t/how-to-group-the-documents-which-have-subset-of-similar-values/185737 "2019-06-24T14:10:58Z")
I have error table which logs all the errors. I want to group all similar errors and exceptions. Few are straight forward, example, Document 1 , Error Message - Database mark down Document 2 , Error Message - Servic… --- ## [How to solve error: "Status changed from green to red - all shards failed"](https://discuss.elastic.co/t/how-to-solve-error-status-changed-from-green-to-red-all-shards-failed/185689)
**Author:** [@wolfgangschmidt](https://discuss.elastic.co/u/wolfgangschmidt)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 2:03pm UTC](https://discuss.elastic.co/t/how-to-solve-error-status-changed-from-green-to-red-all-shards-failed/185689 "2019-06-24T14:03:44Z")
Kibana throws this error message (on a single testing system very often, on production cluster sometimes): kibana: {"type":"log","@timestamp":"2019-06-13T15:14:28Z","tags":\["status","plugin:ml@5.6.16","error"\],"pid":544… --- ## [Kibana 6.5.1 intermittently stops displaying data](https://discuss.elastic.co/t/kibana-6-5-1-intermittently-stops-displaying-data/185030)
**Author:** [@byoungman](https://discuss.elastic.co/u/byoungman)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 1:22pm UTC](https://discuss.elastic.co/t/kibana-6-5-1-intermittently-stops-displaying-data/185030 "2019-06-24T13:22:34Z")
We are having an issue where Kibana will just stop displaying data this can go on for a couple of hours or it can last 2 - 3 days there seems to be no pattern to it that I can ascertain. We have alerts set up so that if… --- ## [To make graph the interval between events with Kibana](https://discuss.elastic.co/t/to-make-graph-the-interval-between-events-with-kibana/187131)
**Author:** [@GeneA](https://discuss.elastic.co/u/GeneA)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 12:57pm UTC](https://discuss.elastic.co/t/to-make-graph-the-interval-between-events-with-kibana/187131 "2019-06-24T12:57:49Z")
Data is indexed in elasticsearch in the form of "time + event" about a person's behavior pattern. Using this data ・ Sleep time (interval between 'Going to bed' and 'Get up') ・ Working hours (interval between 'Arriving… --- ## [How do i calculate 2SD (2 standard deviation) in Kibana and present it on some graph?](https://discuss.elastic.co/t/how-do-i-calculate-2sd-2-standard-deviation-in-kibana-and-present-it-on-some-graph/187124)
**Author:** [@Pritesh](https://discuss.elastic.co/u/Pritesh)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 12:34pm UTC](https://discuss.elastic.co/t/how-do-i-calculate-2sd-2-standard-deviation-in-kibana-and-present-it-on-some-graph/187124 "2019-06-24T12:34:38Z")
How do i calculate 2SD (2 standard deviation) in Kibana and present it on some graph? --- ## [How to use conditional operator in bucket\_script.i tried this query](https://discuss.elastic.co/t/how-to-use-conditional-operator-in-bucket-script-i-tried-this-query/187107)
**Author:** [@Sakthivanan](https://discuss.elastic.co/u/Sakthivanan)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 11:08am UTC](https://discuss.elastic.co/t/how-to-use-conditional-operator-in-bucket-script-i-tried-this-query/187107 "2019-06-24T11:08:10Z")
{ "size": 0, "query": { "bool": { "filter": \[\], "must": \[ { "terms": { "metric\_id": \[ … --- ## [Visual Builder in Kibana](https://discuss.elastic.co/t/visual-builder-in-kibana/186888)
**Author:** [@Costi](https://discuss.elastic.co/u/Costi)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 7:42am UTC](https://discuss.elastic.co/t/visual-builder-in-kibana/186888 "2019-06-24T07:42:45Z")
Hi! I encounter the following problem when I tried to create a visualization using Visual Builder when I am trying to add a Group by. See the error message in the picture. I am using IE as a browser Thanks. --- ## [Kibana timelion split nested objects not working?](https://discuss.elastic.co/t/kibana-timelion-split-nested-objects-not-working/182028)
**Author:** [@jdmc562](https://discuss.elastic.co/u/jdmc562)\ **Replies:** 4\ **Last updated:** [June 24, 2019, 7:34am UTC](https://discuss.elastic.co/t/kibana-timelion-split-nested-objects-not-working/182028 "2019-06-24T07:34:21Z")
Hi , i'm trying to use the split funtion in timelion but i need to split on a nested field (in this case contextMap.ACTION), I am trying to do like this .es(q= "xxxx", split=contextMap.ACTION:10) but it does not seem t… --- ## [How to find maximum number query executed in sql server](https://discuss.elastic.co/t/how-to-find-maximum-number-query-executed-in-sql-server/186636)
**Author:** [@Pramod\_Thakur](https://discuss.elastic.co/u/Pramod_Thakur)\ **Replies:** 12\ **Last updated:** [June 24, 2019, 7:28am UTC](https://discuss.elastic.co/t/how-to-find-maximum-number-query-executed-in-sql-server/186636 "2019-06-24T07:28:40Z")
I am logging all my SQL inline query in elastic search. Now I have the requirement to improve performance of my SQL query. How I will find which query I am executing most. So that I can improve my SQL query. Maybe my whe… --- ## [Filtering PDF Visualations/Reports in Watcher](https://discuss.elastic.co/t/filtering-pdf-visualations-reports-in-watcher/187066)
**Author:** [@johnwood](https://discuss.elastic.co/u/johnwood)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 7:28am UTC](https://discuss.elastic.co/t/filtering-pdf-visualations-reports-in-watcher/187066 "2019-06-24T07:28:09Z")
Hi - I have a working watcher that generates a pdf of a dashboard and emails it to me every day. I need to add a filter to that dashboard but, when I do and I update the URL in the watcher the resulting PDF is always em… --- ## [Anonymous/Auto authentification in Kibana](https://discuss.elastic.co/t/anonymous-auto-authentification-in-kibana/186897)
**Author:** [@Hyrastios](https://discuss.elastic.co/u/Hyrastios)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 7:09am UTC](https://discuss.elastic.co/t/anonymous-auto-authentification-in-kibana/186897 "2019-06-24T07:09:43Z")
Hi, I'm using a local 1 cluster 2 nodes 7.1.1 ELK setup with xpack security enabled on elasticsearch. What I want to do is setting up an auto-authentification or an anonymous access in order for the user to directly ar… --- ## [How to force login in kibana](https://discuss.elastic.co/t/how-to-force-login-in-kibana/186728)
**Author:** [@Mustapha\_MJ](https://discuss.elastic.co/u/Mustapha_MJ)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 4:46am UTC](https://discuss.elastic.co/t/how-to-force-login-in-kibana/186728 "2019-06-24T04:46:04Z")
Hello ELK Community i install ELK stack on centos7 and i cant understand why kibana doesn't use login page i mean enyone can just type http://ELK\_IP:5601 and see my indexes, dashboard ......everything how i can force… --- ## [Document has property 'dashboard' which belongs to a more recent version](https://discuss.elastic.co/t/document-has-property-dashboard-which-belongs-to-a-more-recent-version/185742)
**Author:** [@fragatina](https://discuss.elastic.co/u/fragatina)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 1:30am UTC](https://discuss.elastic.co/t/document-has-property-dashboard-which-belongs-to-a-more-recent-version/185742 "2019-06-24T01:30:28Z")
Hi, I've update Elasticsearch/Kibana to 7.1.1 (from 7.0.0). When I try to upload the dashboards into kibana I get the following error: {"statusCode":400,"error":"Bad Request","message":"Document \\"339b7c40-1495-11e7-b… --- ## [Can kibana and logstash enjoy platinum license](https://discuss.elastic.co/t/can-kibana-and-logstash-enjoy-platinum-license/186415)
**Author:** [@TsuWeiQuan](https://discuss.elastic.co/u/TsuWeiQuan)\ **Replies:** 5\ **Last updated:** [June 24, 2019, 1:16am UTC](https://discuss.elastic.co/t/can-kibana-and-logstash-enjoy-platinum-license/186415 "2019-06-24T01:16:42Z")
Hello, I have been told that my company had purchased ELASTIC STACK platinum license for 9 nodes. In these 9 nodes, 3 will be used for dedicated master nodes and 6 will be data nodes. However, would kibana and logstas… --- ## [Kibana7.1.1 kibana belongs to a version of Kibana that cannot be automatically migrated](https://discuss.elastic.co/t/kibana7-1-1-kibana-belongs-to-a-version-of-kibana-that-cannot-be-automatically-migrated/186787)
**Author:** [@HuangJiaRen](https://discuss.elastic.co/u/HuangJiaRen)\ **Replies:** 1\ **Last updated:** [June 23, 2019, 9:15pm UTC](https://discuss.elastic.co/t/kibana7-1-1-kibana-belongs-to-a-version-of-kibana-that-cannot-be-automatically-migrated/186787 "2019-06-23T21:15:33Z")
Error: Index .kibana belongs to a version of Kibana that cannot be automatically migrated. Reset it or use the X-Pack upgrade assistant. --- ## [Input Controls not showing](https://discuss.elastic.co/t/input-controls-not-showing/186866)
**Author:** [@mr\_searchng](https://discuss.elastic.co/u/mr_searchng)\ **Replies:** 4\ **Last updated:** [June 23, 2019, 7:43am UTC](https://discuss.elastic.co/t/input-controls-not-showing/186866 "2019-06-23T07:43:11Z")
How do I add an Input Controls field in Visualize Kibana ? Thanks --- ## [Connecting Kibana to Elasticsearch over HTTPS: unsupported certificate purpose](https://discuss.elastic.co/t/connecting-kibana-to-elasticsearch-over-https-unsupported-certificate-purpose/186907)
**Author:** [@Chris\_Murray](https://discuss.elastic.co/u/Chris_Murray)\ **Replies:** 2\ **Last updated:** [June 21, 2019, 11:13pm UTC](https://discuss.elastic.co/t/connecting-kibana-to-elasticsearch-over-https-unsupported-certificate-purpose/186907 "2019-06-21T23:13:27Z")
Hey folks, I'm in the process of setting up my first larger ES cluster, and first time going full HTTPS across the board. Bit of background: 40ish ES nodes, with 2 Kibana nodes. Using an internal root CA / Intermedia… --- ## [Get logged in username from kibana scripted field and make post to api](https://discuss.elastic.co/t/get-logged-in-username-from-kibana-scripted-field-and-make-post-to-api/186918)
**Author:** [@serhii.zaidlin](https://discuss.elastic.co/u/serhii.zaidlin)\ **Replies:** 1\ **Last updated:** [June 21, 2019, 10:42pm UTC](https://discuss.elastic.co/t/get-logged-in-username-from-kibana-scripted-field-and-make-post-to-api/186918 "2019-06-21T22:42:59Z")
Hello, What I'm trying trying to do - create an URL scripted field in kibana, which should make a request to my apps API. This request should contain some id information of logged in kibana user (username or any possibl… --- ## [How to combine two outputs](https://discuss.elastic.co/t/how-to-combine-two-outputs/186905)
**Author:** [@frostkilen](https://discuss.elastic.co/u/frostkilen)\ **Replies:** 1\ **Last updated:** [June 21, 2019, 10:25pm UTC](https://discuss.elastic.co/t/how-to-combine-two-outputs/186905 "2019-06-21T22:25:43Z")
Hi together, as a total ES Noob I have one essential question. How do I combine two values from an aggregation? I am collecting sFlow Data with "ElastiFlow" and have some traffic sums of the available fields (from sF… --- ## [Visualizing A Network Connection With Graphics](https://discuss.elastic.co/t/visualizing-a-network-connection-with-graphics/186281)
**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\ **Replies:** 3\ **Last updated:** [June 21, 2019, 2:45pm UTC](https://discuss.elastic.co/t/visualizing-a-network-connection-with-graphics/186281 "2019-06-21T14:45:44Z")
I am ingesting network data (CloudFlare logs) and would like to visualize two legs of the traffic with images. In CloudFlare, there are metrics for Client to CloudFlare SSL connections and CloudFlare to Origin SSL conne… --- ## [Unbale to locate logs in KIbana](https://discuss.elastic.co/t/unbale-to-locate-logs-in-kibana/185760)
**Author:** [@Vineeth\_Ananthula1](https://discuss.elastic.co/u/Vineeth_Ananthula1)\ **Replies:** 1\ **Last updated:** [June 21, 2019, 1:36pm UTC](https://discuss.elastic.co/t/unbale-to-locate-logs-in-kibana/185760 "2019-06-21T13:36:19Z")
My logstash.service, elasticsearch.service, kibana.service are up and running perfectly in my machine. Logstash was able to receive logs on 514 port. The problem is my index appears in kibana but when I am unable to find… --- ## [Change Date format in kibana](https://discuss.elastic.co/t/change-date-format-in-kibana/185764)
**Author:** [@A\_google\_user](https://discuss.elastic.co/u/A_google_user)\ **Replies:** 1\ **Last updated:** [June 21, 2019, 1:20pm UTC](https://discuss.elastic.co/t/change-date-format-in-kibana/185764 "2019-06-21T13:20:00Z")
I have data in which date format is in epoch format(milli second). Now I want to filter data on that field. How can I make this possible ? Is there any feature or mapping or plug in, by which data gets stored in date fo… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=651) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=653)