# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=648 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 649 --- ## [Apply field formater (color) to table metric count?](https://discuss.elastic.co/t/apply-field-formater-color-to-table-metric-count/187032)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 3:07pm UTC](https://discuss.elastic.co/t/apply-field-formater-color-to-table-metric-count/187032 "2019-06-28T15:07:52Z")
Hi, Is it possible to format the metric (e.g. count) in the table viz the same way you can apply the color field format to a index pattern? I want the count value to be a certain color depending on the size of the coun… --- ## [How to get count aggregate as 0 in vega-lite+Kibana?](https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747)
**Author:** [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 3:05pm UTC](https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747 "2019-06-28T15:05:02Z")
Hi, Query : Trying to get some aggregations through Kibana's vega-lite visualization, however when there are no records, the aggregate is not shown as 0. Is there any way for aggregate to start from 0,1,2, something li… --- ## [A chart to show: hour of the day vs delayed flight vs ticket cancelation](https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781)
**Author:** [@adrianovieira](https://discuss.elastic.co/u/adrianovieira)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 2:54pm UTC](https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781 "2019-06-28T14:54:29Z")
It should be good a dashboard like this. So, how to build a chart from ELK demo data to show: hour of the day (via timestamp) vs flight delay vs ticket cancellation; hour of the day (via timestamp) vs flight delay v… --- ## [Charts with stictly defined Timezone](https://discuss.elastic.co/t/charts-with-stictly-defined-timezone/187287)
**Author:** [@Serghey\_Rodin](https://discuss.elastic.co/u/Serghey_Rodin)\ **Replies:** 4\ **Last updated:** [June 28, 2019, 2:46pm UTC](https://discuss.elastic.co/t/charts-with-stictly-defined-timezone/187287 "2019-06-28T14:46:42Z")
I'd like to make a bar chart that will display monthly stats without offsetting timestamp with users time zone. The problem is that for example record 2019-02-01T00:00:00.000Z for Kibana user in EST timezone will be di… --- ## [formatNumber not working for Metric](https://discuss.elastic.co/t/formatnumber-not-working-for-metric/186958)
**Author:** [@gbarnett](https://discuss.elastic.co/u/gbarnett)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 2:23pm UTC](https://discuss.elastic.co/t/formatnumber-not-working-for-metric/186958 "2019-06-28T14:23:29Z")
I'm trying to format a number with leading 0's in a Canvas Metric element. In the expression editor I have: | math "count" | formatnumber format="0000" It displays "count" just fine, but never with the leading 0's. … --- ## [\[Visualize\] Aggregation in Ranger Slider Control](https://discuss.elastic.co/t/visualize-aggregation-in-ranger-slider-control/187717)
**Author:** [@Zany](https://discuss.elastic.co/u/Zany)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 2:06pm UTC](https://discuss.elastic.co/t/visualize-aggregation-in-ranger-slider-control/187717 "2019-06-28T14:06:41Z")
Can we apply aggregation to the field in Ranger Slider control? Aggregation: Unique Count Field: products.product\_id --- ## [Pagination in Data Table visualization](https://discuss.elastic.co/t/pagination-in-data-table-visualization/188058)
**Author:** [@renjithit](https://discuss.elastic.co/u/renjithit)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 2:04pm UTC](https://discuss.elastic.co/t/pagination-in-data-table-visualization/188058 "2019-06-28T14:04:52Z")
I have configured Data table visualizer with page size as 25. I can see page is loading with 25 records but cannot able to find pagination link to go to next page. Please help --- ## [Shrinking an index if it is smaller than a certain value](https://discuss.elastic.co/t/shrinking-an-index-if-it-is-smaller-than-a-certain-value/187997)
**Author:** [@Bellicapelli0](https://discuss.elastic.co/u/Bellicapelli0)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 2:03pm UTC](https://discuss.elastic.co/t/shrinking-an-index-if-it-is-smaller-than-a-certain-value/187997 "2019-06-28T14:03:41Z")
Goodmorning all, I am trying to implement this feature in my environment, and was wondering if it was possible: I have a log index that is created daily, and is mapped on 5 shards, 1 replica. At the end of the day, I w… --- ## [Plain HTML in markdown in kibana canvas](https://discuss.elastic.co/t/plain-html-in-markdown-in-kibana-canvas/187856)
**Author:** [@Malini\_Sahoo](https://discuss.elastic.co/u/Malini_Sahoo)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 1:37pm UTC](https://discuss.elastic.co/t/plain-html-in-markdown-in-kibana-canvas/187856 "2019-06-28T13:37:52Z")
Hi , can we use plain HTML in markdown in kibana canvas ? --- ## [Change background colour of one image by hovering on another image in kibana canvas](https://discuss.elastic.co/t/change-background-colour-of-one-image-by-hovering-on-another-image-in-kibana-canvas/186948)
**Author:** [@Malini\_Sahoo](https://discuss.elastic.co/u/Malini_Sahoo)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 1:35pm UTC](https://discuss.elastic.co/t/change-background-colour-of-one-image-by-hovering-on-another-image-in-kibana-canvas/186948 "2019-06-28T13:35:09Z")
Hi,can we change background colour of one image by hovering on another image in kibana canvas? --- ## [Problem: Interpolation on charts](https://discuss.elastic.co/t/problem-interpolation-on-charts/186889)
**Author:** [@magniko](https://discuss.elastic.co/u/magniko)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 1:33pm UTC](https://discuss.elastic.co/t/problem-interpolation-on-charts/186889 "2019-06-28T13:33:38Z")
Hi all I'm working on visualizing stocks in Canvas using charts. However, as one might know, the stock marked is usually only open between 9:30am-4pm, and is also closed on weekends. Thus when loading the stock data, … --- ## [Dashboards with sub-dashboards](https://discuss.elastic.co/t/dashboards-with-sub-dashboards/187633)
**Author:** [@John-Westrich](https://discuss.elastic.co/u/John-Westrich)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 1:30pm UTC](https://discuss.elastic.co/t/dashboards-with-sub-dashboards/187633 "2019-06-28T13:30:39Z")
I have multiple dashboards with related content. I want them in separate dashboards so that it is easier to drill into and not have 20 visualizations in 1 dashboard. I am wondering if there is a way to create 1 "dashboar… --- ## [How to change colour in pie chart according to value in kibana canvas](https://discuss.elastic.co/t/how-to-change-colour-in-pie-chart-according-to-value-in-kibana-canvas/187014)
**Author:** [@Malini\_Sahoo](https://discuss.elastic.co/u/Malini_Sahoo)\ **Replies:** 1\ **Last updated:** [June 28, 2019, 1:29pm UTC](https://discuss.elastic.co/t/how-to-change-colour-in-pie-chart-according-to-value-in-kibana-canvas/187014 "2019-06-28T13:29:30Z")
Hi, how to change colour in pie chart according to value in kibana canvas? --- ## [Dashboard data showing 0 in intervals](https://discuss.elastic.co/t/dashboard-data-showing-0-in-intervals/187992)
**Author:** [@maasid](https://discuss.elastic.co/u/maasid)\ **Replies:** 6\ **Last updated:** [June 28, 2019, 1:21pm UTC](https://discuss.elastic.co/t/dashboard-data-showing-0-in-intervals/187992 "2019-06-28T13:21:51Z")
Hello, I have setup multiple dashboards, ranging from Metricbeat, Filebeat, Packetbeat etc. When I'm looking at my Metricbeat dashboards I have the refresh set to 10 sec and the span set to 15m, on each refresh I may or… --- ## [Setting privileges to spaces, privileges not working on default space](https://discuss.elastic.co/t/setting-privileges-to-spaces-privileges-not-working-on-default-space/187977)
**Author:** [@Saurabh\_Sharma\_IIT](https://discuss.elastic.co/u/Saurabh_Sharma_IIT)\ **Replies:** 8\ **Last updated:** [June 28, 2019, 9:49am UTC](https://discuss.elastic.co/t/setting-privileges-to-spaces-privileges-not-working-on-default-space/187977 "2019-06-28T09:49:23Z")
Hi, I am using security feature in my project. I have three spaces, test1, test2 and default. I created a role and set privileges: test1: read test2: none default: none Now I created a user: test\_user with this role… --- ## [Painless script for converting Long to Hexadecimal](https://discuss.elastic.co/t/painless-script-for-converting-long-to-hexadecimal/186563)
**Author:** [@baerrach](https://discuss.elastic.co/u/baerrach)\ **Replies:** 3\ **Last updated:** [June 28, 2019, 8:17am UTC](https://discuss.elastic.co/t/painless-script-for-converting-long-to-hexadecimal/186563 "2019-06-28T08:17:03Z")
Have Kibana display a numeric field value in hexadecimal is locked, and the example is an image (and broken) which is not useful for cut-and-paste. If it wasn't locked I'd just reply there. I needed to change the dns.id… --- ## [Conditional color coding of entire row in Data Tables](https://discuss.elastic.co/t/conditional-color-coding-of-entire-row-in-data-tables/187063)
**Author:** [@bpallagani](https://discuss.elastic.co/u/bpallagani)\ **Replies:** 4\ **Last updated:** [June 28, 2019, 6:14am UTC](https://discuss.elastic.co/t/conditional-color-coding-of-entire-row-in-data-tables/187063 "2019-06-28T06:14:41Z")
Hi, I want to change the color of entire row in a Data Table in Kibana depending on the value of one field (cell) in that row. I am able to change the particular field/cell from index pattern. But I want to know if it … --- ## [\[solved\] Kibana Monitoring \[illegal\_argument\_exception\]](https://discuss.elastic.co/t/solved-kibana-monitoring-illegal-argument-exception/187974)
**Author:** [@rog\_NB](https://discuss.elastic.co/u/rog_NB)\ **Replies:** 0\ **Last updated:** [June 28, 2019, 5:32am UTC](https://discuss.elastic.co/t/solved-kibana-monitoring-illegal-argument-exception/187974 "2019-06-28T05:32:58Z")
I'm on my Lab to update from 6.6.1 to 7.2 After all work done, I had on the tab Monitoring this error on the lower right corner of the browser: Monitoring Request Error \[illegal\_argument\_exception\] Fielddata is disa… --- ## [Have Kibana display a numeric field value in hexadecimal](https://discuss.elastic.co/t/have-kibana-display-a-numeric-field-value-in-hexadecimal/106488)
**Author:** [@makibroshett](https://discuss.elastic.co/u/makibroshett)\ **Replies:** 3\ **Last updated:** [June 27, 2019, 11:17pm UTC](https://discuss.elastic.co/t/have-kibana-display-a-numeric-field-value-in-hexadecimal/106488 "2019-06-27T23:17:49Z")
Hello, How can I tell Kibana to display a numeric field in hexadecimal or octal? I have looked into the formatting options and numeral.js, but nothing concerning which base to use for displaying numeric values... I'd … --- ## [Upgrade to 7.2](https://discuss.elastic.co/t/upgrade-to-7-2/187913)
**Author:** [@mathurin68](https://discuss.elastic.co/u/mathurin68)\ **Replies:** 2\ **Last updated:** [June 27, 2019, 11:11pm UTC](https://discuss.elastic.co/t/upgrade-to-7-2/187913 "2019-06-27T23:11:39Z")
My upgrade of my elkstack 6.8 to 7.2 seems to have gone OK(cluster is green) except for the following kibana error - money@elkstack:/etc/kibana$ sudo systemctl status kibana.service ● kibana.service - Kibana Loaded: … --- ## [Import API path 404 error](https://discuss.elastic.co/t/import-api-path-404-error/186355)
**Author:** [@cuzzo333](https://discuss.elastic.co/u/cuzzo333)\ **Replies:** 2\ **Last updated:** [June 27, 2019, 9:44pm UTC](https://discuss.elastic.co/t/import-api-path-404-error/186355 "2019-06-27T21:44:19Z")
Hello. We're attempting to begin using the Kibana export/import API to develop some automation around backing up our Kibana dashboards. While I'm able to reach the export API the import API path is returning the 404 er… --- ## [Kibana 7 deploy crashes ELK bound work](https://discuss.elastic.co/t/kibana-7-deploy-crashes-elk-bound-work/187668)
**Author:** [@Alexl](https://discuss.elastic.co/u/Alexl)\ **Replies:** 2\ **Last updated:** [June 27, 2019, 7:18pm UTC](https://discuss.elastic.co/t/kibana-7-deploy-crashes-elk-bound-work/187668 "2019-06-27T19:18:52Z")
Hello all! How to configure ELK 7 to rapidly show data in Kibana that was parsed by Logstash in the text files parse meaning without equilibristic? Thank you. --- ## [Kibana elasticsearch.hosts setting (7.1)](https://discuss.elastic.co/t/kibana-elasticsearch-hosts-setting-7-1/185575)
**Author:** [@shahab](https://discuss.elastic.co/u/shahab)\ **Replies:** 1\ **Last updated:** [June 27, 2019, 5:16pm UTC](https://discuss.elastic.co/t/kibana-elasticsearch-hosts-setting-7-1/185575 "2019-06-27T17:16:40Z")
I have a 3 nodes cluster (version 7.1) in the following nodes: xxx.xxx.xx.122 xxx.xxx.xx.123 xxx.xxx.xx.124 And kibana is in xxx.xxx.xx.123. The setting in the kibana.yml for elasticsearch.hosts is: elasticsearch.h… --- ## [Data Table troubles](https://discuss.elastic.co/t/data-table-troubles/184246)
**Author:** [@JerryWintrode](https://discuss.elastic.co/u/JerryWintrode)\ **Replies:** 2\ **Last updated:** [June 27, 2019, 4:51pm UTC](https://discuss.elastic.co/t/data-table-troubles/184246 "2019-06-27T16:51:07Z")
I am having an issue building a data table visualization. I have data that contains a username, and an activity. I need a report for management that shows how many times a given user did each activity, in this case they… --- ## [Can we import data from one log into another?](https://discuss.elastic.co/t/can-we-import-data-from-one-log-into-another/187413)
**Author:** [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\ **Replies:** 2\ **Last updated:** [June 27, 2019, 4:30pm UTC](https://discuss.elastic.co/t/can-we-import-data-from-one-log-into-another/187413 "2019-06-27T16:30:31Z")
I am given a task on creating a visualization for a particular log type. When I am trying to filter that log in ELK, I am unable to see the whole data related to that log.To be specific I am unable to find the metrics re… --- ## [Can't find function that filters data](https://discuss.elastic.co/t/cant-find-function-that-filters-data/186558)
**Author:** [@slane](https://discuss.elastic.co/u/slane)\ **Replies:** 1\ **Last updated:** [June 27, 2019, 4:19pm UTC](https://discuss.elastic.co/t/cant-find-function-that-filters-data/186558 "2019-06-27T16:19:54Z")
I'm working on trying to develop a way allow users to click on data points on vega graphs to create a filters, in the same way that users currently can on the Kibana native graphs. I am not having any luck with finding t… --- ## [Modify the title description (mouse over event)](https://discuss.elastic.co/t/modify-the-title-description-mouse-over-event/186729)
**Author:** [@111165](https://discuss.elastic.co/u/111165)\ **Replies:** 1\ **Last updated:** [June 27, 2019, 4:09pm UTC](https://discuss.elastic.co/t/modify-the-title-description-mouse-over-event/186729 "2019-06-27T16:09:26Z")
Hi, good day:) Is it possible to modify the title description(mouse over event, as shown below) of a visualisation on a dashboard? kibana version:6.6.2 many thanks. --- ## [Single metric job not real time, not reporting missed ingestions](https://discuss.elastic.co/t/single-metric-job-not-real-time-not-reporting-missed-ingestions/187369)
**Author:** [@samg](https://discuss.elastic.co/u/samg)\ **Replies:** 10\ **Last updated:** [June 27, 2019, 3:49pm UTC](https://discuss.elastic.co/t/single-metric-job-not-real-time-not-reporting-missed-ingestions/187369 "2019-06-27T15:49:51Z")
v7.1.0 I am trying to create a simple single metric job to monitor the total number of documents ingested daily on a specific index. I took the following steps in Kibana to create what I thought would be an appropriate … --- ## [Date Format for "2019-06-14T08:04:38.000Z"](https://discuss.elastic.co/t/date-format-for-2019-06-14t0838-000z/186811)
**Author:** [@rakotomandimby](https://discuss.elastic.co/u/rakotomandimby)\ **Replies:** 1\ **Last updated:** [June 27, 2019, 3:46pm UTC](https://discuss.elastic.co/t/date-format-for-2019-06-14t0838-000z/186811 "2019-06-27T15:46:27Z")
Hi all, Using Kibana Kibana 7.0.1, I have a "timestamp" field that has the following format: "2019-06-14T08:04:38.000Z" Looking at https://momentjs.com/ , I cannot figure out which one is mine... Would you help, plea… --- ## [Regarding timestamp in Kibana](https://discuss.elastic.co/t/regarding-timestamp-in-kibana/186164)
**Author:** [@kartikcr](https://discuss.elastic.co/u/kartikcr)\ **Replies:** 1\ **Last updated:** [June 27, 2019, 3:41pm UTC](https://discuss.elastic.co/t/regarding-timestamp-in-kibana/186164 "2019-06-27T15:41:24Z")
Currently when I try to plot a pie chart, the timestamp per day comes in mili-seconds format. When I click on it, it shows the date though. I want to show the date itself in the first part. I have tried mapping as… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=647) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=649)