# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=476 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 477 --- ## [Indian Currency Formate](https://discuss.elastic.co/t/indian-currency-formate/236676)
**Author:** [@jeeva](https://discuss.elastic.co/u/jeeva)\ **Replies:** 1\ **Last updated:** [June 11, 2020, 1:40pm UTC](https://discuss.elastic.co/t/indian-currency-formate/236676 "2020-06-11T13:40:42Z")
Hi Team, We have Sales column in our Indices , where we want show sum sales like "1,00,000.00". Do we have any option in Kibana to attain this results. Thanks S.Jeeva --- ## [Kibana Point to point aggregation](https://discuss.elastic.co/t/kibana-point-to-point-aggregation/236500)
**Author:** [@Pablo95](https://discuss.elastic.co/u/Pablo95)\ **Replies:** 9\ **Last updated:** [June 11, 2020, 1:15pm UTC](https://discuss.elastic.co/t/kibana-point-to-point-aggregation/236500 "2020-06-11T13:15:08Z")
Hi, I've been searching a lot about the point to point aggregation and I still have some doubts of what are the requisites to be able to make this layer. Do I have to map a field (f.ex: source) with two sub fields (f.e… --- ## [How to graphic a Division between two selected metrics](https://discuss.elastic.co/t/how-to-graphic-a-division-between-two-selected-metrics/235216)
**Author:** [@fchantada](https://discuss.elastic.co/u/fchantada)\ **Replies:** 2\ **Last updated:** [June 11, 2020, 11:53am UTC](https://discuss.elastic.co/t/how-to-graphic-a-division-between-two-selected-metrics/235216 "2020-06-11T11:53:14Z")
Hi, Starting from MetricBeats metrics with the ElasticSearch Module. I want to graphic on Kibana the Search Latency. I know that the necessary metrics are node\_stats.indices.search.query\_time\_in\_millis and node\_stats.in… --- ## [How do I set timezone in a scripted field?](https://discuss.elastic.co/t/how-do-i-set-timezone-in-a-scripted-field/235367)
**Author:** [@Hugo\_Pires](https://discuss.elastic.co/u/Hugo_Pires)\ **Replies:** 1\ **Last updated:** [June 11, 2020, 9:49am UTC](https://discuss.elastic.co/t/how-do-i-set-timezone-in-a-scripted-field/235367 "2020-06-11T09:49:02Z")
I use the following code doc\['time\_start\_ts'\].value.hourOfDay to get hour of day from a time field with date format. How can I set the timezone in order get the correct value after Daylight Saving Time changes? Thank… --- ## [Dealing with quotation marks in a string in timelion](https://discuss.elastic.co/t/dealing-with-quotation-marks-in-a-string-in-timelion/236649)
**Author:** [@Amon](https://discuss.elastic.co/u/Amon)\ **Replies:** 1\ **Last updated:** [June 11, 2020, 8:49am UTC](https://discuss.elastic.co/t/dealing-with-quotation-marks-in-a-string-in-timelion/236649 "2020-06-11T08:49:15Z")
Dear, In my dataset I have a column with different string codes, I have a translation of these codes, some mean up others mean down (off course in a different grade). Now I want to make in Timelion an up and a down grap… --- ## [Rollup Job when one of the Terms field is array](https://discuss.elastic.co/t/rollup-job-when-one-of-the-terms-field-is-array/236651)
**Author:** [@vaibhavseth](https://discuss.elastic.co/u/vaibhavseth)\ **Replies:** 0\ **Last updated:** [June 11, 2020, 8:45am UTC](https://discuss.elastic.co/t/rollup-job-when-one-of-the-terms-field-is-array/236651 "2020-06-11T08:45:51Z")
I am trying to create a RollUp job from Kibana. In the Terms field where I have given multiple fields, in which one of the fields is of an array type (String type in Index). How RollUp job will aggregate data on the arra… --- ## [Saving frequently used user favourite filters](https://discuss.elastic.co/t/saving-frequently-used-user-favourite-filters/236290)
**Author:** [@Viktor\_Markvardt](https://discuss.elastic.co/u/Viktor_Markvardt)\ **Replies:** 2\ **Last updated:** [June 11, 2020, 7:53am UTC](https://discuss.elastic.co/t/saving-frequently-used-user-favourite-filters/236290 "2020-06-11T07:53:20Z")
Hi guys, How can I save a favourite filter like a drop-down list? (NOT a QUERY!) Are there any plugins for such purposes? --- ## [Scripted fields =~ does not work as described in original documentation](https://discuss.elastic.co/t/scripted-fields-does-not-work-as-described-in-original-documentation/235727)
**Author:** [@Datakids](https://discuss.elastic.co/u/Datakids)\ **Replies:** 2\ **Last updated:** [June 11, 2020, 7:30am UTC](https://discuss.elastic.co/t/scripted-fields-does-not-work-as-described-in-original-documentation/235727 "2020-06-11T07:30:42Z")
Hi folks, I need a little help here to understand how that works. Tried with Kibana 7.3.1, 7.6.2. 7.7.0 I've found this: Under "Regex" how to script a wildcard Then I took a look inside the 7.7x Documentation an… --- ## [Elasticsearch / Kibana: How can they run 24/7?](https://discuss.elastic.co/t/elasticsearch-kibana-how-can-they-run-24-7/235119)
**Author:** [@elisavet](https://discuss.elastic.co/u/elisavet)\ **Replies:** 2\ **Last updated:** [June 11, 2020, 7:26am UTC](https://discuss.elastic.co/t/elasticsearch-kibana-how-can-they-run-24-7/235119 "2020-06-11T07:26:53Z")
Hi! How can elasticsearch and kibana run 24/7? Details: I am running the elk stack on a remote server on production mode. The installation was with .tar.gz. I start elasticsearch running the bin/elasticsearch command… --- ## [Integration of kibana dashboard and keycloack](https://discuss.elastic.co/t/integration-of-kibana-dashboard-and-keycloack/236469)
**Author:** [@akg](https://discuss.elastic.co/u/akg)\ **Replies:** 3\ **Last updated:** [June 11, 2020, 5:41am UTC](https://discuss.elastic.co/t/integration-of-kibana-dashboard-and-keycloack/236469 "2020-06-11T05:41:50Z")
Hi All, I'm trying to integrate kibana and keycloak. does anyone have any idea about implementation and make it working? --- ## [Kibana does not open in my browser](https://discuss.elastic.co/t/kibana-does-not-open-in-my-browser/236586)
**Author:** [@Rodrigo\_Ceballos](https://discuss.elastic.co/u/Rodrigo_Ceballos)\ **Replies:** 2\ **Last updated:** [June 10, 2020, 10:57pm UTC](https://discuss.elastic.co/t/kibana-does-not-open-in-my-browser/236586 "2020-06-10T22:57:24Z")
119/5000 Hi. We are starting to work with Elastic and Kibana so we don't have much experience with this tool. I installed Elastic in a cento 7 with the steps: 1.- rpm --import https://artifacts.elastic.co/GPG-KEY-elas… --- ## [Upgrade 7.6-\>7.7 unable to verify the first certificate"](https://discuss.elastic.co/t/upgrade-7-6-7-7-unable-to-verify-the-first-certificate/233625)
**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\ **Replies:** 20\ **Last updated:** [June 10, 2020, 8:38pm UTC](https://discuss.elastic.co/t/upgrade-7-6-7-7-unable-to-verify-the-first-certificate/233625 "2020-06-10T20:38:56Z")
I've had my Elastic Stack secured using a public CA certificate for about a year now and upgraded from version to version without issue. Updated Elasticsearch and Kibana from 7.6.2 to 7.7.0 today and everything seemed t… --- ## [Lockdown access to Kibana and ElasticSearch console but open access to reports/dashboards](https://discuss.elastic.co/t/lockdown-access-to-kibana-and-elasticsearch-console-but-open-access-to-reports-dashboards/236387)
**Author:** [@tenet\_testuser1](https://discuss.elastic.co/u/tenet_testuser1)\ **Replies:** 3\ **Last updated:** [June 10, 2020, 7:44pm UTC](https://discuss.elastic.co/t/lockdown-access-to-kibana-and-elasticsearch-console-but-open-access-to-reports-dashboards/236387 "2020-06-10T19:44:30Z")
Hello, I have an app built in React. The apps has buttons to invoke Kibana Reports when clicked. The reports are visible and work fine when I open access to port 5601 for 0.0.0.0/0. But with this option, The user can … --- ## [How to apply filter for one field,](https://discuss.elastic.co/t/how-to-apply-filter-for-one-field/236348)
**Author:** [@inchirah](https://discuss.elastic.co/u/inchirah)\ **Replies:** 5\ **Last updated:** [June 10, 2020, 6:52pm UTC](https://discuss.elastic.co/t/how-to-apply-filter-for-one-field/236348 "2020-06-10T18:52:59Z")
Hello, I tried to apply filter for the second field "Attempt Compliant" but each time its applied for the two fields. Could anyone help me please? --- ## [Apply filter from the \_user variable](https://discuss.elastic.co/t/apply-filter-from-the-user-variable/236356)
**Author:** [@Felix\_Valembois](https://discuss.elastic.co/u/Felix_Valembois)\ **Replies:** 1\ **Last updated:** [June 10, 2020, 6:24pm UTC](https://discuss.elastic.co/t/apply-filter-from-the-user-variable/236356 "2020-06-10T18:24:46Z")
Hello, My problem is this : I want to filter the data in kibana in function of the name of the user connected (and other restriction that goes with the user.) So far, I applied a restriction on document with a query th… --- ## [All Available fields Gropped by Field](https://discuss.elastic.co/t/all-available-fields-gropped-by-field/236530)
**Author:** [@suslova](https://discuss.elastic.co/u/suslova)\ **Replies:** 1\ **Last updated:** [June 10, 2020, 6:17pm UTC](https://discuss.elastic.co/t/all-available-fields-gropped-by-field/236530 "2020-06-10T18:17:01Z")
Hello, I want to get all Available fields for some field. How can i make it? Now I just got to Discover, add filter "filed.keyword: "Smth" " and copy from left panel Available fields. But wee have a lot of value for fi… --- ## [Scripted fields to calculate %](https://discuss.elastic.co/t/scripted-fields-to-calculate/235114)
**Author:** [@katara](https://discuss.elastic.co/u/katara)\ **Replies:** 1\ **Last updated:** [June 10, 2020, 4:10pm UTC](https://discuss.elastic.co/t/scripted-fields-to-calculate/235114 "2020-06-10T16:10:15Z")
Hi, I have a field in Kibana which would say if my ticket is passed or failed. has\_passed is the field. I wanna write a scripted\_field based on this value. \> target % = (count(has\_passed='passed')/count(total)) \*100 … --- ## [Unable to update timezone for date formatting in kibana](https://discuss.elastic.co/t/unable-to-update-timezone-for-date-formatting-in-kibana/235894)
**Author:** [@falconpurple](https://discuss.elastic.co/u/falconpurple)\ **Replies:** 1\ **Last updated:** [June 10, 2020, 3:57pm UTC](https://discuss.elastic.co/t/unable-to-update-timezone-for-date-formatting-in-kibana/235894 "2020-06-10T15:57:25Z")
Hi, I am not able to change the timezone from Browser to CET in the advanced settings of kibana. It gives this error: "Unable to update UI setting Request failed with status code: 503 " Any help would be really appr… --- ## [Indes not visible in maps tab](https://discuss.elastic.co/t/indes-not-visible-in-maps-tab/235408)
**Author:** [@parthmaniar](https://discuss.elastic.co/u/parthmaniar)\ **Replies:** 8\ **Last updated:** [June 10, 2020, 3:36pm UTC](https://discuss.elastic.co/t/indes-not-visible-in-maps-tab/235408 "2020-06-10T15:36:31Z")
I am trying to plot data that has been enriched in a logstash pipieline with GeoMind DB. I am however unable to see this index in the maps tab of Kibana. Data from this index is visible and searchable in the discover tab… --- ## [Graph not resolving entities](https://discuss.elastic.co/t/graph-not-resolving-entities/236478)
**Author:** [@philippkahr](https://discuss.elastic.co/u/philippkahr)\ **Replies:** 1\ **Last updated:** [June 10, 2020, 1:43pm UTC](https://discuss.elastic.co/t/graph-not-resolving-entities/236478 "2020-06-10T13:43:35Z")
Hi, I am not sure if the graph is the correct tool to solve my use case Let's say I have the following data structure, it is not time-based. Each row contains a Name and a Permission. I have a total of 4862 rows in my … --- ## [Grant permission on a single dashboard for each user](https://discuss.elastic.co/t/grant-permission-on-a-single-dashboard-for-each-user/236284)
**Author:** [@elisavet](https://discuss.elastic.co/u/elisavet)\ **Replies:** 4\ **Last updated:** [June 10, 2020, 1:42pm UTC](https://discuss.elastic.co/t/grant-permission-on-a-single-dashboard-for-each-user/236284 "2020-06-10T13:42:44Z")
Hello! I want to create dashboard1, dashboard2 from the same index. But I want user1 to have access only to dashboard1 and user2 only to dashboard2. How can I achieve this? Thank you, Elisavet --- ## [Create scripted field error](https://discuss.elastic.co/t/create-scripted-field-error/236471)
**Author:** [@inchirah](https://discuss.elastic.co/u/inchirah)\ **Replies:** 8\ **Last updated:** [June 10, 2020, 1:35pm UTC](https://discuss.elastic.co/t/create-scripted-field-error/236471 "2020-06-10T13:35:10Z")
Hello, I created a script field "attempt complaint" which takes the values \>= -78 from another field "Contrainte" Can anyone tell how I can fixe that? --- ## [Filtering out "managed service accounts"](https://discuss.elastic.co/t/filtering-out-managed-service-accounts/234586)
**Author:** [@ManuelF](https://discuss.elastic.co/u/ManuelF)\ **Replies:** 2\ **Last updated:** [June 10, 2020, 1:26pm UTC](https://discuss.elastic.co/t/filtering-out-managed-service-accounts/234586 "2020-06-10T13:26:26Z")
Hi, Running ELK 6.8.9 on premises I am trying to add a filter for a visualization that removes events containing "managed service accounts" (accounts ending in $ ) like "GKDG0C3$". Solution provided in the following … --- ## [Kibana reporting plugin fails to launch chrome (puppeteer)](https://discuss.elastic.co/t/kibana-reporting-plugin-fails-to-launch-chrome-puppeteer/236195)
**Author:** [@chingis](https://discuss.elastic.co/u/chingis)\ **Replies:** 5\ **Last updated:** [June 10, 2020, 1:18pm UTC](https://discuss.elastic.co/t/kibana-reporting-plugin-fails-to-launch-chrome-puppeteer/236195 "2020-06-10T13:18:57Z")
Hi, I'm running Kibana 7.7.1 in docker and I get the following errors in output: {"tags":\["error","reporting"\],"pid":1,"message":"The Reporting plugin encountered issues launching Chromium in a self-test. You may have t… --- ## [Elastic and Kibana on Different port](https://discuss.elastic.co/t/elastic-and-kibana-on-different-port/235347)
**Author:** [@mastermind](https://discuss.elastic.co/u/mastermind)\ **Replies:** 5\ **Last updated:** [June 10, 2020, 11:49am UTC](https://discuss.elastic.co/t/elastic-and-kibana-on-different-port/235347 "2020-06-10T11:49:20Z")
Hi I am trying to deploy 2 elastic and 2 Kibana on Kubernetes 1- 1st cluster Elastic and Kibana on the default ports (Elastic=9200 and Kibana=5601) configured without any problem. 2- 2nd cluster Elastic2 and Kibana2 on… --- ## [Show Kibana UI login users](https://discuss.elastic.co/t/show-kibana-ui-login-users/236069)
**Author:** [@bdn](https://discuss.elastic.co/u/bdn)\ **Replies:** 3\ **Last updated:** [June 10, 2020, 9:22am UTC](https://discuss.elastic.co/t/show-kibana-ui-login-users/236069 "2020-06-10T09:22:34Z")
How can we find the currently Kibana login users? Is there any log file maintain by Kibana for this or some query can provide the user login details? --- ## [Difference between two aggregations in Kibana. Error](https://discuss.elastic.co/t/difference-between-two-aggregations-in-kibana-error/234988)
**Author:** [@vdalvi](https://discuss.elastic.co/u/vdalvi)\ **Replies:** 3\ **Last updated:** [June 9, 2020, 5:35pm UTC](https://discuss.elastic.co/t/difference-between-two-aggregations-in-kibana-error/234988 "2020-06-09T17:35:28Z")
Hi, I am trying to perform simple difference between the values in two aggregations but unable to do so... Kibana Query { "\_source": false, "query": { "range": { "timestamp": { "gte": "now-90m/m"… --- ## [Line Chart Visualization for Nginx Request and Response Time](https://discuss.elastic.co/t/line-chart-visualization-for-nginx-request-and-response-time/234921)
**Author:** [@prasanna2104](https://discuss.elastic.co/u/prasanna2104)\ **Replies:** 3\ **Last updated:** [June 9, 2020, 5:34pm UTC](https://discuss.elastic.co/t/line-chart-visualization-for-nginx-request-and-response-time/234921 "2020-06-09T17:34:04Z")
Hi Team, I have nginx log which contains request time and response time. I have configured Filebeat which sends the nginx logs to logstash and logstash parse the log and stores in Elasticsearch, I want to create a Line… --- ## [Kibana discover page and dashboard are not refreshing automatically](https://discuss.elastic.co/t/kibana-discover-page-and-dashboard-are-not-refreshing-automatically/234895)
**Author:** [@suresh123](https://discuss.elastic.co/u/suresh123)\ **Replies:** 3\ **Last updated:** [June 9, 2020, 5:31pm UTC](https://discuss.elastic.co/t/kibana-discover-page-and-dashboard-are-not-refreshing-automatically/234895 "2020-06-09T17:31:18Z")
Hi, Kibana discover page and dashboard are not refreshing automatically in version 7.7 (current). --- ## [TASK doesn't support cancellation](https://discuss.elastic.co/t/task-doesnt-support-cancellation/234852)
**Author:** [@realyn\_elastic](https://discuss.elastic.co/u/realyn_elastic)\ **Replies:** 3\ **Last updated:** [June 9, 2020, 5:29pm UTC](https://discuss.elastic.co/t/task-doesnt-support-cancellation/234852 "2020-06-09T17:29:38Z")
Can help to enlighten why I cannot cancel this task { "completed" : false, "task" : { "node" : "Vzjnc-d2SuOZ07\_6LCyl2A", "id" : 4779394, "type" : "transport", "action" : "cluster:admin/xpack/monitoring/bulk", "de… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=475) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=477)