# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=867 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 868 --- ## [Kibana AVG last hour](https://discuss.elastic.co/t/kibana-avg-last-hour/119958)
**Author:** [@User\_2\_Guest\_Incomin](https://discuss.elastic.co/u/User_2_Guest_Incomin)\ **Replies:** 3\ **Last updated:** [February 16, 2018, 2:19pm UTC](https://discuss.elastic.co/t/kibana-avg-last-hour/119958 "2018-02-16T14:19:46Z")
Hi there, I'm trying to create a line chart that shows the average of field1(number field) in the last hour but showing an interval in minutes from field2 (date field), when I try to do with "Date Histogram", field2, i… --- ## [How to do case-insensitive search for a field value?](https://discuss.elastic.co/t/how-to-do-case-insensitive-search-for-a-field-value/120002)
**Author:** [@Jeremy\_C](https://discuss.elastic.co/u/Jeremy_C)\ **Replies:** 7\ **Last updated:** [February 16, 2018, 2:18pm UTC](https://discuss.elastic.co/t/how-to-do-case-insensitive-search-for-a-field-value/120002 "2018-02-16T14:18:11Z")
In Kibana's Discover page search, if I just type "server1" then it does a case-insensitive search. But if I do "beat.hostname: server1" then that's a case-sensitive search. How do I do I make that case-insensitive? I'… --- ## [Kibana Request Timeout after 3000ms](https://discuss.elastic.co/t/kibana-request-timeout-after-3000ms/120004)
**Author:** [@atom](https://discuss.elastic.co/u/atom)\ **Replies:** 4\ **Last updated:** [February 16, 2018, 2:12pm UTC](https://discuss.elastic.co/t/kibana-request-timeout-after-3000ms/120004 "2018-02-16T14:12:36Z")
Hi There, i am using Kibana with Elasticsearch, Filebeat and Logstash. Currently i am running verison 5.x and i want to upgrade to version 6.x Unfortunately, after installing xpack plugin in kibana and elasticsearch i… --- ## [Vehicle tracking through coordinate map](https://discuss.elastic.co/t/vehicle-tracking-through-coordinate-map/120055)
**Author:** [@Rodolfo\_Albuquerque](https://discuss.elastic.co/u/Rodolfo_Albuquerque)\ **Replies:** 5\ **Last updated:** [February 16, 2018, 1:31pm UTC](https://discuss.elastic.co/t/vehicle-tracking-through-coordinate-map/120055 "2018-02-16T13:31:35Z")
Hey guys, So my gratuation project is to monitor a vehicle through IoT technology. I got all the sensors working sending data to logstash and ultimately visualizing it through graphs in Kibana. Now my goal is to track … --- ## [Background color](https://discuss.elastic.co/t/background-color/120076)
**Author:** [@Pororo](https://discuss.elastic.co/u/Pororo)\ **Replies:** 3\ **Last updated:** [February 16, 2018, 1:11pm UTC](https://discuss.elastic.co/t/background-color/120076 "2018-02-16T13:11:07Z")
Is there any way to change the color of the background for each visualization? Cuz the default one is just plain white and data information covered on it. --- ## [Kibana cluster\_block\_exception after upgrade](https://discuss.elastic.co/t/kibana-cluster-block-exception-after-upgrade/120138)
**Author:** [@ocebeci](https://discuss.elastic.co/u/ocebeci)\ **Replies:** 1\ **Last updated:** [February 16, 2018, 10:26am UTC](https://discuss.elastic.co/t/kibana-cluster-block-exception-after-upgrade/120138 "2018-02-16T10:26:35Z")
Hi there, I've upgraded my elastic stack from version 5.4 to 5.6 on windows server. Now I have the problem that I'll get an error everytime i select a field value in the dropdown. But when I'm typing the value manually … --- ## [How to retrieve the documents(records) of a saved search in elastic search](https://discuss.elastic.co/t/how-to-retrieve-the-documents-records-of-a-saved-search-in-elastic-search/119812)
**Author:** [@Sachidananda\_VS](https://discuss.elastic.co/u/Sachidananda_VS)\ **Replies:** 1\ **Last updated:** [February 16, 2018, 9:43am UTC](https://discuss.elastic.co/t/how-to-retrieve-the-documents-records-of-a-saved-search-in-elastic-search/119812 "2018-02-16T09:43:25Z")
Hi All, I started exploring the ELK stack and was very happy to learn and implement the ELK features for my requirements. Currently I need a help in retrieving the documents (records) of a saved search. I am pushing my… --- ## [Timelion Interval on dashboard](https://discuss.elastic.co/t/timelion-interval-on-dashboard/119932)
**Author:** [@Robert\_Naccache](https://discuss.elastic.co/u/Robert_Naccache)\ **Replies:** 2\ **Last updated:** [February 16, 2018, 7:11am UTC](https://discuss.elastic.co/t/timelion-interval-on-dashboard/119932 "2018-02-16T07:11:22Z")
Hello, I've been having an issue regarding kibana (both 5.6.4 and 6.1.3) I noticed that when you add Timelion visualizations with different intervals and add them to the dashboard, the interval assigned in the timelion… --- ## [Host/Beats Agent Table](https://discuss.elastic.co/t/host-beats-agent-table/119894)
**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\ **Replies:** 2\ **Last updated:** [February 15, 2018, 7:09pm UTC](https://discuss.elastic.co/t/host-beats-agent-table/119894 "2018-02-15T19:09:16Z")
Is it possible to configure a table that reports either # of events received or just the presence of the agent on the host? Host AuditBeat FileBeat MetricBeat PacketBeat WinLogbeat Host 1 Host 2 Host 3 --- ## [Kibana throws error “unable to get issuer certificate” while connecting to ElasticSearch](https://discuss.elastic.co/t/kibana-throws-error-unable-to-get-issuer-certificate-while-connecting-to-elasticsearch/119924)
**Author:** [@jfreeman](https://discuss.elastic.co/u/jfreeman)\ **Replies:** 7\ **Last updated:** [February 15, 2018, 6:54pm UTC](https://discuss.elastic.co/t/kibana-throws-error-unable-to-get-issuer-certificate-while-connecting-to-elasticsearch/119924 "2018-02-15T18:54:37Z")
ES is running in Linux on port 9200 and using firewall rules all incoming request to port 443 are redirected to port 9200 using below commands (It’s because only 443 connections are allowed to this server) firewall-cmd … --- ## [Hello](https://discuss.elastic.co/t/hello/120041)
**Author:** [@SHAIKH\_TABISH](https://discuss.elastic.co/u/SHAIKH_TABISH)\ **Replies:** 3\ **Last updated:** [February 15, 2018, 5:42pm UTC](https://discuss.elastic.co/t/hello/120041 "2018-02-15T17:42:03Z")
Hii i am Tabish Shaikh .I have experience in development using react js and react native .I have also worked with nodejs .Please can somone tell me how can i proceed further .I am interested in the kibana project .I thin… --- ## [Visualize percentage go green energies](https://discuss.elastic.co/t/visualize-percentage-go-green-energies/120020)
**Author:** [@tomak](https://discuss.elastic.co/u/tomak)\ **Replies:** 1\ **Last updated:** [February 15, 2018, 4:56pm UTC](https://discuss.elastic.co/t/visualize-percentage-go-green-energies/120020 "2018-02-15T16:56:46Z")
I have a database with different electricity offers made at different times and each one has a percentage of green energy associated to it. I would like to draw a line chart which gives the number of 100% green offers m… --- ## [Percentage axis instead number](https://discuss.elastic.co/t/percentage-axis-instead-number/119960)
**Author:** [@phia](https://discuss.elastic.co/u/phia)\ **Replies:** 1\ **Last updated:** [February 15, 2018, 1:04pm UTC](https://discuss.elastic.co/t/percentage-axis-instead-number/119960 "2018-02-15T13:04:09Z")
Hello guys, I want to make a chart with two different y-axis. On the left axis I want to plot percentage formatted values and at the right side number formatted values. But if I create that chart the right axis has als… --- ## [Setting up alerts on KIbana](https://discuss.elastic.co/t/setting-up-alerts-on-kibana/119968)
**Author:** [@liammcc](https://discuss.elastic.co/u/liammcc)\ **Replies:** 1\ **Last updated:** [February 15, 2018, 1:02pm UTC](https://discuss.elastic.co/t/setting-up-alerts-on-kibana/119968 "2018-02-15T13:02:23Z")
So we wanted a way to centralise our logs. We have used elastic search and kibana on aws cloudwatch to do this. We have then created metrics related to queries for example errors in a particular service. So we have a das… --- ## [Extending filter bar functionality](https://discuss.elastic.co/t/extending-filter-bar-functionality/119676)
**Author:** [@alepuccetti](https://discuss.elastic.co/u/alepuccetti)\ **Replies:** 3\ **Last updated:** [February 15, 2018, 11:20am UTC](https://discuss.elastic.co/t/extending-filter-bar-functionality/119676 "2018-02-15T11:20:42Z")
It would be useful to improve data analytics functionality having a filter functionality that creates a filter matching all the value of a specific field for the current view. Use case: View all the document produced b… --- ## [Show metric values in kibana visualization](https://discuss.elastic.co/t/show-metric-values-in-kibana-visualization/119700)
**Author:** [@Shailesh\_Vaidya](https://discuss.elastic.co/u/Shailesh_Vaidya)\ **Replies:** 2\ **Last updated:** [February 15, 2018, 10:25am UTC](https://discuss.elastic.co/t/show-metric-values-in-kibana-visualization/119700 "2018-02-15T10:25:21Z")
Hello, Is it possible to show metric values in pie or bar chart visualizations. I can show numbers in heatmap but want to show them in other charts also. Could anyone please guide on this. Regards, Shailesh --- ## [Condition in JSON Input Script/aggs](https://discuss.elastic.co/t/condition-in-json-input-script-aggs/119815)
**Author:** [@phia](https://discuss.elastic.co/u/phia)\ **Replies:** 2\ **Last updated:** [February 15, 2018, 10:13am UTC](https://discuss.elastic.co/t/condition-in-json-input-script-aggs/119815 "2018-02-15T10:13:14Z")
Hey guys, is it possible to make some conditions in the JSON Input/Aggregations. For example: "aggs": { "calculation": { "sum": { "script": if (doc\['Field1'\].value - doc\['F… --- ## [Unable to see the Kibana object I have curlPUT-ed](https://discuss.elastic.co/t/unable-to-see-the-kibana-object-i-have-curlput-ed/118825)
**Author:** [@vincent-fuchs](https://discuss.elastic.co/u/vincent-fuchs)\ **Replies:** 3\ **Last updated:** [February 15, 2018, 9:20am UTC](https://discuss.elastic.co/t/unable-to-see-the-kibana-object-i-have-curlput-ed/118825 "2018-02-15T09:20:36Z")
HI, I am using ES and Kibana 6.0.0. At Kibana startup, I would like to push some objects (search, viz, dashboard) in .kibana index in ES. I am doing a PUT .kibana/doc/my\_warns\_and\_errors with below doc : { "type":… --- ## [Managing kibana for multiple users](https://discuss.elastic.co/t/managing-kibana-for-multiple-users/119160)
**Author:** [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Replies:** 8\ **Last updated:** [February 15, 2018, 9:11am UTC](https://discuss.elastic.co/t/managing-kibana-for-multiple-users/119160 "2018-02-15T09:11:36Z")
Hi , How could i manage kibana when multiple user's are there, like i am the admin user and i should get full access to kibana, like wise there will another user which is Normal user he should have limited access in kib… --- ## [Could not able to create index-pattern in 6.x](https://discuss.elastic.co/t/could-not-able-to-create-index-pattern-in-6-x/119613)
**Author:** [@Rohit\_Raghoji](https://discuss.elastic.co/u/Rohit_Raghoji)\ **Replies:** 2\ **Last updated:** [February 15, 2018, 7:05am UTC](https://discuss.elastic.co/t/could-not-able-to-create-index-pattern-in-6-x/119613 "2018-02-15T07:05:07Z")
Hi i am trying to create index-pattern from query, index-pattern got created but no feilds are there in that and it is giving some errors i used bellow query to create index-pattern in elasticsearch POST /.kibana/doc… --- ## [Data Transfer](https://discuss.elastic.co/t/data-transfer/119907)
**Author:** [@josempolm](https://discuss.elastic.co/u/josempolm)\ **Replies:** 2\ **Last updated:** [February 15, 2018, 5:36am UTC](https://discuss.elastic.co/t/data-transfer/119907 "2018-02-15T05:36:07Z")
Hello there, How can I transfer data from Elasticsearch to MySQL? Best regards. --- ## [Count a specific value of a field as metric](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718)
**Author:** [@Diego\_Nogueira](https://discuss.elastic.co/u/Diego_Nogueira)\ **Replies:** 2\ **Last updated:** [February 14, 2018, 11:00pm UTC](https://discuss.elastic.co/t/count-a-specific-value-of-a-field-as-metric/119718 "2018-02-14T23:00:49Z")
hi everyone, i'm trying count a specific value of a field, as a metric at data table visualization, but i don't known as do it. Could anyone help? Thanks. --- ## [Table showing individual entries in Kibana](https://discuss.elastic.co/t/table-showing-individual-entries-in-kibana/119870)
**Author:** [@geoff\_yalo](https://discuss.elastic.co/u/geoff_yalo)\ **Replies:** 1\ **Last updated:** [February 14, 2018, 9:30pm UTC](https://discuss.elastic.co/t/table-showing-individual-entries-in-kibana/119870 "2018-02-14T21:30:41Z")
Hi, I have an index in Kibana in which each entry contains a field called "feedback" (see below for example). Is it possible to create a table in Kibana that shows the 10, 20, or 50 most recent entries for "feedback" (… --- ## [Kibana Positive/Negative Filter on Metric Vis](https://discuss.elastic.co/t/kibana-positive-negative-filter-on-metric-vis/119795)
**Author:** [@dcam](https://discuss.elastic.co/u/dcam)\ **Replies:** 1\ **Last updated:** [February 14, 2018, 9:11pm UTC](https://discuss.elastic.co/t/kibana-positive-negative-filter-on-metric-vis/119795 "2018-02-14T21:11:46Z")
Why cant we filter/unfilter a field with positive or negative filters in Kibana 6 having a metric dashboard? Kibana 5 allows it but new Kibana does not. On Pie I can filter by term but on metrics not \[image\] --- ## [How to get the state of kibana's side bar in the plugin](https://discuss.elastic.co/t/how-to-get-the-state-of-kibanas-side-bar-in-the-plugin/119746)
**Author:** [@drumn](https://discuss.elastic.co/u/drumn)\ **Replies:** 1\ **Last updated:** [February 14, 2018, 9:05pm UTC](https://discuss.elastic.co/t/how-to-get-the-state-of-kibanas-side-bar-in-the-plugin/119746 "2018-02-14T21:05:04Z")
I am developing a plugin for kibana version 6.2.0. I am looking for ways of writing code to get the state of kibana's side bar expand or collapse. Please tell me if there is any good way! --- ## [Search using complex regex is not working on Kibana 6](https://discuss.elastic.co/t/search-using-complex-regex-is-not-working-on-kibana-6/119636)
**Author:** [@Ayman\_2](https://discuss.elastic.co/u/Ayman_2)\ **Replies:** 3\ **Last updated:** [February 14, 2018, 7:55pm UTC](https://discuss.elastic.co/t/search-using-complex-regex-is-not-working-on-kibana-6/119636 "2018-02-14T19:55:23Z")
Hi, I'm trying to get the count the hits of an url pattern on Kibana, i have regex to catch urls in arabic and english. i tried this request\_url: /(en|ar|fr)/files/(\[\\-\_%A-Z0-9؀-ۿ=a-z\\s\].\*)\[0-9\]+/$/ but it didn't work … --- ## [Default map service error, cant create custom region map either](https://discuss.elastic.co/t/default-map-service-error-cant-create-custom-region-map-either/119571)
**Author:** [@adamali](https://discuss.elastic.co/u/adamali)\ **Replies:** 3\ **Last updated:** [February 14, 2018, 7:48pm UTC](https://discuss.elastic.co/t/default-map-service-error-cant-create-custom-region-map-either/119571 "2018-02-14T19:48:18Z")
Suddenly my kibana throw error in map visualization: Region map: Could not retrieve manifest from the tile service: status -1 old visualization still can display the map but with warning trigger follow up, while creat… --- ## [Saved search in dashboard - CSV downlaod](https://discuss.elastic.co/t/saved-search-in-dashboard-csv-downlaod/119471)
**Author:** [@Raj\_Kumar](https://discuss.elastic.co/u/Raj_Kumar)\ **Replies:** 3\ **Last updated:** [February 14, 2018, 7:45pm UTC](https://discuss.elastic.co/t/saved-search-in-dashboard-csv-downlaod/119471 "2018-02-14T19:45:20Z")
Hi All, I know we could download the saved search as csv file, which is an excellent feature.But I would like to add this saved search in dashboard, and I want to download the csv file instead of pdf format.By default … --- ## [Complex Config Options via Command Line](https://discuss.elastic.co/t/complex-config-options-via-command-line/119306)
**Author:** [@ace1](https://discuss.elastic.co/u/ace1)\ **Replies:** 3\ **Last updated:** [February 14, 2018, 6:13pm UTC](https://discuss.elastic.co/t/complex-config-options-via-command-line/119306 "2018-02-14T18:13:00Z")
Is there any way to pass the more complex config items, such as regionmap, via the command line when starting Kibana? --- ## [Kibana enable cors](https://discuss.elastic.co/t/kibana-enable-cors/118040)
**Author:** [@anton-putau](https://discuss.elastic.co/u/anton-putau)\ **Replies:** 5\ **Last updated:** [February 14, 2018, 5:10pm UTC](https://discuss.elastic.co/t/kibana-enable-cors/118040 "2018-02-14T17:10:18Z")
I have kibana 5.6 and I am unable to enable cors. I've read next thread and found that I needserver.cors : true or server.cors.origin: \['\*'\] setting in kibana .yml config. If I use server.cors : true option, I have res… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=866) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=868)