# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=568 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 569 --- ## [How to get unique hosts in the visualisation](https://discuss.elastic.co/t/how-to-get-unique-hosts-in-the-visualisation/210208)
**Author:** [@Sreekanth3](https://discuss.elastic.co/u/Sreekanth3)\ **Replies:** 0\ **Last updated:** [December 2, 2019, 3:25pm UTC](https://discuss.elastic.co/t/how-to-get-unique-hosts-in-the-visualisation/210208 "2019-12-02T15:25:09Z")
How to get the unique hosts and recipients without repeating them. I have used TOP HIT , but there is unique count option which is showing only count but , I need the name of the hosts also . I have used the Table visu… --- ## [Show rollup in canvas](https://discuss.elastic.co/t/show-rollup-in-canvas/210152)
**Author:** [@wifi](https://discuss.elastic.co/u/wifi)\ **Replies:** 0\ **Last updated:** [December 2, 2019, 10:11am UTC](https://discuss.elastic.co/t/show-rollup-in-canvas/210152 "2019-12-02T10:11:56Z")
I have set up a rollup job to summarize data. Now i want to display it in a canvas but it seems like the canvas can't handle rollup data. I try to use my\_date\_field.date\_histogram.timestamp but it won't recognize the ti… --- ## [Show latest value](https://discuss.elastic.co/t/show-latest-value/210064)
**Author:** [@Shahar](https://discuss.elastic.co/u/Shahar)\ **Replies:** 1\ **Last updated:** [December 2, 2019, 8:37am UTC](https://discuss.elastic.co/t/show-latest-value/210064 "2019-12-02T08:37:42Z")
Hi, I searched the forum and saw a few options but none solved my problem. (ex example link ) Anyway. Im facing a problem which I have 3 relevant fields: organization, userName and vmCount I want to show for each org… --- ## [How to apply new time format of range in kibana's request query when visualizing data](https://discuss.elastic.co/t/how-to-apply-new-time-format-of-range-in-kibanas-request-query-when-visualizing-data/210101)
**Author:** [@myohyun](https://discuss.elastic.co/u/myohyun)\ **Replies:** 2\ **Last updated:** [December 2, 2019, 7:09am UTC](https://discuss.elastic.co/t/how-to-apply-new-time-format-of-range-in-kibanas-request-query-when-visualizing-data/210101 "2019-12-02T07:09:02Z")
Hi, I have a question about changing time format in range query when visualizing data. I have a date field 'time local' and its format is "dd/MMM/YYYY:HH:mm:ss Z" ex. "time\_local": "15/Nov/2019:16:49:53 +0900", The… --- ## [Moving Average in Timelion](https://discuss.elastic.co/t/moving-average-in-timelion/209948)
**Author:** [@Georg\_Seibt](https://discuss.elastic.co/u/Georg_Seibt)\ **Replies:** 2\ **Last updated:** [December 2, 2019, 7:04am UTC](https://discuss.elastic.co/t/moving-average-in-timelion/209948 "2019-12-02T07:04:37Z")
Hello, I am trying to visulaize some more comlex metrics with timelion. I have a value per day (average number of events per user) and I want to know if that number is higher than the moving average of the last 7 days (… --- ## [Failed to parse date field from kibana](https://discuss.elastic.co/t/failed-to-parse-date-field-from-kibana/210067)
**Author:** [@Yoav\_Ben\_Moha](https://discuss.elastic.co/u/Yoav_Ben_Moha)\ **Replies:** 1\ **Last updated:** [December 1, 2019, 6:55pm UTC](https://discuss.elastic.co/t/failed-to-parse-date-field-from-kibana/210067 "2019-12-01T18:55:55Z")
I have created a template with 3 fields. The last one is DATE format. The template index created successfully: PUT \_template/test\_index\_template { "index\_patterns" : \["test-\*"\], "settings": { "number\_of\_shards": … --- ## [Accessing AppSync API from Kibana Plugin](https://discuss.elastic.co/t/accessing-appsync-api-from-kibana-plugin/210027)
**Author:** [@firabby](https://discuss.elastic.co/u/firabby)\ **Replies:** 0\ **Last updated:** [November 30, 2019, 12:29pm UTC](https://discuss.elastic.co/t/accessing-appsync-api-from-kibana-plugin/210027 "2019-11-30T12:29:19Z")
Say, I have configured Kibana and Elasticsearch to use OpenID Connect Single Sign On (using AWS Cognito). Will I be able to access AppSync API from a custom Kibana plugin? How do I configure AWS Amplify to access AppSync… --- ## [Average on current visualization](https://discuss.elastic.co/t/average-on-current-visualization/209899)
**Author:** [@gibo](https://discuss.elastic.co/u/gibo)\ **Replies:** 4\ **Last updated:** [November 30, 2019, 12:26pm UTC](https://discuss.elastic.co/t/average-on-current-visualization/209899 "2019-11-30T12:26:46Z")
Good evening, i'm trying to make a simple average but maybe i'm focused on a wrong way that is been leading me astray. I'm using Kibana to show some productivity data coming from a industrial production plant. I've in … --- ## [Advances graphical charts in kibana](https://discuss.elastic.co/t/advances-graphical-charts-in-kibana/210020)
**Author:** [@kumar4](https://discuss.elastic.co/u/kumar4)\ **Replies:** 0\ **Last updated:** [November 30, 2019, 8:22am UTC](https://discuss.elastic.co/t/advances-graphical-charts-in-kibana/210020 "2019-11-30T08:22:44Z")
is it possible to make more advanced graphic charters on Kibana, for example clickable graphic charters, when can i get the detail (data), is there a way to make this type advanced graphic charter because the dashboard s… --- ## [How to create vertical bar for total no.of employees and no.of present](https://discuss.elastic.co/t/how-to-create-vertical-bar-for-total-no-of-employees-and-no-of-present/209975)
**Author:** [@saravana\_hariharan](https://discuss.elastic.co/u/saravana_hariharan)\ **Replies:** 1\ **Last updated:** [November 29, 2019, 8:09pm UTC](https://discuss.elastic.co/t/how-to-create-vertical-bar-for-total-no-of-employees-and-no-of-present/209975 "2019-11-29T20:09:01Z")
how to create vertical bar for total no.of employees and no.of present i have all the datas but unable to visualized --- ## [Filtering data in Coordinate Map (using Kibana 6.6.1)](https://discuss.elastic.co/t/filtering-data-in-coordinate-map-using-kibana-6-6-1/209957)
**Author:** [@vincent2mots](https://discuss.elastic.co/u/vincent2mots)\ **Replies:** 3\ **Last updated:** [November 29, 2019, 3:25pm UTC](https://discuss.elastic.co/t/filtering-data-in-coordinate-map-using-kibana-6-6-1/209957 "2019-11-29T15:25:29Z")
Hi experts! I created a coordinate map (with a standard count aggregation) and I would like to filter data by clicking on one point... But it doesn't work. How could I achieve that? Best regards, --- ## [Show in Kibana a Metric with the output of an arbitrary elasticsearch query](https://discuss.elastic.co/t/show-in-kibana-a-metric-with-the-output-of-an-arbitrary-elasticsearch-query/209442)
**Author:** [@IvanHerreros](https://discuss.elastic.co/u/IvanHerreros)\ **Replies:** 3\ **Last updated:** [November 29, 2019, 2:38pm UTC](https://discuss.elastic.co/t/show-in-kibana-a-metric-with-the-output-of-an-arbitrary-elasticsearch-query/209442 "2019-11-29T14:38:30Z")
I want to display in Kibana a metric visualization (a.k.a. a number) whose value computed with a pipeline aggregation ES query. More concretely the query is built based on this one: https://stackoverflow.com/questions/4… --- ## [What are Kibana Index and Kibana Task Manager?](https://discuss.elastic.co/t/what-are-kibana-index-and-kibana-task-manager/208107)
**Author:** [@lantern77](https://discuss.elastic.co/u/lantern77)\ **Replies:** 4\ **Last updated:** [November 29, 2019, 2:13pm UTC](https://discuss.elastic.co/t/what-are-kibana-index-and-kibana-task-manager/208107 "2019-11-29T14:13:58Z")
I've been playing around with the new Kibana and Elasticsearch 7. I spun each up and noticed that kibana added two new indices, .kibana\_1 and .kibana\_task\_manager\_1. What has happened to the old .kibana index, and I can'… --- ## [Kibana SSL](https://discuss.elastic.co/t/kibana-ssl/209515)
**Author:** [@Flaviu](https://discuss.elastic.co/u/Flaviu)\ **Replies:** 6\ **Last updated:** [November 29, 2019, 11:40am UTC](https://discuss.elastic.co/t/kibana-ssl/209515 "2019-11-29T11:40:43Z")
I am using Kibana over SSL. After a certificate update (Letsencyrpt renew the certificates every 3 months) I started to get an error { "type":"error", "@timestamp":"2019-11-26T12:52:22Z", "tags":\[ "conn… --- ## [Can i update eui in my kibana?](https://discuss.elastic.co/t/can-i-update-eui-in-my-kibana/209682)
**Author:** [@masterThomas](https://discuss.elastic.co/u/masterThomas)\ **Replies:** 3\ **Last updated:** [November 29, 2019, 8:59am UTC](https://discuss.elastic.co/t/can-i-update-eui-in-my-kibana/209682 "2019-11-29T08:59:31Z")
hi team, i use Kibana 6.7 and developing apps there, so i have eui 6.10.8. Official docs has Elastic UI version 16.0.1 . So can i update my eui up to 16.0.1 in kibana 6.7 to use it for developing? P.S updating Kibana t… --- ## [Limited drop down list when filtering](https://discuss.elastic.co/t/limited-drop-down-list-when-filtering/209768)
**Author:** [@Voula\_Mikr](https://discuss.elastic.co/u/Voula_Mikr)\ **Replies:** 2\ **Last updated:** [November 29, 2019, 8:48am UTC](https://discuss.elastic.co/t/limited-drop-down-list-when-filtering/209768 "2019-11-29T08:48:41Z")
Hi, I have in Elastic the below data: I also made the below graph : Vnf z1 has as counters MemUsed & CpuUsed, whereas vnf z2 has as counters CpuUsed & MaxCpuUsed. If I filter the above graph with "vnf\_name is z1… --- ## [Kibana report export CSV file wrong date format](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882)
**Author:** [@OrlandoEscalante](https://discuss.elastic.co/u/OrlandoEscalante)\ **Replies:** 2\ **Last updated:** [November 28, 2019, 7:10pm UTC](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882 "2019-11-28T19:10:54Z")
Kibana/ES version 7.4.1 After a search in Kibana, the results are showed in the right format in Kibana, but after those results are exported as CSV file, they are showed all in the file as 1970-\* This is a similar issu… --- ## [Dashboard links requires vega.enableExternalUrls: true](https://discuss.elastic.co/t/dashboard-links-requires-vega-enableexternalurls-true/209675)
**Author:** [@DavidKHE](https://discuss.elastic.co/u/DavidKHE)\ **Replies:** 7\ **Last updated:** [November 28, 2019, 5:52pm UTC](https://discuss.elastic.co/t/dashboard-links-requires-vega-enableexternalurls-true/209675 "2019-11-28T17:52:49Z")
Hi, after some analysis we learned to understand that this is not possible set vega.enableExternalUrls: true in the Kibana hosted by Elastic Cloud. as we are currently using HREF in vega visualisation for Kibana to nav… --- ## [Called with an invalid endpoint: sql.query](https://discuss.elastic.co/t/called-with-an-invalid-endpoint-sql-query/209586)
**Author:** [@pgervais](https://discuss.elastic.co/u/pgervais)\ **Replies:** 1\ **Last updated:** [November 28, 2019, 3:54pm UTC](https://discuss.elastic.co/t/called-with-an-invalid-endpoint-sql-query/209586 "2019-11-28T15:54:58Z")
I'm trying to develop a kibana plugin (Elasticsearch & Kibana both Ver 7.4.1). In order to get started i have used the known plugin analyse\_api as an example and starting point. I'm trying to invoke the Elasticsearch AP… --- ## [Issues with converting parsed Logstash logs to Kibana - 6.8.2](https://discuss.elastic.co/t/issues-with-converting-parsed-logstash-logs-to-kibana-6-8-2/209708)
**Author:** [@JPetrucka](https://discuss.elastic.co/u/JPetrucka)\ **Replies:** 7\ **Last updated:** [November 28, 2019, 3:04pm UTC](https://discuss.elastic.co/t/issues-with-converting-parsed-logstash-logs-to-kibana-6-8-2/209708 "2019-11-28T15:04:11Z")
Hey everyone, We are having issues taking the parsed logs from Logstash and ingesting them into Kibana to produce tags and graphs. The error states "No cached mapping for this field. Refresh list from Management \> Index… --- ## [Create Dashboard for indices of different servers with different prefix](https://discuss.elastic.co/t/create-dashboard-for-indices-of-different-servers-with-different-prefix/209846)
**Author:** [@JayshreeR](https://discuss.elastic.co/u/JayshreeR)\ **Replies:** 1\ **Last updated:** [November 28, 2019, 1:48pm UTC](https://discuss.elastic.co/t/create-dashboard-for-indices-of-different-servers-with-different-prefix/209846 "2019-11-28T13:48:47Z")
I have two indices, one for zipkin and one for logstash. And there is common field in both i.e. traceId. I want to create a Kibana dashboard where I can collect different fields from both indices together(using common f… --- ## [Plugin development for dashboard](https://discuss.elastic.co/t/plugin-development-for-dashboard/209698)
**Author:** [@ultimatezio](https://discuss.elastic.co/u/ultimatezio)\ **Replies:** 2\ **Last updated:** [November 28, 2019, 1:05pm UTC](https://discuss.elastic.co/t/plugin-development-for-dashboard/209698 "2019-11-28T13:05:12Z")
Hi all, I'm trying to develop a kibana's plugin. My goal is that every time a user access a dashboard, the kibana's server log a users credential (username only) and the dashboard name. I have an idea of what to make… --- ## [Kibana and index patterns performance](https://discuss.elastic.co/t/kibana-and-index-patterns-performance/209564)
**Author:** [@mtudisco](https://discuss.elastic.co/u/mtudisco)\ **Replies:** 3\ **Last updated:** [November 28, 2019, 12:27pm UTC](https://discuss.elastic.co/t/kibana-and-index-patterns-performance/209564 "2019-11-28T12:27:45Z")
Hi all, I'm collecting information with filebeat, procesing it with logstash and storing in elasticsearch. I have different types and sub-types of information, and indexing the information with something similar to %{\[… --- ## [Reporting generation vs timeout](https://discuss.elastic.co/t/reporting-generation-vs-timeout/208853)
**Author:** [@stefws](https://discuss.elastic.co/u/stefws)\ **Replies:** 8\ **Last updated:** [November 28, 2019, 12:26pm UTC](https://discuss.elastic.co/t/reporting-generation-vs-timeout/208853 "2019-11-28T12:26:26Z")
Got a Kibana 7.4.2 instance behind a HAproxy which fails to generate PDF reports and wondering howto debug this issue further. Seeing this in my kibana log: {"type":"log","@timestamp":"2019-11-21T09:56:37Z","tags":\["r… --- ## [Filter in control visualization](https://discuss.elastic.co/t/filter-in-control-visualization/209834)
**Author:** [@Marcos\_David\_Moreno](https://discuss.elastic.co/u/Marcos_David_Moreno)\ **Replies:** 1\ **Last updated:** [November 28, 2019, 11:40am UTC](https://discuss.elastic.co/t/filter-in-control-visualization/209834 "2019-11-28T11:40:34Z")
Hello, I want to filter a field in a control visualization but I have tried to insert a filter in the header filter but it doesn´t work. Is it possible? I mean, apply any filter on Control. Another option for me would… --- ## [Trellis change font color of the row labels](https://discuss.elastic.co/t/trellis-change-font-color-of-the-row-labels/209644)
**Author:** [@kilianten](https://discuss.elastic.co/u/kilianten)\ **Replies:** 2\ **Last updated:** [November 28, 2019, 10:03am UTC](https://discuss.elastic.co/t/trellis-change-font-color-of-the-row-labels/209644 "2019-11-28T10:03:44Z")
Hey! Im building a vega diagram using something similar to this trellis example: Its split by row and I can't change the font color of (in the example above gender & male feminine) I was hoping "row": {"field": "ge… --- ## [Not all data in controls visualization Kibana](https://discuss.elastic.co/t/not-all-data-in-controls-visualization-kibana/209715)
**Author:** [@g\_k\_b](https://discuss.elastic.co/u/g_k_b)\ **Replies:** 1\ **Last updated:** [November 28, 2019, 9:42am UTC](https://discuss.elastic.co/t/not-all-data-in-controls-visualization-kibana/209715 "2019-11-28T09:42:06Z")
Hello there, I'm using controls visualization in kibana 7.3 and, both if I select "dynamic options" or not, when I digit the value I want to filter for, I get the message "It doesn't match any option!". But I know for s… --- ## [Not able to view saved object after importing via API](https://discuss.elastic.co/t/not-able-to-view-saved-object-after-importing-via-api/209666)
**Author:** [@kibana-rocks](https://discuss.elastic.co/u/kibana-rocks)\ **Replies:** 3\ **Last updated:** [November 28, 2019, 9:18am UTC](https://discuss.elastic.co/t/not-able-to-view-saved-object-after-importing-via-api/209666 "2019-11-28T09:18:34Z")
Hi, I imported multiple saved\_objects (index-pattern, visualization, dashboard) via POST /api/saved\_objects/\_import API. It gives successful response code -200 as response code for all saved objects. But when i check i… --- ## [Visualize: Data Table formation fails with error message 'Unable to get property '4' of undefined or null reference'](https://discuss.elastic.co/t/visualize-data-table-formation-fails-with-error-message-unable-to-get-property-4-of-undefined-or-null-reference/209690)
**Author:** [@vpatel99](https://discuss.elastic.co/u/vpatel99)\ **Replies:** 3\ **Last updated:** [November 28, 2019, 8:46am UTC](https://discuss.elastic.co/t/visualize-data-table-formation-fails-with-error-message-unable-to-get-property-4-of-undefined-or-null-reference/209690 "2019-11-28T08:46:21Z")
Hello, I am facing error while attempting to create Data Table in Kibana (6.2.2) Visualize. The error message is observed while performing sub aggregation on Numeric field when 'Show missing values' is slected. Appare… --- ## [Timelion returns incorrect data](https://discuss.elastic.co/t/timelion-returns-incorrect-data/205935)
**Author:** [@jasmineL](https://discuss.elastic.co/u/jasmineL)\ **Replies:** 2\ **Last updated:** [November 28, 2019, 4:08am UTC](https://discuss.elastic.co/t/timelion-returns-incorrect-data/205935 "2019-11-28T04:08:01Z")
I am using Kibana 5.6 Timelion right now and found some weird behavior. I am setting an absolute time 2019-10-29 00:00:00.000 to 2019-10-29 23:59:59.999. And split rows by date histogram with daily interval. The data t… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=567) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=569)