# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=572 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 573 --- ## [Is there a way to merge columns in discover view to occupy less horizontal space?](https://discuss.elastic.co/t/is-there-a-way-to-merge-columns-in-discover-view-to-occupy-less-horizontal-space/208969)
**Author:** [@nielarshi](https://discuss.elastic.co/u/nielarshi)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 9:52pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-merge-columns-in-discover-view-to-occupy-less-horizontal-space/208969 "2019-11-21T21:52:17Z")
I have a case when a lot of data is spread horizontally and can be just reduced if combined in one column. For ex: Any thoughts on how data could be shown with less white spaces in the discover view? The keywords PAS… --- ## [View surrounding documents is losing the filter](https://discuss.elastic.co/t/view-surrounding-documents-is-losing-the-filter/208976)
**Author:** [@data\_smith](https://discuss.elastic.co/u/data_smith)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 9:21pm UTC](https://discuss.elastic.co/t/view-surrounding-documents-is-losing-the-filter/208976 "2019-11-21T21:21:46Z")
I have a filter in the Discoverer view that is pinned. When I click the 'view surrounding documents' link i'm taking to the context view but the pinned filters are lost. I'm using Kibana 7.4.2. I had a similar issue w… --- ## [Kinana 7.0 - how to create a histogram chart based on latest event in a httpsessionID](https://discuss.elastic.co/t/kinana-7-0-how-to-create-a-histogram-chart-based-on-latest-event-in-a-httpsessionid/208479)
**Author:** [@cheriemilk](https://discuss.elastic.co/u/cheriemilk)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 7:49pm UTC](https://discuss.elastic.co/t/kinana-7-0-how-to-create-a-histogram-chart-based-on-latest-event-in-a-httpsessionid/208479 "2019-11-21T19:49:13Z")
Hi Team, I have an requirement to create histogram chart based on latest events in a httpsessionID. There's multiple events based on a httpsessionID. Sample events like below. "@timestamp",cn,ci,si,ui,module,fa,at,if1… --- ## [How does Search and Indexing latency calculated in Kibana charts?](https://discuss.elastic.co/t/how-does-search-and-indexing-latency-calculated-in-kibana-charts/208555)
**Author:** [@itvivekv](https://discuss.elastic.co/u/itvivekv)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 6:37pm UTC](https://discuss.elastic.co/t/how-does-search-and-indexing-latency-calculated-in-kibana-charts/208555 "2019-11-21T18:37:34Z")
--- ## [How to revive connection?](https://discuss.elastic.co/t/how-to-revive-connection/208931)
**Author:** [@ishv](https://discuss.elastic.co/u/ishv)\ **Replies:** 11\ **Last updated:** [November 21, 2019, 6:00pm UTC](https://discuss.elastic.co/t/how-to-revive-connection/208931 "2019-11-21T18:00:08Z")
I'm trying to set up Kibana and ElasticSearch in the container but continuously receive that error message: Unable to revive connection: http://maperclip-elasticsearch:9200/" This is how my docker-compose.yml looks lik… --- ## [Auto Detect Date/Time](https://discuss.elastic.co/t/auto-detect-date-time/207418)
**Author:** [@Jim\_Thunder](https://discuss.elastic.co/u/Jim_Thunder)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 5:30pm UTC](https://discuss.elastic.co/t/auto-detect-date-time/207418 "2019-11-21T17:30:10Z")
Hello! So I have records coming in CSV format and they are parsed out properly. One issue is that a few of the fields have a time or date in them. That time/date is accurate when I look at the raw data but after the re… --- ## [Kibana scripted field used in interactive control shows no data](https://discuss.elastic.co/t/kibana-scripted-field-used-in-interactive-control-shows-no-data/208934)
**Author:** [@jmcclure](https://discuss.elastic.co/u/jmcclure)\ **Replies:** 4\ **Last updated:** [November 21, 2019, 5:21pm UTC](https://discuss.elastic.co/t/kibana-scripted-field-used-in-interactive-control-shows-no-data/208934 "2019-11-21T17:21:23Z")
Hi, (Elastic stack version 6.7.1 on Centos 7.6 OS) I have a dashboard that utilizes a control visualization, which specifies a field that is defined in Kibana as a scripted field. I have document data going into Elast… --- ## [Reporting Options?](https://discuss.elastic.co/t/reporting-options/208080)
**Author:** [@awataszko](https://discuss.elastic.co/u/awataszko)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 5:13pm UTC](https://discuss.elastic.co/t/reporting-options/208080 "2019-11-21T17:13:58Z")
Has anyone came across any reporting solutions other than what you can do in Kibana, which is basically just a print screen poorly formatted in a PDF or PNG file. My issue is data tables that have scroll bars or more th… --- ## [How can I setup in Watcher to send out an email depend on the Search condition?](https://discuss.elastic.co/t/how-can-i-setup-in-watcher-to-send-out-an-email-depend-on-the-search-condition/208749)
**Author:** [@Shaw](https://discuss.elastic.co/u/Shaw)\ **Replies:** 4\ **Last updated:** [November 21, 2019, 5:15pm UTC](https://discuss.elastic.co/t/how-can-i-setup-in-watcher-to-send-out-an-email-depend-on-the-search-condition/208749 "2019-11-21T17:15:51Z")
Hi, In my Watcher, I setup a template below to send out an email base on the search condition, it works. However, I have different Indices and Tags that I want to put all together in one Watcher. For example, If Inde… --- ## [No cached mapping for this field (Elastic Cloud, APM)](https://discuss.elastic.co/t/no-cached-mapping-for-this-field-elastic-cloud-apm/207116)
**Author:** [@insanity13](https://discuss.elastic.co/u/insanity13)\ **Replies:** 5\ **Last updated:** [November 21, 2019, 5:01pm UTC](https://discuss.elastic.co/t/no-cached-mapping-for-this-field-elastic-cloud-apm/207116 "2019-11-21T17:01:44Z")
I'm using Elastic Cloud v7.4.2 with APM (.NET Framework) and got a lot of warning fields in Kibana. Refresh Index does not helps --- ## [Options list in Controls-Visualization doesn't work properly with scripted field as type static lookup](https://discuss.elastic.co/t/options-list-in-controls-visualization-doesnt-work-properly-with-scripted-field-as-type-static-lookup/208882)
**Author:** [@marlich](https://discuss.elastic.co/u/marlich)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 5:00pm UTC](https://discuss.elastic.co/t/options-list-in-controls-visualization-doesnt-work-properly-with-scripted-field-as-type-static-lookup/208882 "2019-11-21T17:00:17Z")
Hello In my index pattern I have a field "categories.code\_a.keyword" of type string. Content can be values like 400, C01, A47, etc.. It must be possible to filter the codes via the visualization "option list". However,… --- ## [Kibana Vega - How to display multiple results in a date histogram](https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713)
**Author:** [@Amphagory](https://discuss.elastic.co/u/Amphagory)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 4:43pm UTC](https://discuss.elastic.co/t/kibana-vega-how-to-display-multiple-results-in-a-date-histogram/208713 "2019-11-21T16:43:16Z")
I am wonder if it is possible to display more than one aggregated result in a date histogram? My Vega query is { $schema: https://vega.github.io/schema/vega-lite/v2.json title: Daily Count data: { url: { … --- ## [Is there a way to remove on-hover filter controls from saved discover search when added in dashboard](https://discuss.elastic.co/t/is-there-a-way-to-remove-on-hover-filter-controls-from-saved-discover-search-when-added-in-dashboard/208918)
**Author:** [@nielarshi](https://discuss.elastic.co/u/nielarshi)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 4:40pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-remove-on-hover-filter-controls-from-saved-discover-search-when-added-in-dashboard/208918 "2019-11-21T16:40:22Z")
When in dashboard, is there a way to hide/remove the controls which appear on mouse hover over table headers and cells? --- ## [Kibana Line Chart - Average - Limit input to range or min/max](https://discuss.elastic.co/t/kibana-line-chart-average-limit-input-to-range-or-min-max/208667)
**Author:** [@Bastian\_Jager](https://discuss.elastic.co/u/Bastian_Jager)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 4:27pm UTC](https://discuss.elastic.co/t/kibana-line-chart-average-limit-input-to-range-or-min-max/208667 "2019-11-21T16:27:18Z")
Hi, looked now quiet a while though the forum, but without success. Only thing close was https://discuss.elastic.co/t/average-aggregation/67826 I am looking for a way to exclude values from averaging. Lets say we have… --- ## [What is the correct approach to export xx mil of records from elastic using kibana](https://discuss.elastic.co/t/what-is-the-correct-approach-to-export-xx-mil-of-records-from-elastic-using-kibana/208608)
**Author:** [@Petr.Simik](https://discuss.elastic.co/u/Petr.Simik)\ **Replies:** 4\ **Last updated:** [November 21, 2019, 4:26pm UTC](https://discuss.elastic.co/t/what-is-the-correct-approach-to-export-xx-mil-of-records-from-elastic-using-kibana/208608 "2019-11-21T16:26:29Z")
For exporting huge amount of data it is recommended to use scroll api , but users of Kibana wants to export milions of record using without this coding. Shall I increase the limits or is there a better approach. Desired … --- ## [Can we make column values as column names](https://discuss.elastic.co/t/can-we-make-column-values-as-column-names/208631)
**Author:** [@SheetalRIL](https://discuss.elastic.co/u/SheetalRIL)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 4:18pm UTC](https://discuss.elastic.co/t/can-we-make-column-values-as-column-names/208631 "2019-11-21T16:18:47Z")
I want to make severity's 3 fields i.e. HIGH, MEDIUM, LOW into column names with their own counts mentioned below them would that be possible? Thanks in advance --- ## [Display selected drop down value in markdown in Canvas](https://discuss.elastic.co/t/display-selected-drop-down-value-in-markdown-in-canvas/208851)
**Author:** [@atamarnath](https://discuss.elastic.co/u/atamarnath)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 4:07pm UTC](https://discuss.elastic.co/t/display-selected-drop-down-value-in-markdown-in-canvas/208851 "2019-11-21T16:07:29Z")
In a canvas, we have a drop down filter and a Markdown. How do I display the selected value from drop down control in Markdown? Basically I have some text in the markdown and want to include the selected value from the d… --- ## [Is it possible to download searched doc to a CSV using open source version?](https://discuss.elastic.co/t/is-it-possible-to-download-searched-doc-to-a-csv-using-open-source-version/208905)
**Author:** [@yuecong](https://discuss.elastic.co/u/yuecong)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 3:24pm UTC](https://discuss.elastic.co/t/is-it-possible-to-download-searched-doc-to-a-csv-using-open-source-version/208905 "2019-11-21T15:24:11Z")
I have logs as message text and several other fields. Is it possible after some search, I can download all these logs to a CSV file? data table can support download. but it only supports aggregation using messageText.key… --- ## [How useful Kibana is for reporting purpose](https://discuss.elastic.co/t/how-useful-kibana-is-for-reporting-purpose/208866)
**Author:** [@ksarkar](https://discuss.elastic.co/u/ksarkar)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 2:49pm UTC](https://discuss.elastic.co/t/how-useful-kibana-is-for-reporting-purpose/208866 "2019-11-21T14:49:18Z")
We understand that Kibana is very much helpful in case of Data Aggregation and analytics specially with strong set of graph tools. My concern is how useful kibana is for reporting purpose, like detail usage, stock report… --- ## [Shorten a panel in dashboard / remove header space](https://discuss.elastic.co/t/shorten-a-panel-in-dashboard-remove-header-space/208633)
**Author:** [@SheetalRIL](https://discuss.elastic.co/u/SheetalRIL)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 2:39pm UTC](https://discuss.elastic.co/t/shorten-a-panel-in-dashboard-remove-header-space/208633 "2019-11-21T14:39:56Z")
Is there a way to further shorten the "Product Owner Dashboard" line? --- ## [Blank maps and "Unable to initialize maps" error!](https://discuss.elastic.co/t/blank-maps-and-unable-to-initialize-maps-error/208607)
**Author:** [@Ramya\_Tanikanti](https://discuss.elastic.co/u/Ramya_Tanikanti)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 2:39pm UTC](https://discuss.elastic.co/t/blank-maps-and-unable-to-initialize-maps-error/208607 "2019-11-21T14:39:27Z")
When I open Kibana Maps, I am getting the below error. Other maps like Coordinate Map and Region Maps are blank when opened. Couldn't find the reason behind this. How can I solve this? Kindly help. --- ## [Table (count data and divide through days of current month)](https://discuss.elastic.co/t/table-count-data-and-divide-through-days-of-current-month/208847)
**Author:** [@Yevhen\_Baidiuk](https://discuss.elastic.co/u/Yevhen_Baidiuk)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 2:37pm UTC](https://discuss.elastic.co/t/table-count-data-and-divide-through-days-of-current-month/208847 "2019-11-21T14:37:57Z")
I have data like data value 01.08.2019 - 33 02.08.2019 - 25 03.08.2019 - 26 (empty) 31.08.2019 - 26 How I can count this data per month and divide per count of current Month days? 4/31 = 0.1290 --- ## [Is it possible to block some colors from being used automatically?](https://discuss.elastic.co/t/is-it-possible-to-block-some-colors-from-being-used-automatically/208643)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 2:30pm UTC](https://discuss.elastic.co/t/is-it-possible-to-block-some-colors-from-being-used-automatically/208643 "2019-11-21T14:30:40Z")
Hi, I am creating a 2 dimensional pie chart: inner value: status with explicit color mapping (ok=green, error=red) outer value: application which applies to the status (term aggregation, automatic colors) it is possi… --- ## [Execute PowerShell scripts from Watcher action?](https://discuss.elastic.co/t/execute-powershell-scripts-from-watcher-action/208902)
**Author:** [@digitalohm](https://discuss.elastic.co/u/digitalohm)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 2:21pm UTC](https://discuss.elastic.co/t/execute-powershell-scripts-from-watcher-action/208902 "2019-11-21T14:21:53Z")
I’m investigating ways to automate IT operations and we already use powershell heavily. Is there a way we can create alerts that fire off actions that would execute powershell scripts or commands (ideally commands the s… --- ## [Reporting encryptionKey vs multiple instances](https://discuss.elastic.co/t/reporting-encryptionkey-vs-multiple-instances/208843)
**Author:** [@stefws](https://discuss.elastic.co/u/stefws)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 1:52pm UTC](https://discuss.elastic.co/t/reporting-encryptionkey-vs-multiple-instances/208843 "2019-11-21T13:52:52Z")
Trying to get reporting working here. Currently got multiple kibana instances using the same .kibana and .reporting index in the same elastic cluster, initially they used a random generated encryptionKey but now I've co… --- ## [Kibana 7.4.2 Discover does not provide the correct score for results](https://discuss.elastic.co/t/kibana-7-4-2-discover-does-not-provide-the-correct-score-for-results/208786)
**Author:** [@Sophia\_Cheng](https://discuss.elastic.co/u/Sophia_Cheng)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 1:46pm UTC](https://discuss.elastic.co/t/kibana-7-4-2-discover-does-not-provide-the-correct-score-for-results/208786 "2019-11-21T13:46:27Z")
When doing searches in the Discover application, the result scores always show a 0 or 1. To reproduce: Do a search in the Discover application Expand one of the hits EXPECTED\>\> \_score to be how that hit scored amongst … --- ## [Error in vega-lite debug](https://discuss.elastic.co/t/error-in-vega-lite-debug/208822)
**Author:** [@msk\_76](https://discuss.elastic.co/u/msk_76)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 1:24pm UTC](https://discuss.elastic.co/t/error-in-vega-lite-debug/208822 "2019-11-21T13:24:52Z")
I am trying to use vega-lite with kibana but on the time\_stamp field of my index, I am getting following error in VEGA\_DEBUG \[Violation\] 'setInterval' handler took 107ms it keep on repeating. \*\*The data doesn't show u… --- ## [Latest known value of a metric](https://discuss.elastic.co/t/latest-known-value-of-a-metric/208772)
**Author:** [@mtudisco](https://discuss.elastic.co/u/mtudisco)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 12:23pm UTC](https://discuss.elastic.co/t/latest-known-value-of-a-metric/208772 "2019-11-21T12:23:30Z")
Hi, i have a dashboard where i want to show a metric, that metric is collected every hour, the configuration is: Metric Aggregation: Top Hit Field: your\_field Aggregate with: concatenate Size: 1 Sort on: @timestamp … --- ## [Showing values in labels or legend without needing user interaction](https://discuss.elastic.co/t/showing-values-in-labels-or-legend-without-needing-user-interaction/208378)
**Author:** [@loldebyte](https://discuss.elastic.co/u/loldebyte)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 11:27am UTC](https://discuss.elastic.co/t/showing-values-in-labels-or-legend-without-needing-user-interaction/208378 "2019-11-21T11:27:33Z")
Hello and thanks for reading. As title suggest, i need a way of showing values for visualisations (mainly pie & bars charts), without mouse hovering to show the tooltip. My issue is very similar to this topic, as i, to… --- ## [Loosing Visualizations after refreshing kibana Index Pattern to add new fields!](https://discuss.elastic.co/t/loosing-visualizations-after-refreshing-kibana-index-pattern-to-add-new-fields/208243)
**Author:** [@Ramya\_Tanikanti](https://discuss.elastic.co/u/Ramya_Tanikanti)\ **Replies:** 6\ **Last updated:** [November 21, 2019, 10:09am UTC](https://discuss.elastic.co/t/loosing-visualizations-after-refreshing-kibana-index-pattern-to-add-new-fields/208243 "2019-11-21T10:09:39Z")
Hi, this seems to be a huge problem for me. I made some visualizations and dashboards using an index pattern. I refreshed the same index pattern because I created a new geo-point data type field. Hence had to refresh to … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=571) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=573)