# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=780 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 781 --- ## [Calculate Percentage in Kibana](https://discuss.elastic.co/t/calculate-percentage-in-kibana/147518)
**Author:** [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)\ **Replies:** 4\ **Last updated:** [September 6, 2018, 6:07pm UTC](https://discuss.elastic.co/t/calculate-percentage-in-kibana/147518 "2018-09-06T18:07:27Z")
Can we calculate percentage in kibana. I have two fields. Count and count difference. I want to aggregate based on dept and calculate (count difference/count) \* 100 for the various dept buckets Please help me --- ## [Strange visualisation behaviour with floating point numbers](https://discuss.elastic.co/t/strange-visualisation-behaviour-with-floating-point-numbers/147449)
**Author:** [@smilin\_stan](https://discuss.elastic.co/u/smilin_stan)\ **Replies:** 8\ **Last updated:** [September 6, 2018, 4:58pm UTC](https://discuss.elastic.co/t/strange-visualisation-behaviour-with-floating-point-numbers/147449 "2018-09-06T16:58:35Z")
I am using the jolokia module in metricbeats which is capturing (amongst other things) the following system stats: I am trying to graph the maximum CPU idle percentage (the system.cpu.idle.pct field), which is a float… --- ## [TSVB Top hit does not show latest metric, inconsistent behaviour](https://discuss.elastic.co/t/tsvb-top-hit-does-not-show-latest-metric-inconsistent-behaviour/147567)
**Author:** [@dsads8a98d](https://discuss.elastic.co/u/dsads8a98d)\ **Replies:** 6\ **Last updated:** [September 6, 2018, 3:57pm UTC](https://discuss.elastic.co/t/tsvb-top-hit-does-not-show-latest-metric-inconsistent-behaviour/147567 "2018-09-06T15:57:06Z")
We have a TSVB metric using the top hit aggregation. The issue we are seeing is that the top hit is not always shown by the visualisation. If a new document that would match as a top hit enters Elasticsearch and we refre… --- ## [Kibana unable to show auth log](https://discuss.elastic.co/t/kibana-unable-to-show-auth-log/147581)
**Author:** [@pradip.d](https://discuss.elastic.co/u/pradip.d)\ **Replies:** 1\ **Last updated:** [September 6, 2018, 2:23pm UTC](https://discuss.elastic.co/t/kibana-unable-to-show-auth-log/147581 "2018-09-06T14:23:01Z")
I am using ES and Kibana 6.4.0 with Beats. My filebeat able to send logs directly to ES. Also when i am doing manual query on ES or Kibana Console i am able to see the log, but in kibana dashboard its not showing, even i… --- ## [V6.3 - cannot set default index & constant 400 errors](https://discuss.elastic.co/t/v6-3-cannot-set-default-index-constant-400-errors/147582)
**Author:** [@violetaria](https://discuss.elastic.co/u/violetaria)\ **Replies:** 2\ **Last updated:** [September 6, 2018, 1:36pm UTC](https://discuss.elastic.co/t/v6-3-cannot-set-default-index-constant-400-errors/147582 "2018-09-06T13:36:19Z")
I'm using Kibana 6.3 running in Kubernetes and I keep getting errors about the defaultIndex If I add more than 1 index, the whole UI stops functioning and complains about having a default index set. Every page load thr… --- ## [Graphics are not displayed in kibana](https://discuss.elastic.co/t/graphics-are-not-displayed-in-kibana/147574)
**Author:** [@Bond94g](https://discuss.elastic.co/u/Bond94g)\ **Replies:** 1\ **Last updated:** [September 6, 2018, 1:24pm UTC](https://discuss.elastic.co/t/graphics-are-not-displayed-in-kibana/147574 "2018-09-06T13:24:37Z")
Tell me, please, why are not the graphics displayed on the Kibana? The pattern index is configured, the requests are successfully sent via jmeter --- ## [Dropdown menus term filters](https://discuss.elastic.co/t/dropdown-menus-term-filters/147566)
**Author:** [@kris99](https://discuss.elastic.co/u/kris99)\ **Replies:** 3\ **Last updated:** [September 6, 2018, 12:43pm UTC](https://discuss.elastic.co/t/dropdown-menus-term-filters/147566 "2018-09-06T12:43:48Z")
Hi, I have Controls visualisation with 5 dropdown menu. I want to achieve if I select a term in the first menu it will filters terms in second...fifth menu, then I select a term in second menu and it will filters terms … --- ## [Filtering bucket](https://discuss.elastic.co/t/filtering-bucket/147543)
**Author:** [@Thomas\_Boucard](https://discuss.elastic.co/u/Thomas_Boucard)\ **Replies:** 4\ **Last updated:** [September 6, 2018, 11:40am UTC](https://discuss.elastic.co/t/filtering-bucket/147543 "2018-09-06T11:40:27Z")
Hi, I'm trying to do a pie chart using some filter. Basically I want a percentage of OK / KO depending on a particular value. I have a first filter for the KO part: errorOwner.keyword is "SERVICE X" This one works gr… --- ## [Kuery search](https://discuss.elastic.co/t/kuery-search/147542)
**Author:** [@vara0855](https://discuss.elastic.co/u/vara0855)\ **Replies:** 6\ **Last updated:** [September 6, 2018, 11:02am UTC](https://discuss.elastic.co/t/kuery-search/147542 "2018-09-06T11:02:20Z")
Kibana 6.3.2 OSS Elasticsearch 6.3.2 OSS Hello. Can someone tell me if I can use in the OSS version of kibana "Kuery" to search on discover, visualization and other? Or only on X-pack? https://www.elastic.co/guide/en/… --- ## [How to change number of rows in dataTable in Discover? Kibana](https://discuss.elastic.co/t/how-to-change-number-of-rows-in-datatable-in-discover-kibana/147547)
**Author:** [@NikolaenkoDmitriy](https://discuss.elastic.co/u/NikolaenkoDmitriy)\ **Replies:** 3\ **Last updated:** [September 6, 2018, 11:01am UTC](https://discuss.elastic.co/t/how-to-change-number-of-rows-in-datatable-in-discover-kibana/147547 "2018-09-06T11:01:36Z")
Hi, Can I somehow reduce or increase the number of lines here?: By default, no more than seven rows are displayed for each message. Did not find the settings by which I could change this number=( --- ## [Any replacement of Kibana Iframe](https://discuss.elastic.co/t/any-replacement-of-kibana-iframe/147522)
**Author:** [@nandan\_bigdata](https://discuss.elastic.co/u/nandan_bigdata)\ **Replies:** 6\ **Last updated:** [September 6, 2018, 9:07am UTC](https://discuss.elastic.co/t/any-replacement-of-kibana-iframe/147522 "2018-09-06T09:07:21Z")
Hi all, I am using Kibana 6.3.1 version. Right now sharing Kibana Visualization with my personal website using Iframe method. But Iframe is kind of time consuming. It is taking around 10-15 seconds to load all visuali… --- ## [Give option to download visualization data in csv when embedding a kibana dashboard](https://discuss.elastic.co/t/give-option-to-download-visualization-data-in-csv-when-embedding-a-kibana-dashboard/147499)
**Author:** [@ritwikkaul](https://discuss.elastic.co/u/ritwikkaul)\ **Replies:** 1\ **Last updated:** [September 6, 2018, 7:46am UTC](https://discuss.elastic.co/t/give-option-to-download-visualization-data-in-csv-when-embedding-a-kibana-dashboard/147499 "2018-09-06T07:46:05Z")
Hi all We can download any visualization data as a csv, but when embedding a dashboard using iframe, I want to provide the same functionality. Is there any way to do this ? Thanks --- ## [Filter inside DropDown visualization](https://discuss.elastic.co/t/filter-inside-dropdown-visualization/147432)
**Author:** [@saisimo02](https://discuss.elastic.co/u/saisimo02)\ **Replies:** 2\ **Last updated:** [September 6, 2018, 7:43am UTC](https://discuss.elastic.co/t/filter-inside-dropdown-visualization/147432 "2018-09-06T07:43:55Z")
Hello, I have a question about filters inside the controls visualization (option list or DropDown) when I choose my field I have for example 100 elements in this list but when I add a filter like in this picture the d… --- ## [Automating visualization entries in .kibana index](https://discuss.elastic.co/t/automating-visualization-entries-in-kibana-index/147292)
**Author:** [@ronchav](https://discuss.elastic.co/u/ronchav)\ **Replies:** 2\ **Last updated:** [September 6, 2018, 4:11am UTC](https://discuss.elastic.co/t/automating-visualization-entries-in-kibana-index/147292 "2018-09-06T04:11:38Z")
We have common log types across different application and I want to automate the creation of visualization entry in .kibana index from the template (exported json from kibana) I created. I am following the post below bu… --- ## [How to Validate this property system.socket.direction from system?](https://discuss.elastic.co/t/how-to-validate-this-property-system-socket-direction-from-system/147344)
**Author:** [@mmahaja](https://discuss.elastic.co/u/mmahaja)\ **Replies:** 2\ **Last updated:** [September 5, 2018, 5:04pm UTC](https://discuss.elastic.co/t/how-to-validate-this-property-system-socket-direction-from-system/147344 "2018-09-05T17:04:52Z")
netstat info netstat | wc -l 502 and Kibana UI attached. Please help me understand, How Can I validate the information shown by Kibana from System OS: CentOS 7.x Kibana: 6.4 ES: 6.4 --- ## [Is there any way to use 'nested queries' in Discover or Views?](https://discuss.elastic.co/t/is-there-any-way-to-use-nested-queries-in-discover-or-views/147457)
**Author:** [@Gosforth](https://discuss.elastic.co/u/Gosforth)\ **Replies:** 1\ **Last updated:** [September 5, 2018, 6:54pm UTC](https://discuss.elastic.co/t/is-there-any-way-to-use-nested-queries-in-discover-or-views/147457 "2018-09-05T18:54:31Z")
I'm searching the way how can I use Kibana to show which clients where buying -2 months ago but not -1month ago. Something that would have running two SQL queries: SELECT count(\*) FROM clients WHERE date BETWEEN '2018-… --- ## [Kibana stuck at "Waiting For Elastic"](https://discuss.elastic.co/t/kibana-stuck-at-waiting-for-elastic/147232)
**Author:** [@ktrommeshauser](https://discuss.elastic.co/u/ktrommeshauser)\ **Replies:** 3\ **Last updated:** [September 5, 2018, 6:10pm UTC](https://discuss.elastic.co/t/kibana-stuck-at-waiting-for-elastic/147232 "2018-09-05T18:10:37Z")
I have my Elastic Cluster up and running and can hit the \_cluster/health |status|"green"| |timed\_out|false| |number\_of\_nodes|3| |number\_of\_data\_nodes|3| |active\_primary\_shards|1| |active\_shards|3| |relocating\_sha… --- ## [Kibana dashboard unaccessible](https://discuss.elastic.co/t/kibana-dashboard-unaccessible/147244)
**Author:** [@sandipatmca](https://discuss.elastic.co/u/sandipatmca)\ **Replies:** 2\ **Last updated:** [September 5, 2018, 3:10pm UTC](https://discuss.elastic.co/t/kibana-dashboard-unaccessible/147244 "2018-09-05T15:10:36Z")
Hi, I have xpack installed on ELasticSearch & Kibana .Both the application are up and running (sudo systmectl status kiabana.service & elasticsearch.service) shows active (running). But I am not able to access my Kiban… --- ## [Kibana is not identifying the ElasticSearch index date type](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411)
**Author:** [@Diogo\_Azevedo\_Gouvei](https://discuss.elastic.co/u/Diogo_Azevedo_Gouvei)\ **Replies:** 4\ **Last updated:** [September 5, 2018, 2:58pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411 "2018-09-05T14:58:32Z")
I use Elastic 6.3.2 with Kibana 6.3.2 and am having problems with date type field indexes, since they are not identified as date type fields by Kibana, even though they are indexed as date in Elastic. The date fields ar… --- ## [Status changed from yellow to red - Elasticsearch plugin is red](https://discuss.elastic.co/t/status-changed-from-yellow-to-red-elasticsearch-plugin-is-red/147320)
**Author:** [@maithreyi](https://discuss.elastic.co/u/maithreyi)\ **Replies:** 1\ **Last updated:** [September 5, 2018, 12:49pm UTC](https://discuss.elastic.co/t/status-changed-from-yellow-to-red-elasticsearch-plugin-is-red/147320 "2018-09-05T12:49:21Z")
Hi, I tried to upgrade elasticsearch from 2.2 to 5.6. The indices are showing yellow state. the index .kibana is also showing yellow state. IWhile i was using 2.4 elasticsearch, I was using 4.4 Kibana version. After up… --- ## [Help in 'painless scripted field creation'](https://discuss.elastic.co/t/help-in-painless-scripted-field-creation/147222)
**Author:** [@Roni\_Saha](https://discuss.elastic.co/u/Roni_Saha)\ **Replies:** 2\ **Last updated:** [September 5, 2018, 9:51am UTC](https://discuss.elastic.co/t/help-in-painless-scripted-field-creation/147222 "2018-09-05T09:51:27Z")
Hello anyone, I am facing some issue while create a 'Painless Scripted field' ? Here's the Logs in JSON format - { "\_index": "my-log-test", "\_type": "doc", "\_version": 1, "\_source": { "SubType": "000", "Time": "… --- ## [Could not locate that index-pattern-field (id: iis.access.geoip.location)](https://discuss.elastic.co/t/could-not-locate-that-index-pattern-field-id-iis-access-geoip-location/146494)
**Author:** [@samid737](https://discuss.elastic.co/u/samid737)\ **Replies:** 3\ **Last updated:** [September 5, 2018, 9:04am UTC](https://discuss.elastic.co/t/could-not-locate-that-index-pattern-field-id-iis-access-geoip-location/146494 "2018-09-05T09:04:02Z")
Hi guys, Using Elastic Stack : 6.4.0 I am currently reading in IIS logs and trying to get geoIP filtering to work with Kibana, however I am quite stuck at the moment. When navigating to: The following message is d… --- ## [Kibana\[5.6\] Using API endpoints to save objects](https://discuss.elastic.co/t/kibana-5-6-using-api-endpoints-to-save-objects/147044)
**Author:** [@Vinay\_Kumar](https://discuss.elastic.co/u/Vinay_Kumar)\ **Replies:** 5\ **Last updated:** [September 5, 2018, 8:30am UTC](https://discuss.elastic.co/t/kibana-5-6-using-api-endpoints-to-save-objects/147044 "2018-09-05T08:30:02Z")
Kibana version: 5.6 Hi, My issue is related to the REST API endpoints. Currently, I am able to save my dashboards using the GUI of Kibana in json format in my local drive. I wanted to enquire whether it is possible f… --- ## [I am trying to visualize the data using timeseries visual builder and fails to load the data](https://discuss.elastic.co/t/i-am-trying-to-visualize-the-data-using-timeseries-visual-builder-and-fails-to-load-the-data/147207)
**Author:** [@ndevathi](https://discuss.elastic.co/u/ndevathi)\ **Replies:** 5\ **Last updated:** [September 5, 2018, 7:53am UTC](https://discuss.elastic.co/t/i-am-trying-to-visualize-the-data-using-timeseries-visual-builder-and-fails-to-load-the-data/147207 "2018-09-05T07:53:40Z")
Hi I have a data where date filed is custom(date\_run). When i try to visualize the data, I always see count being zero, though i see some spikes. Below are the pictures Even i see it in the table format also i don't… --- ## [KIbana filter by aggrgation on y axis](https://discuss.elastic.co/t/kibana-filter-by-aggrgation-on-y-axis/147033)
**Author:** [@Ambuj\_Jauhari](https://discuss.elastic.co/u/Ambuj_Jauhari)\ **Replies:** 2\ **Last updated:** [September 5, 2018, 1:48am UTC](https://discuss.elastic.co/t/kibana-filter-by-aggrgation-on-y-axis/147033 "2018-09-05T01:48:43Z")
I have been exploring elastic search and kibana. Simple aggregations are working fine. I am stuck at plotting the below scenario I have a document with 3 fields as below and some sample entries processId , process ver… --- ## [Kibana 6.4 getting Request failed with status code: 403](https://discuss.elastic.co/t/kibana-6-4-getting-request-failed-with-status-code-403/146538)
**Author:** [@amit.patra](https://discuss.elastic.co/u/amit.patra)\ **Replies:** 14\ **Last updated:** [September 4, 2018, 8:11pm UTC](https://discuss.elastic.co/t/kibana-6-4-getting-request-failed-with-status-code-403/146538 "2018-09-04T20:11:25Z")
Hi, I have removed kibana 5.5 from my redhat 6.9 server and installed 6.4. But on every request I got the below error : Config: Request failed with status code: 403 Error: Request failed with status code: 403 $@ht… --- ## [View Surrounding Documents causes failed to parse date field exception](https://discuss.elastic.co/t/view-surrounding-documents-causes-failed-to-parse-date-field-exception/147234)
**Author:** [@w\_batelaan](https://discuss.elastic.co/u/w_batelaan)\ **Replies:** 1\ **Last updated:** [September 4, 2018, 7:38pm UTC](https://discuss.elastic.co/t/view-surrounding-documents-causes-failed-to-parse-date-field-exception/147234 "2018-09-04T19:38:08Z")
Using ES6.4.0; Discover works fine with this index, which has a @timestamp field, which Kibana shows as September 4th 2018, 15:41:08.309 So why would View Surrounding Documents not be able to parse the date? BTW the m… --- ## [Bar(chart) with % of different values in Canvas. How?](https://discuss.elastic.co/t/bar-chart-with-of-different-values-in-canvas-how/146936)
**Author:** [@GGorast](https://discuss.elastic.co/u/GGorast)\ **Replies:** 1\ **Last updated:** [September 4, 2018, 6:11pm UTC](https://discuss.elastic.co/t/bar-chart-with-of-different-values-in-canvas-how/146936 "2018-09-04T18:11:15Z")
I need to make a pie-like bar(chart) that will show different % of 100% of the values that I choose and color it differently. See the image for explanation. Tnx --- ## [Kibana Visualisation Average Monthly Sums Over Years](https://discuss.elastic.co/t/kibana-visualisation-average-monthly-sums-over-years/146935)
**Author:** [@Tanatos\_Daniel](https://discuss.elastic.co/u/Tanatos_Daniel)\ **Replies:** 4\ **Last updated:** [September 4, 2018, 4:09pm UTC](https://discuss.elastic.co/t/kibana-visualisation-average-monthly-sums-over-years/146935 "2018-09-04T16:09:47Z")
I have these daily records.. for a period of 7 years. I managed to calculate the sum for each month and get a chart like this I also managed to plot the sum on each month over the years. So the first point in this se… --- ## [Dropdown arrow below histogram in discover is missing](https://discuss.elastic.co/t/dropdown-arrow-below-histogram-in-discover-is-missing/147160)
**Author:** [@w\_batelaan](https://discuss.elastic.co/u/w_batelaan)\ **Replies:** 1\ **Last updated:** [September 4, 2018, 3:42pm UTC](https://discuss.elastic.co/t/dropdown-arrow-below-histogram-in-discover-is-missing/147160 "2018-09-04T15:42:50Z")
Using Kibana 6.4.0, I'm not seeing the dropdown arrow below the results histogram in the Discover view. Thus I cannot access the query/responce/statistics nor export the data. Any idea why it is not showing? [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=779) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=781)