# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=142 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 143 --- ## [Dashboard creation with a query](https://discuss.elastic.co/t/dashboard-creation-with-a-query/326064)
**Author:** [@Haneesha](https://discuss.elastic.co/u/Haneesha)\ **Replies:** 7\ **Last updated:** [February 22, 2023, 3:07pm UTC](https://discuss.elastic.co/t/dashboard-creation-with-a-query/326064 "2023-02-22T15:07:27Z")
Hi Team, Could you please let me know how to create a dashboard using a query. I have a query, i am supposed to create a dashboard. Query: select type\_cd,status\_cd, count(row\_id) from siebel.s\_loy\_txn where TXN\_DT \>=… --- ## [Kibana email alert](https://discuss.elastic.co/t/kibana-email-alert/326147)
**Author:** [@Sharmila\_Natarajan](https://discuss.elastic.co/u/Sharmila_Natarajan)\ **Replies:** 1\ **Last updated:** [February 22, 2023, 1:56pm UTC](https://discuss.elastic.co/t/kibana-email-alert/326147 "2023-02-22T13:56:25Z")
Hi, We are using ELK setup on Kubernetes with a basic license version (8.5.3 - ECK TEMPLATE INSTALLATION), our requirement is to send email alerts based on some logs from the index (eg. if number of test environments ar… --- ## [Cant convert timestamp field from text to date](https://discuss.elastic.co/t/cant-convert-timestamp-field-from-text-to-date/326158)
**Author:** [@Dor\_Steinberg](https://discuss.elastic.co/u/Dor_Steinberg)\ **Replies:** 0\ **Last updated:** [February 22, 2023, 10:36am UTC](https://discuss.elastic.co/t/cant-convert-timestamp-field-from-text-to-date/326158 "2023-02-22T10:36:30Z")
hello everyone, i got problem converting log.timestamp field from text to date someone can help me understand what am i doing wrong? i also will appreciate if do you have an idea of getting the day of the week from th… --- ## [\[ERROR\]\[plugins.alerting\] Executing Alert default:monitoring\_alert\_XXX](https://discuss.elastic.co/t/error-plugins-alerting-executing-alert-default-monitoring-alert-xxx/326140)
**Author:** [@thesn](https://discuss.elastic.co/u/thesn)\ **Replies:** 0\ **Last updated:** [February 22, 2023, 8:52am UTC](https://discuss.elastic.co/t/error-plugins-alerting-executing-alert-default-monitoring-alert-xxx/326140 "2023-02-22T08:52:34Z")
Hi, I have ES and Kibana 7.16.2 running on Docker. When I see the docker logs for Kibana, there are a number of errors related to plugins.alerting: \[2023-02-21T17:07:20.438+07:00\]\[ERROR\]\[plugins.alerting\] Executing Al… --- ## [Infinite extent for field "y1": \[Infinity, -Infinity\]](https://discuss.elastic.co/t/infinite-extent-for-field-y1-infinity-infinity/326137)
**Author:** [@Thearith](https://discuss.elastic.co/u/Thearith)\ **Replies:** 0\ **Last updated:** [February 22, 2023, 7:55am UTC](https://discuss.elastic.co/t/infinite-extent-for-field-y1-infinity-infinity/326137 "2023-02-22T07:55:42Z")
Here is the code that I'm using for create sankey diagram: { $schema: https://vega.github.io/schema/vega/v3.0.json data: \[ { // query ES based on the currently selected time range and filter string name: rawData u… --- ## [Missing "Edit hosts" button under "Fleet server hosts" in Kibana](https://discuss.elastic.co/t/missing-edit-hosts-button-under-fleet-server-hosts-in-kibana/326109)
**Author:** [@Matt\_Johnston](https://discuss.elastic.co/u/Matt_Johnston)\ **Replies:** 2\ **Last updated:** [February 22, 2023, 12:57am UTC](https://discuss.elastic.co/t/missing-edit-hosts-button-under-fleet-server-hosts-in-kibana/326109 "2023-02-22T00:57:00Z")
Hello. I am trying to set up APM for my Elastic Stack by following this tutorial (Quick start | APM User Guide \[8.6\] | Elastic). I am currently on "Step 1: Set up Fleet". The second step of that section says, "Under Fle… --- ## [Kibana error: There are no living connections](https://discuss.elastic.co/t/kibana-error-there-are-no-living-connections/326097)
**Author:** [@bcantrell](https://discuss.elastic.co/u/bcantrell)\ **Replies:** 0\ **Last updated:** [February 21, 2023, 6:55pm UTC](https://discuss.elastic.co/t/kibana-error-there-are-no-living-connections/326097 "2023-02-21T18:55:55Z")
Hello all, All servers are running ELK versions 8.1.3 (I know, upgrade is in the works), on Windows 2016. This error started getting spammed on 2023-02-17 after hours in the kibana log file and I cannot figure out how … --- ## [Financial Year in Controls Visualization Options](https://discuss.elastic.co/t/financial-year-in-controls-visualization-options/324873)
**Author:** [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Replies:** 1\ **Last updated:** [February 21, 2023, 4:01pm UTC](https://discuss.elastic.co/t/financial-year-in-controls-visualization-options/324873 "2023-02-21T16:01:40Z")
Hi all, I'm trying to display control visualization to show reports of a dashboard for 3 financial years ( Apr2021-Mar2022 & so on). But I cannot show this financial year in my controls option? from my date field, I c… --- ## [How to change valueColor to linear-gradient color of progress wheel in kibana canvas?](https://discuss.elastic.co/t/how-to-change-valuecolor-to-linear-gradient-color-of-progress-wheel-in-kibana-canvas/326086)
**Author:** [@RJ\_Chen](https://discuss.elastic.co/u/RJ_Chen)\ **Replies:** 0\ **Last updated:** [February 21, 2023, 3:07pm UTC](https://discuss.elastic.co/t/how-to-change-valuecolor-to-linear-gradient-color-of-progress-wheel-in-kibana-canvas/326086 "2023-02-21T15:07:47Z")
Hi, I want to change progress wheel's valueColor to linear-gradient color , I try to use expression editor and css to change it . but it's not work.... \>\< --- ## [Filter the list of shown in Kibana Dashboard Control](https://discuss.elastic.co/t/filter-the-list-of-shown-in-kibana-dashboard-control/324681)
**Author:** [@DougR](https://discuss.elastic.co/u/DougR)\ **Replies:** 2\ **Last updated:** [February 21, 2023, 2:04pm UTC](https://discuss.elastic.co/t/filter-the-list-of-shown-in-kibana-dashboard-control/324681 "2023-02-21T14:04:18Z")
I am creating a dashboard in Kibana, and I'm using a Control for the first time, rather than an Input Control, as I have in the past. The issue: I'm using a lens that only draws data from a subset of hosts by applying a… --- ## [I have this code, and it is getting information from a database, and I would like this code to be able to see it in a graph. Can one help me?](https://discuss.elastic.co/t/i-have-this-code-and-it-is-getting-information-from-a-database-and-i-would-like-this-code-to-be-able-to-see-it-in-a-graph-can-one-help-me/325503)
**Author:** [@edson](https://discuss.elastic.co/u/edson)\ **Replies:** 7\ **Last updated:** [February 21, 2023, 2:07pm UTC](https://discuss.elastic.co/t/i-have-this-code-and-it-is-getting-information-from-a-database-and-i-would-like-this-code-to-be-able-to-see-it-in-a-graph-can-one-help-me/325503 "2023-02-21T14:07:57Z")
{ "name": "server5", "middleware": \[ { "name": "mq", "version": "9.2", "status": "green" }, { "name": "was", "version": "9", "status": "green" } \] } --- ## [How to display the value in x-axis of a stacked bar only once instead of multiple times?](https://discuss.elastic.co/t/how-to-display-the-value-in-x-axis-of-a-stacked-bar-only-once-instead-of-multiple-times/324434)
**Author:** [@Srikanth\_V](https://discuss.elastic.co/u/Srikanth_V)\ **Replies:** 1\ **Last updated:** [February 21, 2023, 1:54pm UTC](https://discuss.elastic.co/t/how-to-display-the-value-in-x-axis-of-a-stacked-bar-only-once-instead-of-multiple-times/324434 "2023-02-21T13:54:30Z")
Hello, I am currently using a histogram date interval as year and it seems to be appearing multiple times in the x-axis. Is there a way, we can restrict this value to be shown only once? Thanks in advance. --- ## [Unwanted line break of numerical value in tooltip](https://discuss.elastic.co/t/unwanted-line-break-of-numerical-value-in-tooltip/325706)
**Author:** [@Jonas\_S](https://discuss.elastic.co/u/Jonas_S)\ **Replies:** 4\ **Last updated:** [February 21, 2023, 10:57am UTC](https://discuss.elastic.co/t/unwanted-line-break-of-numerical-value-in-tooltip/325706 "2023-02-21T10:57:50Z")
Hello, when adding a break down to visualizations, the tooltip width can be to small, so a line break is made. Which is ok, by itself, but it results in also adding a line break in the numerical value in the end: The… --- ## [How to remove duplication when aggregating data for visualization?](https://discuss.elastic.co/t/how-to-remove-duplication-when-aggregating-data-for-visualization/324407)
**Author:** [@tinrik](https://discuss.elastic.co/u/tinrik)\ **Replies:** 0\ **Last updated:** [February 1, 2023, 10:10am UTC](https://discuss.elastic.co/t/how-to-remove-duplication-when-aggregating-data-for-visualization/324407 "2023-02-01T10:10:12Z")
Hi! Based on answers from other posts, I learned that I need to upload "normalized data" to Kibana, which may come at the cost of sending duplicated data: { file: foo, project: foo, count: 123, id: 1 } { file: foo, pr… --- ## [Embed dashboard and/or kibana anonymous on ElasticCloud](https://discuss.elastic.co/t/embed-dashboard-and-or-kibana-anonymous-on-elasticcloud/324996)
**Author:** [@hagud](https://discuss.elastic.co/u/hagud)\ **Replies:** 0\ **Last updated:** [February 8, 2023, 10:17am UTC](https://discuss.elastic.co/t/embed-dashboard-and-or-kibana-anonymous-on-elasticcloud/324996 "2023-02-08T10:17:02Z")
Good morning We are testing Elastic Cloud and we do not know if it possible or how could be offer public\_url iframe to selected dashboard or graphs. I have seen tha tlocal installation is able to share anonymous iframe… --- ## [CSV export - Please use Kibana feature privileges instead](https://discuss.elastic.co/t/csv-export-please-use-kibana-feature-privileges-instead/325722)
**Author:** [@rschirin](https://discuss.elastic.co/u/rschirin)\ **Replies:** 0\ **Last updated:** [February 16, 2023, 10:44am UTC](https://discuss.elastic.co/t/csv-export-please-use-kibana-feature-privileges-instead/325722 "2023-02-16T10:44:12Z")
Hey there, I saw that reporting\_user role is deprecated so I have to enable the correct privileges using Spaces. I follow this official page Kibana doc, but I am still getting the error "Sorry, you don't have access to… --- ## [Find a pattern within field's value using regular expression Kibana UI](https://discuss.elastic.co/t/find-a-pattern-within-fields-value-using-regular-expression-kibana-ui/324885)
**Author:** [@aklimo](https://discuss.elastic.co/u/aklimo)\ **Replies:** 0\ **Last updated:** [February 7, 2023, 10:28am UTC](https://discuss.elastic.co/t/find-a-pattern-within-fields-value-using-regular-expression-kibana-ui/324885 "2023-02-07T10:28:19Z")
Hello, I am trying to find a pattern within the field using regular expression and it's not working the way I think it should. The field is message.ApiData.ResponseBody and it contains a JSON response. It is a collecti… --- ## [Is it possible to capture all the documents returned by a particular Kibana dashboard?](https://discuss.elastic.co/t/is-it-possible-to-capture-all-the-documents-returned-by-a-particular-kibana-dashboard/325732)
**Author:** [@eeijlar](https://discuss.elastic.co/u/eeijlar)\ **Replies:** 0\ **Last updated:** [February 16, 2023, 12:08pm UTC](https://discuss.elastic.co/t/is-it-possible-to-capture-all-the-documents-returned-by-a-particular-kibana-dashboard/325732 "2023-02-16T12:08:09Z")
I took a Saved Session for a Kibana dashboard, and did inspect on it, which returned this: { "timeRange": { "from": "2023-02-16T09:49:46.292Z", "to": "2023-02-16T10:08:50.981Z" }, "query": { "language"… --- ## [Audio in Canvas](https://discuss.elastic.co/t/audio-in-canvas/326043)
**Author:** [@AdityaKhajuria](https://discuss.elastic.co/u/AdityaKhajuria)\ **Replies:** 1\ **Last updated:** [February 21, 2023, 9:58am UTC](https://discuss.elastic.co/t/audio-in-canvas/326043 "2023-02-21T09:58:11Z")
Hi ELK team, Is there a way i can use and play audio file in Kibana Canvas or Dashboard? If not, is it possible to implement the same by some external plugins or any other way around. Thank you --- ## [Problem with running kibana](https://discuss.elastic.co/t/problem-with-running-kibana/326034)
**Author:** [@reza\_setareh](https://discuss.elastic.co/u/reza_setareh)\ **Replies:** 4\ **Last updated:** [February 21, 2023, 8:54am UTC](https://discuss.elastic.co/t/problem-with-running-kibana/326034 "2023-02-21T08:54:56Z")
hi everybody.i got error when i run kibana.bat this is error below Unable to retrieve version information from Elasticsearch nodes. security\_exception: \[security\_exception\] Reason: missing authentication credentials for… --- ## [Rising trends of data values to latest data in Heatmap visualisation](https://discuss.elastic.co/t/rising-trends-of-data-values-to-latest-data-in-heatmap-visualisation/326031)
**Author:** [@Sahil\_Sharma1](https://discuss.elastic.co/u/Sahil_Sharma1)\ **Replies:** 0\ **Last updated:** [February 21, 2023, 7:42am UTC](https://discuss.elastic.co/t/rising-trends-of-data-values-to-latest-data-in-heatmap-visualisation/326031 "2023-02-21T07:42:39Z")
Hi, We want to show rising trends of data values in selected date range. The logic is that we want to show attributes with consistent growing values sorted in descending order. Kindly suggest how can we achieve the sam… --- ## [Refresh schedule](https://discuss.elastic.co/t/refresh-schedule/325999)
**Author:** [@Apoorva\_Shandilya](https://discuss.elastic.co/u/Apoorva_Shandilya)\ **Replies:** 4\ **Last updated:** [February 21, 2023, 8:44am UTC](https://discuss.elastic.co/t/refresh-schedule/325999 "2023-02-21T08:44:24Z")
Hi all I am beginner here . Can we add information related to refresh schedule in dashboard . I want to see if a dashboard is updated today, I would like to have this date and time as an info in the dashboard it shou… --- ## [Visualization of parts of URL](https://discuss.elastic.co/t/visualization-of-parts-of-url/324769)
**Author:** [@khteh](https://discuss.elastic.co/u/khteh)\ **Replies:** 1\ **Last updated:** [February 20, 2023, 4:09pm UTC](https://discuss.elastic.co/t/visualization-of-parts-of-url/324769 "2023-02-20T16:09:57Z")
I am using ECK. I have created request PATHs visualization in Kibana. One of the URL has the format of /products/product-brand/\. How can I create a visualization on parts of the URL like \? --- ## [Kibana UI Change](https://discuss.elastic.co/t/kibana-ui-change/325938)
**Author:** [@Ajay\_Kotnala](https://discuss.elastic.co/u/Ajay_Kotnala)\ **Replies:** 3\ **Last updated:** [February 20, 2023, 1:00pm UTC](https://discuss.elastic.co/t/kibana-ui-change/325938 "2023-02-20T13:00:54Z")
Is there a way to remove the option toggle dialog with the details option in Kibana UI. Need to rollback to older layout. --- ## [How to Access Field that made by Scripted field](https://discuss.elastic.co/t/how-to-access-field-that-made-by-scripted-field/324610)
**Author:** [@yuswanul](https://discuss.elastic.co/u/yuswanul)\ **Replies:** 0\ **Last updated:** [February 3, 2023, 8:02am UTC](https://discuss.elastic.co/t/how-to-access-field-that-made-by-scripted-field/324610 "2023-02-03T08:02:43Z")
Hi everyone, i've been made scripted field like this: From the script, it generates field named expire\_days with number data type and I have also created an alert that points to this index. The problem is if i wan… --- ## [Details of Elasticserver receiving logs](https://discuss.elastic.co/t/details-of-elasticserver-receiving-logs/325969)
**Author:** [@Kosala\_Randika\_Paran](https://discuss.elastic.co/u/Kosala_Randika_Paran)\ **Replies:** 1\ **Last updated:** [February 20, 2023, 12:45pm UTC](https://discuss.elastic.co/t/details-of-elasticserver-receiving-logs/325969 "2023-02-20T12:45:13Z")
Hi flocks, We have a fresh ELK stack and now I am trying to create a details dashboard for ES receiving logs daily, weekly and monthly, so we do not have much indexes but default ones. since I am new to this subject is … --- ## [Interruptions of Metricbeat Metrics in Kibana](https://discuss.elastic.co/t/interruptions-of-metricbeat-metrics-in-kibana/325580)
**Author:** [@Swathi12](https://discuss.elastic.co/u/Swathi12)\ **Replies:** 0\ **Last updated:** [February 15, 2023, 9:56am UTC](https://discuss.elastic.co/t/interruptions-of-metricbeat-metrics-in-kibana/325580 "2023-02-15T09:56:58Z")
Hi team, i am working for several months on metricbeat in k8s i installed on 3 azure kubernetes cluster metricbeat and i saw it not showing the metrics correctly or with some interruptions each cluster has between 3 … --- ## [Kibana fleet management: failed to decrypt attribute ssl](https://discuss.elastic.co/t/kibana-fleet-management-failed-to-decrypt-attribute-ssl/324881)
**Author:** [@Jesse\_Geens](https://discuss.elastic.co/u/Jesse_Geens)\ **Replies:** 0\ **Last updated:** [February 7, 2023, 10:06am UTC](https://discuss.elastic.co/t/kibana-fleet-management-failed-to-decrypt-attribute-ssl/324881 "2023-02-07T10:06:42Z")
Hello, I am trying to configure my elastic fleet such that elastic agents connect to a logstash instance, secured with SSL. I set up the SSL for logstash, and was now trying to configure the agents. To make sure that th… --- ## [Kibana UI Not Accessible](https://discuss.elastic.co/t/kibana-ui-not-accessible/325904)
**Author:** [@altif](https://discuss.elastic.co/u/altif)\ **Replies:** 2\ **Last updated:** [February 20, 2023, 11:12am UTC](https://discuss.elastic.co/t/kibana-ui-not-accessible/325904 "2023-02-20T11:12:24Z")
Greetings, I'm a Kibana novice who recently imported saved-objects via the Kibana UI. However, upon importing the saved-objects JSON file, I encountered an error as illustrated in the attached screenshot. Whenever I… --- ## [Mapper\_parsing\_exception](https://discuss.elastic.co/t/mapper-parsing-exception/325962)
**Author:** [@Roshan\_M\_Thomas](https://discuss.elastic.co/u/Roshan_M_Thomas)\ **Replies:** 0\ **Last updated:** [February 20, 2023, 11:04am UTC](https://discuss.elastic.co/t/mapper-parsing-exception/325962 "2023-02-20T11:04:53Z")
Hi , getting this error in elastic 7.8.1 and 8.0.0 while inserting mapping using PUT method. Please help us to resolve it. { "error": { "root\_cause": \[ { "type": "mapper\_parsing\_exception", "reason": "Root mapping … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=141) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=143)