# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=636 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 637 --- ## [Wrong Canvas timezone](https://discuss.elastic.co/t/wrong-canvas-timezone/190221)
**Author:** [@dgonzalezp](https://discuss.elastic.co/u/dgonzalezp)\ **Replies:** 7\ **Last updated:** [July 19, 2019, 2:25pm UTC](https://discuss.elastic.co/t/wrong-canvas-timezone/190221 "2019-07-19T14:25:21Z")
I have created a line graph in canvas but in the time line I got a wrong timezone with the next SQL query: SELECT HISTOGRAM("@timestamp", INTERVAL 1 MINUTES) Hora, ip\_origen, COUNT(ip\_origen) as Cont FROM autenticacion… --- ## [Create new user in kibana](https://discuss.elastic.co/t/create-new-user-in-kibana/190952)
**Author:** [@Melok](https://discuss.elastic.co/u/Melok)\ **Replies:** 9\ **Last updated:** [July 19, 2019, 1:17pm UTC](https://discuss.elastic.co/t/create-new-user-in-kibana/190952 "2019-07-19T13:17:12Z")
I am trying to create a new user with the privilege kibana-user. But when I log in, I get an Oops error! Error. Try again. --- ## [Kibana 7 can't load index pattern](https://discuss.elastic.co/t/kibana-7-cant-load-index-pattern/180167)
**Author:** [@Jehutywong](https://discuss.elastic.co/u/Jehutywong)\ **Replies:** 21\ **Last updated:** [July 19, 2019, 11:53am UTC](https://discuss.elastic.co/t/kibana-7-cant-load-index-pattern/180167 "2019-07-19T11:53:43Z")
Kibana: 7.0.1 ES: 7.0.1 When i create index pattern in Kibana, it can load the fields in the indexes. However, when i go to discovery page, it prompts me "In order to visualize and explore data in Kibana, you'll need t… --- ## [Objects in array are not well supported](https://discuss.elastic.co/t/objects-in-array-are-not-well-supported/191315)
**Author:** [@Mitali](https://discuss.elastic.co/u/Mitali)\ **Replies:** 1\ **Last updated:** [July 19, 2019, 10:19am UTC](https://discuss.elastic.co/t/objects-in-array-are-not-well-supported/191315 "2019-07-19T10:19:52Z")
'Objects in array are not well supported'. What does this error exactly mean as I am able to apply aggregation and search queries on my nested data. So, in what use cases, does this error pose a problem? --- ## [Authentification in Kibana interface](https://discuss.elastic.co/t/authentification-in-kibana-interface/191138)
**Author:** [@John33000](https://discuss.elastic.co/u/John33000)\ **Replies:** 3\ **Last updated:** [July 19, 2019, 10:19am UTC](https://discuss.elastic.co/t/authentification-in-kibana-interface/191138 "2019-07-19T10:19:25Z")
Hi, I use Wazuh 3.9.2 for Kibana 6.8.0 and Elasticsearch 6.8. When I going in my Kibana interface I don't have prompt with login and password. But in kibana.yml I put : elasticsearch.username and password . But nothing… --- ## [Kibana not on JVM compatbility matrix?](https://discuss.elastic.co/t/kibana-not-on-jvm-compatbility-matrix/191362)
**Author:** [@i333](https://discuss.elastic.co/u/i333)\ **Replies:** 1\ **Last updated:** [July 19, 2019, 10:15am UTC](https://discuss.elastic.co/t/kibana-not-on-jvm-compatbility-matrix/191362 "2019-07-19T10:15:53Z")
https://www.elastic.co/support/matrix#matrix\_jvm doesn't have Kibana but shouldn't it be there? Doesn't it use Java? Which versions of Java are compatible with latest version of Kibana? --- ## [Post Json with mapping](https://discuss.elastic.co/t/post-json-with-mapping/191364)
**Author:** [@Chris4](https://discuss.elastic.co/u/Chris4)\ **Replies:** 1\ **Last updated:** [July 19, 2019, 10:15am UTC](https://discuss.elastic.co/t/post-json-with-mapping/191364 "2019-07-19T10:15:21Z")
How can i insert a json and directly have new values mapped in correct format ? e.g. the field "amount" is not yet in my index and hence also not yet mapped. My index is having a lot of different values with a mapping a… --- ## [How to calculate Avg of a duration in Timelion](https://discuss.elastic.co/t/how-to-calculate-avg-of-a-duration-in-timelion/189605)
**Author:** [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\ **Replies:** 1\ **Last updated:** [July 19, 2019, 10:14am UTC](https://discuss.elastic.co/t/how-to-calculate-avg-of-a-duration-in-timelion/189605 "2019-07-19T10:14:31Z")
I want to know the exact command for calculating the average of a duration. For now I used the following code to get the average. Wonder why is it showing me the count of the average but not the average itself ".es(inde… --- ## [Dashboard background color issue](https://discuss.elastic.co/t/dashboard-background-color-issue/190148)
**Author:** [@June](https://discuss.elastic.co/u/June)\ **Replies:** 2\ **Last updated:** [July 19, 2019, 9:13am UTC](https://discuss.elastic.co/t/dashboard-background-color-issue/190148 "2019-07-19T09:13:01Z")
Greetings! For version 7.1.1, the background color of the dashboard cannot change to "dark" although the setting is changed as shown below: Can anyone help on this? Thanks! --- ## [Make maps lighter in dark mode](https://discuss.elastic.co/t/make-maps-lighter-in-dark-mode/191166)
**Author:** [@Hoan\_Le](https://discuss.elastic.co/u/Hoan_Le)\ **Replies:** 2\ **Last updated:** [July 19, 2019, 8:12am UTC](https://discuss.elastic.co/t/make-maps-lighter-in-dark-mode/191166 "2019-07-19T08:12:08Z")
Hi all, I am using kibana 7.2. I just wanna make the coordinate map and region map look lighter. I think it is too dark. Thanks --- ## [Kibana not recognize long as number](https://discuss.elastic.co/t/kibana-not-recognize-long-as-number/190991)
**Author:** [@daniel.velasco](https://discuss.elastic.co/u/daniel.velasco)\ **Replies:** 2\ **Last updated:** [July 19, 2019, 7:26am UTC](https://discuss.elastic.co/t/kibana-not-recognize-long-as-number/190991 "2019-07-19T07:26:44Z")
Hi, I'm insert amounts from spark to elastic for consult from elastic. The amounts are well inserted but in kibana this values can´t use as amounts for make metrics (sum, max, medians...). The code in spark is this: v… --- ## [Canvas: Dropdown filter not updating elements without page reload](https://discuss.elastic.co/t/canvas-dropdown-filter-not-updating-elements-without-page-reload/186021)
**Author:** [@Yoann\_Toussaint](https://discuss.elastic.co/u/Yoann_Toussaint)\ **Replies:** 9\ **Last updated:** [July 19, 2019, 7:01am UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-updating-elements-without-page-reload/186021 "2019-07-19T07:01:10Z")
Hello there, I am using 3 dropdown filters scattered on 4 pages. Selecting one filter updates the elements inside the workpad but sometimes after switching from one page to another selecting one dropdown filter does not… --- ## [\[Resolved\]Script is invalid for doc\['kf4'\].value + '-' + doc\['kf5'\].value](https://discuss.elastic.co/t/resolved-script-is-invalid-for-doc-kf4-value-doc-kf5-value/190651)
**Author:** [@cheriemilk](https://discuss.elastic.co/u/cheriemilk)\ **Replies:** 2\ **Last updated:** [July 19, 2019, 6:59am UTC](https://discuss.elastic.co/t/resolved-script-is-invalid-for-doc-kf4-value-doc-kf5-value/190651 "2019-07-19T06:59:55Z")
Hi Team, In created a script field in kibana-\>Index Patter-\>Create script field with script is doc\['kf4'\].value + '-' + doc\['kf5'\].value When I save the field, it tells me that 'Script is invalid.' Please refer to… --- ## [Docker Kibana: Cannot connect to the Elasticsearch cluster currently configured for Kibana](https://discuss.elastic.co/t/docker-kibana-cannot-connect-to-the-elasticsearch-cluster-currently-configured-for-kibana/190961)
**Author:** [@Philip\_Colmer](https://discuss.elastic.co/u/Philip_Colmer)\ **Replies:** 2\ **Last updated:** [July 19, 2019, 6:47am UTC](https://discuss.elastic.co/t/docker-kibana-cannot-connect-to-the-elasticsearch-cluster-currently-configured-for-kibana/190961 "2019-07-19T06:47:51Z")
I'm using the Docker image for Kibana 7.2.0. I'm trying to connect it to an Elasticsearch Docker container as part of the following docker-compose file: version: "3" services: fess: image: codelibs/fess:13.2 r… --- ## [Timestamp between now and now-24h](https://discuss.elastic.co/t/timestamp-between-now-and-now-24h/190739)
**Author:** [@Digital](https://discuss.elastic.co/u/Digital)\ **Replies:** 7\ **Last updated:** [July 19, 2019, 5:17am UTC](https://discuss.elastic.co/t/timestamp-between-now-and-now-24h/190739 "2019-07-19T05:17:00Z")
Hello, Currently I used a curl to get the data on one index. But now I would like to receive the data between now, now-24h. However I receive only 10 data :confused: when I see the same time rang on Kibana I can see a … --- ## [Kibana sorting problem](https://discuss.elastic.co/t/kibana-sorting-problem/191276)
**Author:** [@csholic](https://discuss.elastic.co/u/csholic)\ **Replies:** 2\ **Last updated:** [July 18, 2019, 11:51pm UTC](https://discuss.elastic.co/t/kibana-sorting-problem/191276 "2019-07-18T23:51:45Z")
Hi, I built a table of our products using Kibana, I select order by alphabetical. However, as you can see from the picture, Rome is above Abacus, Ballista which is not ideal. Another problem is 2019-07-05 appears on th… --- ## [Kibana 6.7 embed=true broken](https://discuss.elastic.co/t/kibana-6-7-embed-true-broken/191099)
**Author:** [@kimyx](https://discuss.elastic.co/u/kimyx)\ **Replies:** 3\ **Last updated:** [July 18, 2019, 11:45pm UTC](https://discuss.elastic.co/t/kibana-6-7-embed-true-broken/191099 "2019-07-18T23:45:18Z")
We've just upgraded a successful ELK installation from 6.2.2 to 6.7.0. We embed dashboards into a website using iframes. We're finding that the embed=true option no longer hides the left sidebar, or the top menu options … --- ## [Timelion with live streaming](https://discuss.elastic.co/t/timelion-with-live-streaming/190323)
**Author:** [@areyja](https://discuss.elastic.co/u/areyja)\ **Replies:** 2\ **Last updated:** [July 18, 2019, 6:43pm UTC](https://discuss.elastic.co/t/timelion-with-live-streaming/190323 "2019-07-18T18:43:12Z")
Hello ELK Gurus, Pl excuse my ignorance if this is very common issue and mistakes I am doing. I am 1 week into ELK. I have set ELK on a single RHEL server. I have jdbc input from logstash sending data to elastic. I too… --- ## [Kibana FATAL Error: \[elasticsearch.url\]: definition for this key is missing](https://discuss.elastic.co/t/kibana-fatal-error-elasticsearch-url-definition-for-this-key-is-missing/190087)
**Author:** [@Ryan\_Downey](https://discuss.elastic.co/u/Ryan_Downey)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 7:33pm UTC](https://discuss.elastic.co/t/kibana-fatal-error-elasticsearch-url-definition-for-this-key-is-missing/190087 "2019-07-11T19:33:20Z")
Just upgraded a node from 6.8.1 to 7.2.0 and I'm getting the error message right after I start with journalctl that states Jul 11 14:10:30 dch1092ql5app kibana\[25880\]: FATAL Error: \[elasticsearch.url\]: definition for t… --- ## [Geopoint on Region Map](https://discuss.elastic.co/t/geopoint-on-region-map/190242)
**Author:** [@naknak987](https://discuss.elastic.co/u/naknak987)\ **Replies:** 9\ **Last updated:** [July 18, 2019, 5:45pm UTC](https://discuss.elastic.co/t/geopoint-on-region-map/190242 "2019-07-18T17:45:42Z")
Is it possible to plot geopoints and highlight regions in the same map? I would like to build a map that shows both our facility locations and highlight our customer zip codes. I can already do both of of these things in… --- ## [How to show job count during all the time it was running?](https://discuss.elastic.co/t/how-to-show-job-count-during-all-the-time-it-was-running/191192)
**Author:** [@nadavh](https://discuss.elastic.co/u/nadavh)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 5:45pm UTC](https://discuss.elastic.co/t/how-to-show-job-count-during-all-the-time-it-was-running/191192 "2019-07-18T17:45:04Z")
Hey, I have index of jobs which run in our system with their start time and total time fields. How do I show in vertical bars or other form of visual their stat through time, meaning when Kibana count the job when ever… --- ## [Scroll Bar for Bart Chart](https://discuss.elastic.co/t/scroll-bar-for-bart-chart/191089)
**Author:** [@nhbala](https://discuss.elastic.co/u/nhbala)\ **Replies:** 4\ **Last updated:** [July 18, 2019, 5:40pm UTC](https://discuss.elastic.co/t/scroll-bar-for-bart-chart/191089 "2019-07-18T17:40:09Z")
I was wondering if there was a way to enable a scroll bar for bar charts? I have a lot of of categories on my x Axis that I want to represent, but they become unreadable with the amount of categories. --- ## [Dashboard for 3 level of aggregation in kibana](https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186)
**Author:** [@A\_google\_user](https://discuss.elastic.co/u/A_google_user)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 5:32pm UTC](https://discuss.elastic.co/t/dashboard-for-3-level-of-aggregation-in-kibana/191186 "2019-07-18T17:32:27Z")
I have a document type doc1 { event\_timestamp: event\_type: store\_id: } GET /internship40/\_search { "query": { "bool": { "must": \[ { "match" : { … --- ## [Visualization with unique count of fields combination](https://discuss.elastic.co/t/visualization-with-unique-count-of-fields-combination/191107)
**Author:** [@henrix](https://discuss.elastic.co/u/henrix)\ **Replies:** 2\ **Last updated:** [July 18, 2019, 5:20pm UTC](https://discuss.elastic.co/t/visualization-with-unique-count-of-fields-combination/191107 "2019-07-18T17:20:15Z")
Hi everyone, I'm trying to create a visualization of a cardinality aggregation on two fields but haven't found a proper way to do it yet. I'm fairly new to the Elastic stack so bear with me :slight\_smile: I have this q… --- ## [Kibana 7.1.1 still running after upgrading ElasticCloud to 7.2](https://discuss.elastic.co/t/kibana-7-1-1-still-running-after-upgrading-elasticcloud-to-7-2/191176)
**Author:** [@gbarnett](https://discuss.elastic.co/u/gbarnett)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 5:16pm UTC](https://discuss.elastic.co/t/kibana-7-1-1-still-running-after-upgrading-elasticcloud-to-7-2/191176 "2019-07-18T17:16:54Z")
After upgrading our ElasticCloud instance from 7.1.1 to 7.2, launching Kibana still launches 7.1.1 of Kibana. ElasticCloud does show that the instance is a 7.2 instance, but Kibana, after being launched, continues to sh… --- ## [Problem with index-pattern id when recreating index](https://discuss.elastic.co/t/problem-with-index-pattern-id-when-recreating-index/191087)
**Author:** [@jjfbcn](https://discuss.elastic.co/u/jjfbcn)\ **Replies:** 2\ **Last updated:** [July 18, 2019, 5:14pm UTC](https://discuss.elastic.co/t/problem-with-index-pattern-id-when-recreating-index/191087 "2019-07-18T17:14:07Z")
After recreating index stats-\* all the saved objects (visualizations, dashboards,...) are failing to load with error: Could not locate that index-pattern (id: 70ea4880-815b-11e9-a33a-156632c3253a), click here to re-crea… --- ## [Tooltip Time Series Kibana](https://discuss.elastic.co/t/tooltip-time-series-kibana/191144)
**Author:** [@Paulo64](https://discuss.elastic.co/u/Paulo64)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 5:04pm UTC](https://discuss.elastic.co/t/tooltip-time-series-kibana/191144 "2019-07-18T17:04:54Z")
Hello, I am using Kibana 7.1.1 in Dark Mode for Time Series Vizualizations. I regret that when hovering a curve : The tooltip does not show the data for all curves of the graph but only the one hovered. (Motor temp… --- ## [Switching Annotations On/Off \[TSVB\]](https://discuss.elastic.co/t/switching-annotations-on-off-tsvb/191006)
**Author:** [@PeterPain](https://discuss.elastic.co/u/PeterPain)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 4:55pm UTC](https://discuss.elastic.co/t/switching-annotations-on-off-tsvb/191006 "2019-07-18T16:55:01Z")
Hey dear Elastic-Team, Is it possible to switch the Annotations in the Time Series Visual Builder on and off ? I Just have the Problem, that if im looking at a longer period of time. My Visualisation is full of Annota… --- ## [Kibana 7.1.0 Data Table Split Twice by Table](https://discuss.elastic.co/t/kibana-7-1-0-data-table-split-twice-by-table/190840)
**Author:** [@Trevor\_Condon](https://discuss.elastic.co/u/Trevor_Condon)\ **Replies:** 2\ **Last updated:** [July 18, 2019, 4:39pm UTC](https://discuss.elastic.co/t/kibana-7-1-0-data-table-split-twice-by-table/190840 "2019-07-18T16:39:16Z")
Switched over from Kibana 6.3.1 to Kibana 7.2.0 and it looks like there was a change to the Data Table visualization. In 6.x.x we could split a Data Table viz by table twice in order to split into columns twice. Now ther… --- ## [CSP with Nginx proxy](https://discuss.elastic.co/t/csp-with-nginx-proxy/190319)
**Author:** [@pyjou](https://discuss.elastic.co/u/pyjou)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 3:47pm UTC](https://discuss.elastic.co/t/csp-with-nginx-proxy/190319 "2019-07-18T15:47:43Z")
When I want to get a maps on my browser. Kibana don't show the map and send this error message : Refused to execute inline script because it violates the following Content Security Policy directive: "script-src 'unsafe-… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=635) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=637)