# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=374 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 375 --- ## [SQL in Dashboard](https://discuss.elastic.co/t/sql-in-dashboard/261814)
**Author:** [@Treki](https://discuss.elastic.co/u/Treki)\ **Replies:** 2\ **Last updated:** [January 21, 2021, 11:21pm UTC](https://discuss.elastic.co/t/sql-in-dashboard/261814 "2021-01-21T23:21:58Z")
Hello everybody, in Canvas it is possible to use Elasticsearch SQL to generate data tables and metrics. How can I use Elasticsearch SQL in Dashboard to generate the same output as in Canvas? With best regards Treki … --- ## [How does the interaction between classes and objects?](https://discuss.elastic.co/t/how-does-the-interaction-between-classes-and-objects/261842)
**Author:** [@IvanovRoman](https://discuss.elastic.co/u/IvanovRoman)\ **Replies:** 1\ **Last updated:** [January 21, 2021, 7:18pm UTC](https://discuss.elastic.co/t/how-does-the-interaction-between-classes-and-objects/261842 "2021-01-21T19:18:23Z")
What is used di/ioc containers or dependency inversion/ijection in kibana? --- ## [More than 1000 rows in canwas](https://discuss.elastic.co/t/more-than-1000-rows-in-canwas/261415)
**Author:** [@Alexey\_Nikolaev](https://discuss.elastic.co/u/Alexey_Nikolaev)\ **Replies:** 5\ **Last updated:** [January 21, 2021, 6:15pm UTC](https://discuss.elastic.co/t/more-than-1000-rows-in-canwas/261415 "2021-01-21T18:15:20Z")
Try to count call from CISCO CDR. I have QUERY that grouping all call by globalCallID\_callId and I need to COUNT unique globalCallID\_callId - but I have much more records than 1000. My SQL is: SELECT globalCallID\_callI… --- ## [Data from rollup indice is empty in visualisation](https://discuss.elastic.co/t/data-from-rollup-indice-is-empty-in-visualisation/261801)
**Author:** [@toms130](https://discuss.elastic.co/u/toms130)\ **Replies:** 2\ **Last updated:** [January 21, 2021, 5:46pm UTC](https://discuss.elastic.co/t/data-from-rollup-indice-is-empty-in-visualisation/261801 "2021-01-21T17:46:43Z")
Hi there. I've setup 3 rollup jobs, and for1 of them, I can't see nothing in visualization. I've got documents in rollup indice (~30M documents) Below is an example of data { "\_index": "rollup-haproxy", … --- ## [Variable addition](https://discuss.elastic.co/t/variable-addition/261139)
**Author:** [@John\_H](https://discuss.elastic.co/u/John_H)\ **Replies:** 3\ **Last updated:** [January 21, 2021, 2:54pm UTC](https://discuss.elastic.co/t/variable-addition/261139 "2021-01-21T14:54:28Z")
I want to add up a number and show it in a kibana timeline chart. I've got a datastream which has a connect and disconnect entry. I've written a scripted field in kibana index which adds 1 when its connected to and subs… --- ## [Vega: Signal value automatically resets to initial value](https://discuss.elastic.co/t/vega-signal-value-automatically-resets-to-initial-value/261441)
**Author:** [@ege](https://discuss.elastic.co/u/ege)\ **Replies:** 4\ **Last updated:** [January 21, 2021, 3:50pm UTC](https://discuss.elastic.co/t/vega-signal-value-automatically-resets-to-initial-value/261441 "2021-01-21T15:50:56Z")
I am trying to create a toggle button using Vega viz to add/remove a Dashboard filter. Everything works fine except when I toggle it ON, the filter gets added but the toggle button jumps back to the OFF state automatical… --- ## [Change absolute timing in kibana for every 10/15 minutes](https://discuss.elastic.co/t/change-absolute-timing-in-kibana-for-every-10-15-minutes/261767)
**Author:** [@navin1093](https://discuss.elastic.co/u/navin1093)\ **Replies:** 2\ **Last updated:** [January 21, 2021, 3:38pm UTC](https://discuss.elastic.co/t/change-absolute-timing-in-kibana-for-every-10-15-minutes/261767 "2021-01-21T15:38:01Z")
Hi experts, Is there a way to change the time to be for every10 or 15 minutes rather than every 30 minutes in kibana --- ## [Scripted fields to convert seconds to hours](https://discuss.elastic.co/t/scripted-fields-to-convert-seconds-to-hours/261790)
**Author:** [@ykara84](https://discuss.elastic.co/u/ykara84)\ **Replies:** 4\ **Last updated:** [January 21, 2021, 2:04pm UTC](https://discuss.elastic.co/t/scripted-fields-to-convert-seconds-to-hours/261790 "2021-01-21T14:04:20Z")
Cant figure it out, need an additional field that will convert seconds into hours I have a number field called Session-Time which i need converting into hours and displayed in another field. I have tried to create a scr… --- ## [How create watcher for ML anomalies detected](https://discuss.elastic.co/t/how-create-watcher-for-ml-anomalies-detected/261639)
**Author:** [@kurdit](https://discuss.elastic.co/u/kurdit)\ **Replies:** 5\ **Last updated:** [January 21, 2021, 1:54pm UTC](https://discuss.elastic.co/t/how-create-watcher-for-ml-anomalies-detected/261639 "2021-01-21T13:54:54Z")
hi! where can I find documentation on creating and configuring watchdogs for machine learning jobs? --- ## [How to Execute Query to fetch inprogess processes](https://discuss.elastic.co/t/how-to-execute-query-to-fetch-inprogess-processes/261774)
**Author:** [@abhi.coerian](https://discuss.elastic.co/u/abhi.coerian)\ **Replies:** 1\ **Last updated:** [January 21, 2021, 12:26pm UTC](https://discuss.elastic.co/t/how-to-execute-query-to-fetch-inprogess-processes/261774 "2021-01-21T12:26:47Z")
I have log 'analytics', which contains a list of events of process logs ( for eg: CRUD) that occured over a period of time. I am looking to find a set of records that were record added but not deleted from system. docum… --- ## [Conditional scripted field with if else](https://discuss.elastic.co/t/conditional-scripted-field-with-if-else/261646)
**Author:** [@Rakesh\_Rayabarapu](https://discuss.elastic.co/u/Rakesh_Rayabarapu)\ **Replies:** 11\ **Last updated:** [January 21, 2021, 11:20am UTC](https://discuss.elastic.co/t/conditional-scripted-field-with-if-else/261646 "2021-01-21T11:20:55Z")
Hello Team, I am new to this tool, Could you please help me to fix this painless script. I am trying get new scripted field with \[ResTime\] value when \[Region\] is "APJ" else blank. if (doc\['Region'\].value == 'APJ') { … --- ## [How to get the latest index data？If write data regularly every day。](https://discuss.elastic.co/t/how-to-get-the-latest-index-data-if-write-data-regularly-every-day/261386)
**Author:** [@111395](https://discuss.elastic.co/u/111395)\ **Replies:** 8\ **Last updated:** [January 21, 2021, 9:57am UTC](https://discuss.elastic.co/t/how-to-get-the-latest-index-data-if-write-data-regularly-every-day/261386 "2021-01-21T09:57:40Z")
Hi, I have a requirement is save the latest data to the new index from old index。 The old index writes data regularly every day。 In fact, I just want to visualize with the latest data，But I didn't find the right way, … --- ## [Build error when using \`kibanaReact\` and \`kibanaUtils\` in kibana 3rd party plugin](https://discuss.elastic.co/t/build-error-when-using-kibanareact-and-kibanautils-in-kibana-3rd-party-plugin/261748)
**Author:** [@Eric\_wei](https://discuss.elastic.co/u/Eric_wei)\ **Replies:** 8\ **Last updated:** [January 21, 2021, 9:46am UTC](https://discuss.elastic.co/t/build-error-when-using-kibanareact-and-kibanautils-in-kibana-3rd-party-plugin/261748 "2021-01-21T09:46:30Z")
Hello, I'm trying to use kibanaReact and kibanaUtils in my kibana plugin. These 2 plugins added as requiredBundles in the kibana.json, ... "requiredBundles": \["kibanaUtils", "kibanaReact"\] ... But error keep happens … --- ## [Kibana reporting](https://discuss.elastic.co/t/kibana-reporting/261662)
**Author:** [@suibgui](https://discuss.elastic.co/u/suibgui)\ **Replies:** 2\ **Last updated:** [January 21, 2021, 8:56am UTC](https://discuss.elastic.co/t/kibana-reporting/261662 "2021-01-21T08:56:55Z")
Hello Team, haw to solve \[Reporting error Request-URI Too Long\] when genering a pdf report from kibana 7.4.0 ? thanks for help. --- ## [Restrict specific time range](https://discuss.elastic.co/t/restrict-specific-time-range/261496)
**Author:** [@andyet921](https://discuss.elastic.co/u/andyet921)\ **Replies:** 5\ **Last updated:** [January 21, 2021, 8:41am UTC](https://discuss.elastic.co/t/restrict-specific-time-range/261496 "2021-01-21T08:41:10Z")
Hello all, is there any method that I can restrict specific time range? I want to restrict time range from yesterday 12 p.m. to today 12:00 p.m. so that my Kibana dashboard can show the specific time range's data. Thank… --- ## [Tooltip Font-size through CSS - Enhanced Table](https://discuss.elastic.co/t/tooltip-font-size-through-css-enhanced-table/261728)
**Author:** [@sam7](https://discuss.elastic.co/u/sam7)\ **Replies:** 1\ **Last updated:** [January 21, 2021, 6:47am UTC](https://discuss.elastic.co/t/tooltip-font-size-through-css-enhanced-table/261728 "2021-01-21T06:47:53Z")
I am using TVSB markdown to show some images. Used tooltip on the images while hover over it. But, I want to increase the size of fonts-appeared in tool tip using CSS. Any Suggestions? --- ## [Correlation in ELK dashboard](https://discuss.elastic.co/t/correlation-in-elk-dashboard/260160)
**Author:** [@Sivajanani](https://discuss.elastic.co/u/Sivajanani)\ **Replies:** 3\ **Last updated:** [January 21, 2021, 5:37am UTC](https://discuss.elastic.co/t/correlation-in-elk-dashboard/260160 "2021-01-21T05:37:21Z")
Hello All, I have an index with below fields and data set, 1.indicator:13.12.14.15 action:success 2.indicators:13.12.14.15 tags:elk-search 3.indicator:14.4.5.67.84 action:success I have built a das… --- ## [Elasticsearch SQL query](https://discuss.elastic.co/t/elasticsearch-sql-query/261635)
**Author:** [@Sathish22](https://discuss.elastic.co/u/Sathish22)\ **Replies:** 2\ **Last updated:** [January 21, 2021, 3:13am UTC](https://discuss.elastic.co/t/elasticsearch-sql-query/261635 "2021-01-21T03:13:52Z")
Hi, I have three questions Can we push Elasticsearcsh SQL query output to a new index It is possible to use Elasticsearch SQL query in Dashboard/Visualization Is it possible to convert Elasticsearch SQL query to KQL q… --- ## [How can I restore an index pattern and dashboards?](https://discuss.elastic.co/t/how-can-i-restore-an-index-pattern-and-dashboards/261709)
**Author:** [@marcosvrrs](https://discuss.elastic.co/u/marcosvrrs)\ **Replies:** 2\ **Last updated:** [January 21, 2021, 2:33am UTC](https://discuss.elastic.co/t/how-can-i-restore-an-index-pattern-and-dashboards/261709 "2021-01-21T02:33:14Z")
Hi all, I made a mistake and deleted an index pattern that broke 3 dashboards I have. I don't know exactly how to reconstruct the visualizations inside the dashboard, as it was not named correctly, and when I click in t… --- ## [Removing comma from values generated in Enhanced table](https://discuss.elastic.co/t/removing-comma-from-values-generated-in-enhanced-table/261637)
**Author:** [@sam7](https://discuss.elastic.co/u/sam7)\ **Replies:** 4\ **Last updated:** [January 20, 2021, 9:56pm UTC](https://discuss.elastic.co/t/removing-comma-from-values-generated-in-enhanced-table/261637 "2021-01-20T21:56:07Z")
I am using Enhanced table to generate a table showing some values. I want to remove comma generated in the table between values. Example - \["de","ne","us","ni"\] I want to hide comma between values. Is there a way … --- ## [Request Entity Too Large when importing Kibana saved objects](https://discuss.elastic.co/t/request-entity-too-large-when-importing-kibana-saved-objects/261497)
**Author:** [@oskrdt](https://discuss.elastic.co/u/oskrdt)\ **Replies:** 6\ **Last updated:** [January 20, 2021, 9:31pm UTC](https://discuss.elastic.co/t/request-entity-too-large-when-importing-kibana-saved-objects/261497 "2021-01-20T21:31:48Z")
I'm trying to import a ndjson file with size 11.2 MB, but I'm getting the error 413 Request Entity Too Large when trying to do that. I tried increasing the following values on kibana.yml server.maxPayloadBytes: 104857… --- ## [Kibana reporting](https://discuss.elastic.co/t/kibana-reporting/261698)
**Author:** [@Akhil2](https://discuss.elastic.co/u/Akhil2)\ **Replies:** 3\ **Last updated:** [January 20, 2021, 8:22pm UTC](https://discuss.elastic.co/t/kibana-reporting/261698 "2021-01-20T20:22:48Z")
Hello there, I have a few indexes and a lot of data and I need to generate report and graphs for that data. can anyone please tell me how do I do that? Thanks, Akhil --- ## [Remove/hide comma separator between multiple values in a cell of Enhanced Data Table Visualization](https://discuss.elastic.co/t/remove-hide-comma-separator-between-multiple-values-in-a-cell-of-enhanced-data-table-visualization/261561)
**Author:** [@preeti1211](https://discuss.elastic.co/u/preeti1211)\ **Replies:** 2\ **Last updated:** [January 20, 2021, 7:55pm UTC](https://discuss.elastic.co/t/remove-hide-comma-separator-between-multiple-values-in-a-cell-of-enhanced-data-table-visualization/261561 "2021-01-20T19:55:18Z")
Hi Team, i have one usecase which i am able to achieve via Enhanced Data Table Visualization in Kibana. But since we are having multiple values in a single cell, they are coming as comma separated by default. Is there… --- ## [Calculate the percentage based on two calculations - one for future data and another for past data and finally create a bar chart for every team](https://discuss.elastic.co/t/calculate-the-percentage-based-on-two-calculations-one-for-future-data-and-another-for-past-data-and-finally-create-a-bar-chart-for-every-team/261429)
**Author:** [@preeti1211](https://discuss.elastic.co/u/preeti1211)\ **Replies:** 1\ **Last updated:** [January 20, 2021, 7:18pm UTC](https://discuss.elastic.co/t/calculate-the-percentage-based-on-two-calculations-one-for-future-data-and-another-for-past-data-and-finally-create-a-bar-chart-for-every-team/261429 "2021-01-20T19:18:03Z")
Calculation - 95/120 (First value being the number of PBIs approved for future 3 sprints and second value being the number of PBIs completed in the past 3 sprints). If the divided value is =\<33% the bar chart should be … --- ## [Restrict the kibana user for one machine only](https://discuss.elastic.co/t/restrict-the-kibana-user-for-one-machine-only/261568)
**Author:** [@mrunalini](https://discuss.elastic.co/u/mrunalini)\ **Replies:** 1\ **Last updated:** [January 20, 2021, 6:48pm UTC](https://discuss.elastic.co/t/restrict-the-kibana-user-for-one-machine-only/261568 "2021-01-20T18:48:23Z")
HI , My basic requirement here is to restrict any Kibana user for one machine only ,so that same user can not login from different machine at the same time. is there any setting needs to modify in kibana.yml file or an… --- ## [Generate a pdf report from kibana](https://discuss.elastic.co/t/generate-a-pdf-report-from-kibana/261654)
**Author:** [@suibgui](https://discuss.elastic.co/u/suibgui)\ **Replies:** 1\ **Last updated:** [January 20, 2021, 6:47pm UTC](https://discuss.elastic.co/t/generate-a-pdf-report-from-kibana/261654 "2021-01-20T18:47:24Z")
Hello Team, when i want to genarate a pdf report from Kibana ,I have this issue message: {"type":"error","@timestamp":"2021-01-18T14:43:54Z","tags":\["reporting","printable\_pdf","execute","kk2oi8v30bb44cba349ldzfe","err… --- ## [How to configure kibana docker to redirect kibana logs to syslog](https://discuss.elastic.co/t/how-to-configure-kibana-docker-to-redirect-kibana-logs-to-syslog/260499)
**Author:** [@akshatsharma](https://discuss.elastic.co/u/akshatsharma)\ **Replies:** 3\ **Last updated:** [January 20, 2021, 4:11pm UTC](https://discuss.elastic.co/t/how-to-configure-kibana-docker-to-redirect-kibana-logs-to-syslog/260499 "2021-01-20T16:11:16Z")
Hi, Currently, Kibana generates logs as plain text and outputs them to stdout. For our use-case, we need to reformat kibana logs in a different format, for which we need to send Kibana's container logs to Syslog sidecar… --- ## [Security when using Selenium RemoteWebdriver with Kibana](https://discuss.elastic.co/t/security-when-using-selenium-remotewebdriver-with-kibana/260418)
**Author:** [@NicklausKew](https://discuss.elastic.co/u/NicklausKew)\ **Replies:** 3\ **Last updated:** [January 20, 2021, 3:29pm UTC](https://discuss.elastic.co/t/security-when-using-selenium-remotewebdriver-with-kibana/260418 "2021-01-20T15:29:38Z")
Morning all, I am having some issues with how selenium is interacting with Kibana. For the body of work completed I was running on version 7.6.1 of Kibana with all of my automated tests passing on both the Selenium Chro… --- ## [Add users in Kibana with basic license using 7.10.1](https://discuss.elastic.co/t/add-users-in-kibana-with-basic-license-using-7-10-1/261535)
**Author:** [@Richie](https://discuss.elastic.co/u/Richie)\ **Replies:** 15\ **Last updated:** [January 20, 2021, 3:24pm UTC](https://discuss.elastic.co/t/add-users-in-kibana-with-basic-license-using-7-10-1/261535 "2021-01-20T15:24:49Z")
Hi, I recently upgraded my ELK stack from 6.6 to 7.10. I wanted to use the role management feature to allow users to only view dashboards specific to them which would be secured via authentication. I tried this function… --- ## [How to take filter and selected timeframe from Visualize to Logs view?](https://discuss.elastic.co/t/how-to-take-filter-and-selected-timeframe-from-visualize-to-logs-view/259460)
**Author:** [@bluepuma77](https://discuss.elastic.co/u/bluepuma77)\ **Replies:** 6\ **Last updated:** [January 20, 2021, 11:22am UTC](https://discuss.elastic.co/t/how-to-take-filter-and-selected-timeframe-from-visualize-to-logs-view/259460 "2021-01-20T11:22:22Z")
Hi all, I have identified an anomaly (strange user behavior) in my logs with Visualize in Kibana. How can I now switch to log view to see the same matching log entries and details? Take the filter and selected timefra… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=373) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=375)