# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=464 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 465 --- ## [How can I show average by 2 month from TSVB?](https://discuss.elastic.co/t/how-can-i-show-average-by-2-month-from-tsvb/234675)
**Author:** [@Ethonwu](https://discuss.elastic.co/u/Ethonwu)\ **Replies:** 2\ **Last updated:** [June 30, 2020, 8:26am UTC](https://discuss.elastic.co/t/how-can-i-show-average-by-2-month-from-tsvb/234675 "2020-06-30T08:26:44Z")
Hello , I am ELK rookie I have a small question wanna ask here How can I show average by 2 month from TSVB ? Here is sample data like this : date Execution Time Job Name 20200102 … --- ## [Is it possible to add threshold line on Lens in Kibana 7.6?](https://discuss.elastic.co/t/is-it-possible-to-add-threshold-line-on-lens-in-kibana-7-6/238213)
**Author:** [@mmk1995](https://discuss.elastic.co/u/mmk1995)\ **Replies:** 3\ **Last updated:** [June 30, 2020, 7:56am UTC](https://discuss.elastic.co/t/is-it-possible-to-add-threshold-line-on-lens-in-kibana-7-6/238213 "2020-06-30T07:56:56Z")
There is no metrics and axes option in Lens visualization. Is it possible to add threshold line on Lens in Kibana 7.6? Thank you. --- ## [If else Painless Script on a Painless Scripted Field](https://discuss.elastic.co/t/if-else-painless-script-on-a-painless-scripted-field/238615)
**Author:** [@edbautista](https://discuss.elastic.co/u/edbautista)\ **Replies:** 4\ **Last updated:** [June 30, 2020, 4:08am UTC](https://discuss.elastic.co/t/if-else-painless-script-on-a-painless-scripted-field/238615 "2020-06-30T04:08:54Z")
Hi. Our team made a scripted field for time difference called "time". We have a new use case where if the value in "time" is greater than 8hours, it will return as 'Yes' and if not 'No'. The value for 'time' is set to mi… --- ## [Dashboard Filters Don't Get Applied To Timelion](https://discuss.elastic.co/t/dashboard-filters-dont-get-applied-to-timelion/235088)
**Author:** [@Alsheh](https://discuss.elastic.co/u/Alsheh)\ **Replies:** 2\ **Last updated:** [June 30, 2020, 12:07am UTC](https://discuss.elastic.co/t/dashboard-filters-dont-get-applied-to-timelion/235088 "2020-06-30T00:07:03Z")
In Kibana 6.8.2 dashboards filters get applied to Timelion visualizations. However, after upgrading to Kibana 7.7.0, dashboards filters don't seem to be applied to Timelion visualizations. Is this a bug or expected behav… --- ## [No kibana-oss image available for 6.6.1 version](https://discuss.elastic.co/t/no-kibana-oss-image-available-for-6-6-1-version/239014)
**Author:** [@chinmoy\_padhi](https://discuss.elastic.co/u/chinmoy_padhi)\ **Replies:** 1\ **Last updated:** [June 29, 2020, 9:17pm UTC](https://discuss.elastic.co/t/no-kibana-oss-image-available-for-6-6-1-version/239014 "2020-06-29T21:17:52Z")
Currently on production we are running kibana-oss:6.2.2 when we run the security scan we found some vulnerabilities related to cross-site-scripting,timelion visualizer,security audit logger and such issues are mentioned … --- ## [Can not start Kibana if the default port for elasticsearch is changed](https://discuss.elastic.co/t/can-not-start-kibana-if-the-default-port-for-elasticsearch-is-changed/238697)
**Author:** [@ashrafuzzaman](https://discuss.elastic.co/u/ashrafuzzaman)\ **Replies:** 1\ **Last updated:** [June 29, 2020, 7:49pm UTC](https://discuss.elastic.co/t/can-not-start-kibana-if-the-default-port-for-elasticsearch-is-changed/238697 "2020-06-29T19:49:06Z")
I am using the composer shared here. The composer works until I change the default port of elasticsearch to something else and updating the port reference. Here is my compose file, version: '2.2' services: apm-serve… --- ## [How to create a default index pattern via kibana api](https://discuss.elastic.co/t/how-to-create-a-default-index-pattern-via-kibana-api/238905)
**Author:** [@damasu](https://discuss.elastic.co/u/damasu)\ **Replies:** 2\ **Last updated:** [June 29, 2020, 7:19pm UTC](https://discuss.elastic.co/t/how-to-create-a-default-index-pattern-via-kibana-api/238905 "2020-06-29T19:19:10Z")
Using the experimental Kibana 7.8 API, how can i create a DEFAULT index pattern. I am calling the api as such: http://kibana:5601/s/\/api/saved\_objects/index-pattern/dummy\_index\_pattern { "attributes": { … --- ## [Value in Table and JSON are different](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135)
**Author:** [@ranju](https://discuss.elastic.co/u/ranju)\ **Replies:** 2\ **Last updated:** [June 29, 2020, 4:30pm UTC](https://discuss.elastic.co/t/value-in-table-and-json-are-different/239135 "2020-06-29T16:30:19Z")
Facing This Issue in JSON the value "test": { "test\_id": "1111111111111180522" }, in Kibana table showing as: 1111111111111180526 --- ## [Time Based Index Query Performance](https://discuss.elastic.co/t/time-based-index-query-performance/239154)
**Author:** [@Derek\_Gallo](https://discuss.elastic.co/u/Derek_Gallo)\ **Replies:** 1\ **Last updated:** [June 29, 2020, 4:23pm UTC](https://discuss.elastic.co/t/time-based-index-query-performance/239154 "2020-06-29T16:23:33Z")
I was reading through this old thread: https://discuss.elastic.co/t/kibana-search-performance-over-time-based-indices/168617. Based on the dialog in that thread, it seems that the latest versions of ES/Kibana should aut… --- ## [Question about building a MAP Visualization Object](https://discuss.elastic.co/t/question-about-building-a-map-visualization-object/239018)
**Author:** [@rafaell2](https://discuss.elastic.co/u/rafaell2)\ **Replies:** 1\ **Last updated:** [June 29, 2020, 12:44pm UTC](https://discuss.elastic.co/t/question-about-building-a-map-visualization-object/239018 "2020-06-29T12:44:42Z")
Hi, new on this so apologize if i am not asking the right question here. I am trying to add a MAP LAYER (EMS Boundaries type) for World Countries (using Kibana 7.8) by using my index built through logstash Jdbc Oracle Da… --- ## [How to pass High CPU Process Name in Kibana Alert Action](https://discuss.elastic.co/t/how-to-pass-high-cpu-process-name-in-kibana-alert-action/239105)
**Author:** [@Ranjan\_Bansal](https://discuss.elastic.co/u/Ranjan_Bansal)\ **Replies:** 0\ **Last updated:** [June 29, 2020, 11:36am UTC](https://discuss.elastic.co/t/how-to-pass-high-cpu-process-name-in-kibana-alert-action/239105 "2020-06-29T11:36:44Z")
Hi , As part of preventive monitoring through Kibana 7.7, we triggered an alert and used action WebHook. We were able to send Server Name, which triggered the alert, in the Body. We need to pass the process name as well… --- ## [POST method to create role and grant privilege in spaces](https://discuss.elastic.co/t/post-method-to-create-role-and-grant-privilege-in-spaces/237995)
**Author:** [@nameisnotimportant](https://discuss.elastic.co/u/nameisnotimportant)\ **Replies:** 2\ **Last updated:** [June 29, 2020, 11:05am UTC](https://discuss.elastic.co/t/post-method-to-create-role-and-grant-privilege-in-spaces/237995 "2020-06-29T11:05:13Z")
Hi, I am trying to figure out how to user DevTools to create role and grant privilege to spaces. I tried with below codes but it says failed to parse role \[QA\]. unexpected field \[spaces\]. May i know where can i find the… --- ## [Why the color rendering is so different in Kibana?](https://discuss.elastic.co/t/why-the-color-rendering-is-so-different-in-kibana/239043)
**Author:** [@zhangyongzhe20](https://discuss.elastic.co/u/zhangyongzhe20)\ **Replies:** 3\ **Last updated:** [June 29, 2020, 9:20am UTC](https://discuss.elastic.co/t/why-the-color-rendering-is-so-different-in-kibana/239043 "2020-06-29T09:20:37Z")
Recently, I noticed the diagram generated by the same color schema in Vega editor and Kibana vega is so different? I put the two screenshots for comparsion, one is in Vega editor and the other is in Kibana. Anyone can… --- ## [Looking for kibana 6 config.js equivalent in 7.8](https://discuss.elastic.co/t/looking-for-kibana-6-config-js-equivalent-in-7-8/239069)
**Author:** [@MarcoRocco](https://discuss.elastic.co/u/MarcoRocco)\ **Replies:** 2\ **Last updated:** [June 29, 2020, 8:31am UTC](https://discuss.elastic.co/t/looking-for-kibana-6-config-js-equivalent-in-7-8/239069 "2020-06-29T08:31:27Z")
Hey guys, I've been looking through the kibana 7.8 codebase for a place to store some variables that would be widely available one instantiated. In my previous custom kibana 6 version, I've used the config object to stor… --- ## [.kibana\_1 and .kibana\_2 index diffrence](https://discuss.elastic.co/t/kibana-1-and-kibana-2-index-diffrence/238989)
**Author:** [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Replies:** 1\ **Last updated:** [June 29, 2020, 8:17am UTC](https://discuss.elastic.co/t/kibana-1-and-kibana-2-index-diffrence/238989 "2020-06-29T08:17:10Z")
Hello, can someone explain me the diffrence between .kibana\_1 and .kibana\_2 index. Regards --- ## [7.8v Dashboard file is not working on 7.7.1v of Kibana](https://discuss.elastic.co/t/7-8v-dashboard-file-is-not-working-on-7-7-1v-of-kibana/238826)
**Author:** [@manojkrishna561994](https://discuss.elastic.co/u/manojkrishna561994)\ **Replies:** 5\ **Last updated:** [June 29, 2020, 7:48am UTC](https://discuss.elastic.co/t/7-8v-dashboard-file-is-not-working-on-7-7-1v-of-kibana/238826 "2020-06-29T07:48:13Z")
When i try to download the dashboard file from Kibana 7.8v and import it into kibana 7.7.1v it is showing me that there is some error. Do i have to change anything in 7.8th version of Kibana dashboard to work on 7.7.1 --- ## [Watcher for report with attachment failed due to ssl handshake exception](https://discuss.elastic.co/t/watcher-for-report-with-attachment-failed-due-to-ssl-handshake-exception/238924)
**Author:** [@vinayak](https://discuss.elastic.co/u/vinayak)\ **Replies:** 3\ **Last updated:** [June 29, 2020, 7:08am UTC](https://discuss.elastic.co/t/watcher-for-report-with-attachment-failed-due-to-ssl-handshake-exception/238924 "2020-06-29T07:08:47Z")
Unable to send reporting attachment by the help of watcher. My watch query : PUT \_watcher/watch/sample\_report\_ssl { "trigger" : { "schedule": { "interval": "1m" } }, "actions" : { "email\_admin" … --- ## [Read data from ElasticSearch data using vega](https://discuss.elastic.co/t/read-data-from-elasticsearch-data-using-vega/238670)
**Author:** [@issaissa](https://discuss.elastic.co/u/issaissa)\ **Replies:** 6\ **Last updated:** [June 29, 2020, 6:39am UTC](https://discuss.elastic.co/t/read-data-from-elasticsearch-data-using-vega/238670 "2020-06-29T06:39:14Z")
This is my vega code: { $schema: https://vega.github.io/schema/vega-lite/v2.json data: { url: { %context%: true %timefield%: "incident\_date\_time" index: incident\* body: { … --- ## [Kibana Calculate Difference in Percentage Between 2 Values](https://discuss.elastic.co/t/kibana-calculate-difference-in-percentage-between-2-values/239056)
**Author:** [@muthucse](https://discuss.elastic.co/u/muthucse)\ **Replies:** 0\ **Last updated:** [June 29, 2020, 5:23am UTC](https://discuss.elastic.co/t/kibana-calculate-difference-in-percentage-between-2-values/239056 "2020-06-29T05:23:05Z")
Hello All, I was trying to calculate the difference in percentage. Not able to do in kibana with the below values. Last 7 day avg. (5) Today's avg. (2.5) Difference in Percentage: 100 % How to achieve this ? --- ## [Can not run kibana by source code](https://discuss.elastic.co/t/can-not-run-kibana-by-source-code/238397)
**Author:** [@Fent](https://discuss.elastic.co/u/Fent)\ **Replies:** 6\ **Last updated:** [June 29, 2020, 3:44am UTC](https://discuss.elastic.co/t/can-not-run-kibana-by-source-code/238397 "2020-06-29T03:44:27Z")
Hi, I try to run kibana by source code ,but it seem no work well This my step: Step1 Download the kibana source code download from https://github.com/elastic/kibana/archive/v7.4.2.zip and unzip to d:\\elk\\kibana … --- ## [Add format to docvalues in elasticsearch js client request](https://discuss.elastic.co/t/add-format-to-docvalues-in-elasticsearch-js-client-request/239045)
**Author:** [@sudosu](https://discuss.elastic.co/u/sudosu)\ **Replies:** 0\ **Last updated:** [June 29, 2020, 3:09am UTC](https://discuss.elastic.co/t/add-format-to-docvalues-in-elasticsearch-js-client-request/239045 "2020-06-29T03:09:50Z")
Hi, Using the Elasticsearch client js, I am able to add the doc values to the request like so: callWithRequest(\_req, 'search', { index: indexPatternTitle, scroll: '1m', body: body, docvalue\_fields:'time… --- ## [How to improve the accuracy of Unique Count metric in Kibana](https://discuss.elastic.co/t/how-to-improve-the-accuracy-of-unique-count-metric-in-kibana/239012)
**Author:** [@pk.241011](https://discuss.elastic.co/u/pk.241011)\ **Replies:** 3\ **Last updated:** [June 29, 2020, 2:29am UTC](https://discuss.elastic.co/t/how-to-improve-the-accuracy-of-unique-count-metric-in-kibana/239012 "2020-06-29T02:29:00Z")
Hi, I am seeing some differences in the counts. Background: Number of documents: 1,384,896 Unique counts of fields A, B and C are reported as : 3641, 3791, 3799 With {"precision\_threshold":40000} Unique counts of fie… --- ## [\[Kibana\] How to divide using the sum of two columns?](https://discuss.elastic.co/t/kibana-how-to-divide-using-the-sum-of-two-columns/239037)
**Author:** [@skyskai](https://discuss.elastic.co/u/skyskai)\ **Replies:** 0\ **Last updated:** [June 29, 2020, 1:31am UTC](https://discuss.elastic.co/t/kibana-how-to-divide-using-the-sum-of-two-columns/239037 "2020-06-29T01:31:26Z")
I want to construct a new column by dividing the sum of column A by the sum of column B as shown below. '--------------------------------------------------------------------------------- | Date | Sum of Col A… --- ## [Can any kibana version greater than 6.5 be used to connect to elasticsearch 6.5?](https://discuss.elastic.co/t/can-any-kibana-version-greater-than-6-5-be-used-to-connect-to-elasticsearch-6-5/239033)
**Author:** [@dimitris\_sb](https://discuss.elastic.co/u/dimitris_sb)\ **Replies:** 1\ **Last updated:** [June 28, 2020, 9:51pm UTC](https://discuss.elastic.co/t/can-any-kibana-version-greater-than-6-5-be-used-to-connect-to-elasticsearch-6-5/239033 "2020-06-28T21:51:31Z")
Can any kibana version greater than 6.5 (e.g. 6.7, 6.8 or 7.x) be used to connect to elasticsearch 6.5? My understanding is that they should be compatible (same version with elasticsearch). Is it true? Thank you in adv… --- ## [Can we delete .monitoring-kibana (disk issue) - red shard](https://discuss.elastic.co/t/can-we-delete-monitoring-kibana-disk-issue-red-shard/238731)
**Author:** [@dimitris\_sb](https://discuss.elastic.co/u/dimitris_sb)\ **Replies:** 1\ **Last updated:** [June 28, 2020, 9:28pm UTC](https://discuss.elastic.co/t/can-we-delete-monitoring-kibana-disk-issue-red-shard/238731 "2020-06-28T21:28:40Z")
Could I delete .monitoring-kibana\_2020.MM.dd system index? I experienced a disk failure which damaged the lvm and after fixing this some system shards are corrupted blocking indexing. Thank you in advance! --- ## [How use DataTable or any component of Visualization to build below report](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840)
**Author:** [@jaytran](https://discuss.elastic.co/u/jaytran)\ **Replies:** 4\ **Last updated:** [June 28, 2020, 3:05pm UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840 "2020-06-28T15:05:46Z")
Hi all, I have below data: "hits" : \[ { "\_index" : "test-2020.05", "\_source" : { "@version" : "1", "status" : "DONE", "level" : "ERROR" } }, { "\_index" : "test-2020.05", "\_s… --- ## [Logs UI with cross cluster search](https://discuss.elastic.co/t/logs-ui-with-cross-cluster-search/239009)
**Author:** [@a3984](https://discuss.elastic.co/u/a3984)\ **Replies:** 0\ **Last updated:** [June 28, 2020, 1:08pm UTC](https://discuss.elastic.co/t/logs-ui-with-cross-cluster-search/239009 "2020-06-28T13:08:45Z")
I have created a cross cluster search configuration where I have one kibana/elasticsearch connecting to two other elasticsearch instances using cross cluster search. I know that it is configured correctly as I have crea… --- ## [Need server/system serial number output in kibana dashboard](https://discuss.elastic.co/t/need-server-system-serial-number-output-in-kibana-dashboard/238949)
**Author:** [@D\_ELK](https://discuss.elastic.co/u/D_ELK)\ **Replies:** 3\ **Last updated:** [June 28, 2020, 10:54am UTC](https://discuss.elastic.co/t/need-server-system-serial-number-output-in-kibana-dashboard/238949 "2020-06-28T10:54:07Z")
Hi, I have build my ELK stack on local machine (ELK version- 6.8.10) . In order to get more details like machine/server serial number, I have added few entries in filebeat.yml file. After adding few lines under add\_h… --- ## [Refused to load the script 'https://maps.googleapis.com/...' because it violates the following Content Security Policy directive:](https://discuss.elastic.co/t/refused-to-load-the-script-https-maps-googleapis-com-because-it-violates-the-following-content-security-policy-directive/238954)
**Author:** [@Raja\_SP](https://discuss.elastic.co/u/Raja_SP)\ **Replies:** 1\ **Last updated:** [June 27, 2020, 3:28pm UTC](https://discuss.elastic.co/t/refused-to-load-the-script-https-maps-googleapis-com-because-it-violates-the-following-content-security-policy-directive/238954 "2020-06-27T15:28:58Z")
Hi, I am developing a plugin that uses googlemaps api for geofencing purposes. I have the csp.rules configured in kibana.yml as below: csp.rules: "script-src 'unsafe-eval' 'self' 'https://maps.googleapis.com'" "worker… --- ## [Visualize command history](https://discuss.elastic.co/t/visualize-command-history/238892)
**Author:** [@elk6](https://discuss.elastic.co/u/elk6)\ **Replies:** 1\ **Last updated:** [June 27, 2020, 2:10pm UTC](https://discuss.elastic.co/t/visualize-command-history/238892 "2020-06-27T14:10:12Z")
I'm a complete noob at Elastic Stack. I need to display command history in kibana in an easy to read format, I'm looking for something like this. For that, I've set auditbeat with this rule to log every command someone r… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=463) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=465)