# Kibana

**URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=389

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 390

---

## [Dashboard - show only last distinct values](https://discuss.elastic.co/t/dashboard-show-only-last-distinct-values/257035)

<div class="topic-metadata">

**Author:** [@Vita\_Rosenberg](https://discuss.elastic.co/u/Vita_Rosenberg)\
**Replies:** 2\
**Last updated:** [December 9, 2020, 1:34pm UTC](https://discuss.elastic.co/t/dashboard-show-only-last-distinct-values/257035 "2020-12-09T13:34:58Z")

</div>

I want to show only the last distinct values. Hence without the records with yellow color. Is it possible?

---

## [Kibana settings API](https://discuss.elastic.co/t/kibana-settings-api/258100)

<div class="topic-metadata">

**Author:** [@6NMgfDwZ3](https://discuss.elastic.co/u/6NMgfDwZ3)\
**Replies:** 2\
**Last updated:** [December 9, 2020, 1:08pm UTC](https://discuss.elastic.co/t/kibana-settings-api/258100 "2020-12-09T13:08:10Z")

</div>

Hello, ELK 7.10.0 / Kibana Is there any way to change Kibana options Stack Managament / Advanced Settings / "dateFormat" + "dateFormat:tz" + etc. through an API? I haven't found any info about that in the documentatio…

---

## [Kibana Discover order by field](https://discuss.elastic.co/t/kibana-discover-order-by-field/258102)

<div class="topic-metadata">

**Author:** [@Kapila](https://discuss.elastic.co/u/Kapila)\
**Replies:** 5\
**Last updated:** [December 9, 2020, 1:03pm UTC](https://discuss.elastic.co/t/kibana-discover-order-by-field/258102 "2020-12-09T13:03:49Z")

</div>

I want to order documents in Discover by a date field using KQL or Lucene. Can you guide me please?

---

## [How to use \<\> these brackets for search in kibana](https://discuss.elastic.co/t/how-to-use-these-brackets-for-search-in-kibana/258075)

<div class="topic-metadata">

**Author:** [@Krishna\_Sai\_Nag\_G](https://discuss.elastic.co/u/Krishna_Sai_Nag_G)\
**Replies:** 1\
**Last updated:** [December 9, 2020, 12:24pm UTC](https://discuss.elastic.co/t/how-to-use-these-brackets-for-search-in-kibana/258075 "2020-12-09T12:24:26Z")

</div>

Enables the \<\> operators. You can use \<\> to match a numeric range. For example: foo\<1-100\> # matches 'foo1', 'foo2' ... 'foo99', 'foo100' foo\<01-100\> # matches 'foo01', 'foo02' ... 'foo99', 'foo100' How to wr…

---

## [Querying in Kibana Discover Timesout](https://discuss.elastic.co/t/querying-in-kibana-discover-timesout/256817)

<div class="topic-metadata">

**Author:** [@Ganesh\_Sharma](https://discuss.elastic.co/u/Ganesh_Sharma)\
**Replies:** 14\
**Last updated:** [December 9, 2020, 11:07am UTC](https://discuss.elastic.co/t/querying-in-kibana-discover-timesout/256817 "2020-12-09T11:07:48Z")

</div>

Guys I have been trying to deploy ELK cluster using ELK Operator method for Azure AKS from here. However after I deploy ELK and access Kibana and add Filebeat index creation I am unable to query anything in the Discover…

---

## [Pick latest data](https://discuss.elastic.co/t/pick-latest-data/256361)

<div class="topic-metadata">

**Author:** [@vikram\_singh](https://discuss.elastic.co/u/vikram_singh)\
**Replies:** 7\
**Last updated:** [December 9, 2020, 11:06am UTC](https://discuss.elastic.co/t/pick-latest-data/256361 "2020-12-09T11:06:09Z")

</div>

Hi, I am bulk inserting my data into an index multiple times in a day. I want to get all data with last timestamp(with last timestamp I inserted.).

---

## [Timefilter in Canvas does not visually refresh with the newly searched criteria](https://discuss.elastic.co/t/timefilter-in-canvas-does-not-visually-refresh-with-the-newly-searched-criteria/258091)

<div class="topic-metadata">

**Author:** [@faisal.parwani](https://discuss.elastic.co/u/faisal.parwani)\
**Replies:** 0\
**Last updated:** [December 9, 2020, 8:24am UTC](https://discuss.elastic.co/t/timefilter-in-canvas-does-not-visually-refresh-with-the-newly-searched-criteria/258091 "2020-12-09T08:24:09Z")

</div>

Hi i have a Canvas with Markdowns, for each markdown have certain query which is used to fetch and show the result (some number) as the content in the markdown. i added a timeFilter with default to 'Last 24 Hours' a…

---

## [Pin filter in a specific dashboard](https://discuss.elastic.co/t/pin-filter-in-a-specific-dashboard/257199)

<div class="topic-metadata">

**Author:** [@yaelg](https://discuss.elastic.co/u/yaelg)\
**Replies:** 2\
**Last updated:** [December 9, 2020, 8:29am UTC](https://discuss.elastic.co/t/pin-filter-in-a-specific-dashboard/257199 "2020-12-09T08:29:55Z")

</div>

Hey everyone, I'm quite new to ELK so my question might be trivial. I am working with multiple dashboards. Is there a way to pin a filter only in one dashboards? whenever I pin a filter, it applies it to all dashboards…

---

## [Logs of elastic stack components should go to their respective log file](https://discuss.elastic.co/t/logs-of-elastic-stack-components-should-go-to-their-respective-log-file/257732)

<div class="topic-metadata">

**Author:** [@prat](https://discuss.elastic.co/u/prat)\
**Replies:** 4\
**Last updated:** [December 9, 2020, 7:48am UTC](https://discuss.elastic.co/t/logs-of-elastic-stack-components-should-go-to-their-respective-log-file/257732 "2020-12-09T07:48:19Z")

</div>

Hi Team, I am seeing logs of elastic stack components such as Kibana, Logstash, filebeat are going everywhere like in /var/log/message , /var/log/daemon, journal.log and flooding filesystem. how to make sure logs of el…

---

## [Kibana server not starting up](https://discuss.elastic.co/t/kibana-server-not-starting-up/257944)

<div class="topic-metadata">

**Author:** [@sudhakar\_u](https://discuss.elastic.co/u/sudhakar_u)\
**Replies:** 16\
**Last updated:** [December 9, 2020, 4:42am UTC](https://discuss.elastic.co/t/kibana-server-not-starting-up/257944 "2020-12-09T04:42:37Z")

</div>

iam seeing this error in the logs.It was working fine till 1 day back.Whta could be the issue here. i restarted the kibana.Still the same issue.ECerything was properly setup. {"type":"log","@timestamp":"2020-12-08T06:5…

---

## [Kibana interacting with Elasticsearch](https://discuss.elastic.co/t/kibana-interacting-with-elasticsearch/257940)

<div class="topic-metadata">

**Author:** [@anarnold](https://discuss.elastic.co/u/anarnold)\
**Replies:** 5\
**Last updated:** [December 9, 2020, 3:39am UTC](https://discuss.elastic.co/t/kibana-interacting-with-elasticsearch/257940 "2020-12-09T03:39:04Z")

</div>

Hi All, I was exploring the Kibana as one of our solutions for Observability. Had 2 queries: Q: How does Kibana interact with the elasticsearch? Does it internally call the same elasticsearch APIs that are already expo…

---

## [Create an Alert for top 10 exceptions in my Log](https://discuss.elastic.co/t/create-an-alert-for-top-10-exceptions-in-my-log/257966)

<div class="topic-metadata">

**Author:** [@sukanto](https://discuss.elastic.co/u/sukanto)\
**Replies:** 1\
**Last updated:** [December 8, 2020, 9:50pm UTC](https://discuss.elastic.co/t/create-an-alert-for-top-10-exceptions-in-my-log/257966 "2020-12-08T21:50:08Z")

</div>

I am looking to create an Alert for Top 10 Exceptions in my log during last 12 hours. The alert should trigger every 12 hours and email to a group of people the count of each of the top 10 Exceptions during last 12 hours…

---

## [Kibana Clustering](https://discuss.elastic.co/t/kibana-clustering/257961)

<div class="topic-metadata">

**Author:** [@Farid\_N](https://discuss.elastic.co/u/Farid_N)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 9:48pm UTC](https://discuss.elastic.co/t/kibana-clustering/257961 "2020-12-08T21:48:45Z")

</div>

Hi guys I\`ve using a cluster with 5 nodes (Elasticsearch) The question is, in "Stack Monitoring" I see GREEN health and OK nodes(one of them is master) but my Kibana is like this: How can I have multi-instance of Ki…

---

## [Find hosts that do not have any documents matching a query](https://discuss.elastic.co/t/find-hosts-that-do-not-have-any-documents-matching-a-query/257871)

<div class="topic-metadata">

**Author:** [@jmcclelland](https://discuss.elastic.co/u/jmcclelland)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 9:42pm UTC](https://discuss.elastic.co/t/find-hosts-that-do-not-have-any-documents-matching-a-query/257871 "2020-12-08T21:42:58Z")

</div>

Is it possible to create a dashboard that lists all unique hosts that do not have any documents matching a particular query? Thanks for any tips you might have!

---

## [If you save dashboard as json, does it save visualization as well?](https://discuss.elastic.co/t/if-you-save-dashboard-as-json-does-it-save-visualization-as-well/258052)

<div class="topic-metadata">

**Author:** [@jhagen92](https://discuss.elastic.co/u/jhagen92)\
**Replies:** 3\
**Last updated:** [December 8, 2020, 9:34pm UTC](https://discuss.elastic.co/t/if-you-save-dashboard-as-json-does-it-save-visualization-as-well/258052 "2020-12-08T21:34:07Z")

</div>

Hi. I am trying to create development environment and production environment for Kibana dashboard (two separate VMs). Idea is to work on dev environment, export json -\> import json in production environment. If I work …

---

## [Dashboard filter does not include fields from the index used in Vega visualization](https://discuss.elastic.co/t/dashboard-filter-does-not-include-fields-from-the-index-used-in-vega-visualization/258033)

<div class="topic-metadata">

**Author:** [@ege](https://discuss.elastic.co/u/ege)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 6:34pm UTC](https://discuss.elastic.co/t/dashboard-filter-does-not-include-fields-from-the-index-used-in-vega-visualization/258033 "2020-12-08T18:34:12Z")

</div>

Hi, I am trying to add an on-click signal to add a filter when clicked on each sector of a pie-chart using Vega. Even though the filter is added, it is not affected on the chart and shows an error within the filter. T…

---

## [Kibana 7.10 Pagination + Rows per page not working](https://discuss.elastic.co/t/kibana-7-10-pagination-rows-per-page-not-working/258013)

<div class="topic-metadata">

**Author:** [@jcotter91](https://discuss.elastic.co/u/jcotter91)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 6:21pm UTC](https://discuss.elastic.co/t/kibana-7-10-pagination-rows-per-page-not-working/258013 "2020-12-08T18:21:34Z")

</div>

Kibana version : 7.10 Elasticsearch version : 7.10 Metricbeat version: 7.10 Browser: Google Chrome 87.0.4280.66 (Official Build) (64-bit) Revision fd98a29dd59b36f71e4741332c9ad5bda42094bf-refs/branch-heads/42…

---

## [Currency Format](https://discuss.elastic.co/t/currency-format/257999)

<div class="topic-metadata">

**Author:** [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\
**Replies:** 9\
**Last updated:** [December 8, 2020, 4:23pm UTC](https://discuss.elastic.co/t/currency-format/257999 "2020-12-08T16:23:48Z")

</div>

Hi all, My data in Elasticsearch index are numbers (integer, long, float) and amounts in euros € currency whitout affecting those are just a number. I would like to display all amounts with euro € signe. Unfortunately…

---

## [Not able to see latest logs in discover in kibana](https://discuss.elastic.co/t/not-able-to-see-latest-logs-in-discover-in-kibana/257688)

<div class="topic-metadata">

**Author:** [@prat](https://discuss.elastic.co/u/prat)\
**Replies:** 10\
**Last updated:** [December 8, 2020, 5:23pm UTC](https://discuss.elastic.co/t/not-able-to-see-latest-logs-in-discover-in-kibana/257688 "2020-12-08T17:23:20Z")

</div>

Hi Team, I am not able to see latest logs in discover tab in kibana. the last logs I can see is of 1 Dec 2020 but not after that. I can see folders getting created till today in /opt/elasticsearch/nodes/0/indices/, the…

---

## [Auto-logout in Elastic managed service Kibana](https://discuss.elastic.co/t/auto-logout-in-elastic-managed-service-kibana/255092)

<div class="topic-metadata">

**Author:** [@Chenlrv](https://discuss.elastic.co/u/Chenlrv)\
**Replies:** 8\
**Last updated:** [December 8, 2020, 5:09pm UTC](https://discuss.elastic.co/t/auto-logout-in-elastic-managed-service-kibana/255092 "2020-12-08T17:09:11Z")

</div>

Hi, I'm presenting a Kibana dashboard on television and after like 6 hours the session automatically logouts and requires to log in again with username and password. I'd like to disable the session from disconnection o…

---

## [Kibana query to remote cluster causes null pointer exception](https://discuss.elastic.co/t/kibana-query-to-remote-cluster-causes-null-pointer-exception/258024)

<div class="topic-metadata">

**Author:** [@bwink](https://discuss.elastic.co/u/bwink)\
**Replies:** 0\
**Last updated:** [December 8, 2020, 4:02pm UTC](https://discuss.elastic.co/t/kibana-query-to-remote-cluster-causes-null-pointer-exception/258024 "2020-12-08T16:02:44Z")

</div>

Cluster#1 7.10.0 Kibana#1 7.10.0 Cluster#2 7.9.2 Kibana#2 7.9.2 Problem#1 I have a local Kibana (kibana#1) to a local cluster (cluster#1) and everything works perfectly on querying an index pattern. I set up a diffe…

---

## [ROW\_NUMBER in ES SQL](https://discuss.elastic.co/t/row-number-in-es-sql/257923)

<div class="topic-metadata">

**Author:** [@Treki](https://discuss.elastic.co/u/Treki)\
**Replies:** 7\
**Last updated:** [December 8, 2020, 2:17pm UTC](https://discuss.elastic.co/t/row-number-in-es-sql/257923 "2020-12-08T14:17:34Z")

</div>

Hello, does the command ROW\_NUMBER() exist for ES SQL? When not, is there something equivalent to it? Can someone do an example, please? With best regards

---

## [Convert DateTime to integer](https://discuss.elastic.co/t/convert-datetime-to-integer/257924)

<div class="topic-metadata">

**Author:** [@Treki](https://discuss.elastic.co/u/Treki)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 2:15pm UTC](https://discuss.elastic.co/t/convert-datetime-to-integer/257924 "2020-12-08T14:15:05Z")

</div>

Hello, we have strings in the format "2020-11-10T12:43:58" saved in Kibana. When using ES SQL, we want to convert these strings into an integer or float so that the integer/float increases as the DateTime increases as …

---

## [How to show last n records in ascending order in kibana dashboard](https://discuss.elastic.co/t/how-to-show-last-n-records-in-ascending-order-in-kibana-dashboard/257323)

<div class="topic-metadata">

**Author:** [@ajain16](https://discuss.elastic.co/u/ajain16)\
**Replies:** 7\
**Last updated:** [December 8, 2020, 10:49am UTC](https://discuss.elastic.co/t/how-to-show-last-n-records-in-ascending-order-in-kibana-dashboard/257323 "2020-12-08T10:49:22Z")

</div>

Hi All, We have data and time field in X axis and we are showing data on X axis from today to today+25 records. e.g 3Dec, 2 Dec, 1 Dec, 30 Nov, 29 Nov etc. We need to show total 25 data count in reverse order. e.g 25 …

---

## [Exisisting field doesn't show on Dashboard filters, but it does in discover and visualizations](https://discuss.elastic.co/t/exisisting-field-doesnt-show-on-dashboard-filters-but-it-does-in-discover-and-visualizations/257691)

<div class="topic-metadata">

**Author:** [@Incauto](https://discuss.elastic.co/u/Incauto)\
**Replies:** 3\
**Last updated:** [December 8, 2020, 10:14am UTC](https://discuss.elastic.co/t/exisisting-field-doesnt-show-on-dashboard-filters-but-it-does-in-discover-and-visualizations/257691 "2020-12-08T10:14:55Z")

</div>

Hi a specific field doesn't show on the filter of the dashboards, but it exists and can be found in discovery and in the visualizations I have reloaded the index pattern, checked his existance through a month, but …

---

## [Kibana 7.10 Dashboard Drilldown - filter on fewer values in destination dashbaord)](https://discuss.elastic.co/t/kibana-7-10-dashboard-drilldown-filter-on-fewer-values-in-destination-dashbaord/257821)

<div class="topic-metadata">

**Author:** [@AndyH](https://discuss.elastic.co/u/AndyH)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 9:16am UTC](https://discuss.elastic.co/t/kibana-7-10-dashboard-drilldown-filter-on-fewer-values-in-destination-dashbaord/257821 "2020-12-08T09:16:21Z")

</div>

I've been playing with the new Create Drilldown feature available in Kibana 7.10 dashboards. On the parent dashboard I have a stacked horizontal bar chart: The y-axis (i.e. bar label) is a "Site Name" The x-axis (i.e.…

---

## [Failed to execute 'Download CSV'](https://discuss.elastic.co/t/failed-to-execute-download-csv/257603)

<div class="topic-metadata">

**Author:** [@t98907](https://discuss.elastic.co/u/t98907)\
**Replies:** 6\
**Last updated:** [December 8, 2020, 8:52am UTC](https://discuss.elastic.co/t/failed-to-execute-download-csv/257603 "2020-12-08T08:52:02Z")

</div>

Hi there, Kibana: 7.8.0 'Download CSV' failed even though I am logged in as 'elastic' user. Must '\_source' be enabled on the index to run 'Download CSV'?

---

## [Elastic ingest pipeline grok filter error](https://discuss.elastic.co/t/elastic-ingest-pipeline-grok-filter-error/257706)

<div class="topic-metadata">

**Author:** [@vsv0001](https://discuss.elastic.co/u/vsv0001)\
**Replies:** 2\
**Last updated:** [December 8, 2020, 3:05am UTC](https://discuss.elastic.co/t/elastic-ingest-pipeline-grok-filter-error/257706 "2020-12-08T03:05:03Z")

</div>

hi, I am trying to to build an ingest pipeline using grok processor my grok filter works on the Kibana-\>console . grok filter ^%{YEAR}-%{MONTHNUM}-%{MONTHDAY} %{TIME}.%{LOGLEVEL:log-level} : \\\[%{DATA:user}\] \\\[%{DATA:…

---

## [Kibana, xpack, nginx proxy and authentication](https://discuss.elastic.co/t/kibana-xpack-nginx-proxy-and-authentication/257138)

<div class="topic-metadata">

**Author:** [@annanicotera](https://discuss.elastic.co/u/annanicotera)\
**Replies:** 2\
**Last updated:** [December 7, 2020, 10:06pm UTC](https://discuss.elastic.co/t/kibana-xpack-nginx-proxy-and-authentication/257138 "2020-12-07T22:06:53Z")

</div>

Hello, We have embedded Kibana dashboards in our application. if xpack security is enabled, we configure a nginx proxy so that the user viewing the dashboards can seamlessly access/view the dashboards without having to …

---

## [TSVB Visualization is working differently in Read Only mode dashboard](https://discuss.elastic.co/t/tsvb-visualization-is-working-differently-in-read-only-mode-dashboard/257913)

<div class="topic-metadata">

**Author:** [@gaurav1](https://discuss.elastic.co/u/gaurav1)\
**Replies:** 0\
**Last updated:** [December 7, 2020, 9:26pm UTC](https://discuss.elastic.co/t/tsvb-visualization-is-working-differently-in-read-only-mode-dashboard/257913 "2020-12-07T21:26:20Z")

</div>

I have used Markdown in TSVB visualization for creating a master dashboards which contains static data like dashboard name and its URL. The standalone markdown visualization does not support CSS for formatting the text s…

[Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=388)

[Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=390)
