# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=200 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 201 --- ## [Add New field by Comparing Date](https://discuss.elastic.co/t/add-new-field-by-comparing-date/307895)
**Author:** [@RahulWagh](https://discuss.elastic.co/u/RahulWagh)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 12:06pm UTC](https://discuss.elastic.co/t/add-new-field-by-comparing-date/307895 "2022-06-29T12:06:27Z")
Hi, I am using Kibana v7.17 where I am trying to create new calculated field by comparing the date present in the existing field with hardcoded date. For e.g. if(doc\['trans\_date'\].value \>= "2021-02-15" {emit("FY 2021"} … --- ## [How to show data on cell when move pointer to this cell](https://discuss.elastic.co/t/how-to-show-data-on-cell-when-move-pointer-to-this-cell/308091)
**Author:** [@vuhai\_fo4](https://discuss.elastic.co/u/vuhai_fo4)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 10:21am UTC](https://discuss.elastic.co/t/how-to-show-data-on-cell-when-move-pointer-to-this-cell/308091 "2022-06-29T10:21:04Z")
Hi all, I have an issue with cells on my dashboard. I can't resize column because data on them is so long. Now, I want to view data on cell by move pointer to this cell. It same hint or suggest click about data of this c… --- ## [Kibana maps - add DSL Filter](https://discuss.elastic.co/t/kibana-maps-add-dsl-filter/308267)
**Author:** [@Yair\_Gofen](https://discuss.elastic.co/u/Yair_Gofen)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 10:03am UTC](https://discuss.elastic.co/t/kibana-maps-add-dsl-filter/308267 "2022-06-29T10:03:41Z")
Hi, I want to add filter to a layer on my map to reduce number of returned documents. however, i can only add a filter in KQL format and not DSL format. my filter uses painless script, and i don't know how to do that … --- ## [Filter data in interval or based on a specific field](https://discuss.elastic.co/t/filter-data-in-interval-or-based-on-a-specific-field/308351)
**Author:** [@Alice\_Ionescu](https://discuss.elastic.co/u/Alice_Ionescu)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 9:02am UTC](https://discuss.elastic.co/t/filter-data-in-interval-or-based-on-a-specific-field/308351 "2022-06-29T09:02:35Z")
Hello, I would like to filter data based on an interval or based on a specific field. For example I have a filter for begin date, one for end date and one for a specific date Begin date filter looks like this I … --- ## [Elastic Agent, System Integration, Processors](https://discuss.elastic.co/t/elastic-agent-system-integration-processors/308236)
**Author:** [@fran\_hernandez](https://discuss.elastic.co/u/fran_hernandez)\ **Replies:** 8\ **Last updated:** [June 29, 2022, 8:49am UTC](https://discuss.elastic.co/t/elastic-agent-system-integration-processors/308236 "2022-06-29T08:49:30Z")
Hello, I am trying to get the hostname of a given IP in a field (source.ip), I am doing this for an agent deployed within a system integration, I have defined some processors in the "processors" field some drop\_event. B… --- ## [Return first/last/mid characters of a keyword field](https://discuss.elastic.co/t/return-first-last-mid-characters-of-a-keyword-field/306372)
**Author:** [@behappy\_alwayz0401](https://discuss.elastic.co/u/behappy_alwayz0401)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 5:24am UTC](https://discuss.elastic.co/t/return-first-last-mid-characters-of-a-keyword-field/306372 "2022-06-29T05:24:46Z")
I have a field account name that has string values with spaces. I would like to return the first 5 and last 4 characters of each value in this field in a runtime painless field. how can this be done? thanks --- ## [Configuring kibana and elasticsearsh in HTTPS](https://discuss.elastic.co/t/configuring-kibana-and-elasticsearsh-in-https/308340)
**Author:** [@Firas\_Bougrine](https://discuss.elastic.co/u/Firas_Bougrine)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:52pm UTC](https://discuss.elastic.co/t/configuring-kibana-and-elasticsearsh-in-https/308340 "2022-06-28T23:52:21Z")
how to configuring kibana and elasticsearsh in HTTPS and access to the interface of kibana with https ?? thanks . --- ## [Logs from Elastic itself](https://discuss.elastic.co/t/logs-from-elastic-itself/308383)
**Author:** [@eliumoraes](https://discuss.elastic.co/u/eliumoraes)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:39pm UTC](https://discuss.elastic.co/t/logs-from-elastic-itself/308383 "2022-06-28T23:39:21Z")
Hello, I'm trying to find how to get the logs from elastic itself. I am using elastic cloud (with azure) and would like to see events such as reboots or system events, out of memory, green-to-yellow status, creation and… --- ## [All Log login activity Kibana](https://discuss.elastic.co/t/all-log-login-activity-kibana/308389)
**Author:** [@renato473](https://discuss.elastic.co/u/renato473)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:36pm UTC](https://discuss.elastic.co/t/all-log-login-activity-kibana/308389 "2022-06-28T23:36:01Z")
Hello, I would like to know how do I have access logs to kibana of activities performed by users. my cluster is in the cloud and when trying to use the xpack.security.audit.enabled option return the following error. "… --- ## [Need help creating a status panel using Heartbeat data](https://discuss.elastic.co/t/need-help-creating-a-status-panel-using-heartbeat-data/306170)
**Author:** [@paolovalladolid](https://discuss.elastic.co/u/paolovalladolid)\ **Replies:** 6\ **Last updated:** [June 28, 2022, 6:51pm UTC](https://discuss.elastic.co/t/need-help-creating-a-status-panel-using-heartbeat-data/306170 "2022-06-28T18:51:32Z")
I am trying to partially recreate the example dashboard shown here: In particular, I want to create a panel that uses a table, and I want the first column to be an up/down status column. This is the desired look: W… --- ## [Why i can't to access to the interface of kibana?](https://discuss.elastic.co/t/why-i-cant-to-access-to-the-interface-of-kibana/308195)
**Author:** [@Firas\_Bougrine](https://discuss.elastic.co/u/Firas_Bougrine)\ **Replies:** 13\ **Last updated:** [June 28, 2022, 6:35pm UTC](https://discuss.elastic.co/t/why-i-cant-to-access-to-the-interface-of-kibana/308195 "2022-06-28T18:35:04Z")
i already installed elastic and kibana 8.2 in ubuntu 22.04 and i try to access kibana from the browser of my host it told me "Kibana server is not ready yet" this my elastic and kibana yml files : network.host: 192.16… --- ## [Select data in the dashboard to exclude from the overall average and plot on other line](https://discuss.elastic.co/t/select-data-in-the-dashboard-to-exclude-from-the-overall-average-and-plot-on-other-line/308116)
**Author:** [@adrian93](https://discuss.elastic.co/u/adrian93)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 3:59pm UTC](https://discuss.elastic.co/t/select-data-in-the-dashboard-to-exclude-from-the-overall-average-and-plot-on-other-line/308116 "2022-06-28T15:59:42Z")
Hello everyone, I am working with kibana version 7.17. I am working on a project that shows the humidity of 5 sensors throughout the day. In elasticsearch is stored the humidity data, the identifier of the sensor that … --- ## [Display scripted field in Kibana 7.10 reporting](https://discuss.elastic.co/t/display-scripted-field-in-kibana-7-10-reporting/307001)
**Author:** [@Cap\_Ho](https://discuss.elastic.co/u/Cap_Ho)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 3:13pm UTC](https://discuss.elastic.co/t/display-scripted-field-in-kibana-7-10-reporting/307001 "2022-06-28T15:13:49Z")
Hi all, I have a requirement that i need to create a report based on Kibana discover. (in csv format). But in this report i need to add scripted field inside. As i know scripted field cannot use in reporting and they wi… --- ## [Format column](https://discuss.elastic.co/t/format-column/307952)
**Author:** [@eddieyee](https://discuss.elastic.co/u/eddieyee)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 2:54pm UTC](https://discuss.elastic.co/t/format-column/307952 "2022-06-28T14:54:08Z")
Hi, I have an aggregation table visual with a column in millisecs, is there a way to format to show it in hours : mins : secs : ms ? --- ## [% of row for table visualizations](https://discuss.elastic.co/t/of-row-for-table-visualizations/308137)
**Author:** [@Lagger\_Justin\_Lagtap](https://discuss.elastic.co/u/Lagger_Justin_Lagtap)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 1:57pm UTC](https://discuss.elastic.co/t/of-row-for-table-visualizations/308137 "2022-06-28T13:57:52Z")
I'm a complete Kibana noob and I'm trying to replicate what I'd normally do in Excel pivot tables. In excel, I'd have a pivot table and I would choose % of row/% of column to show how much that particular record contrib… --- ## [Kibana 8.2.0 Filter event\_data.TargetUserName ending with $ (service accounts etc)](https://discuss.elastic.co/t/kibana-8-2-0-filter-event-data-targetusername-ending-with-service-accounts-etc/306471)
**Author:** [@mcn1k](https://discuss.elastic.co/u/mcn1k)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 1:52pm UTC](https://discuss.elastic.co/t/kibana-8-2-0-filter-event-data-targetusername-ending-with-service-accounts-etc/306471 "2022-06-28T13:52:09Z")
Good day guys, Opening this post after search for an hour without finding any response that actually works for my case. I am trying to build detection rules based on windows security event id 4662 and I need to exclude… --- ## [Get current Kibana settings](https://discuss.elastic.co/t/get-current-kibana-settings/307775)
**Author:** [@ben-sec](https://discuss.elastic.co/u/ben-sec)\ **Replies:** 5\ **Last updated:** [June 28, 2022, 12:37pm UTC](https://discuss.elastic.co/t/get-current-kibana-settings/307775 "2022-06-28T12:37:00Z")
Hello! How can I get the current Kibana (v7.17.4) settings (like elasticsearch.requestTimeout and elasticsearch.shardTimeout) to verify if my settings in kibana.yml are actually working? Thanks in advance! Cheers, Ben --- ## [App state disappeared in dashboard url](https://discuss.elastic.co/t/app-state-disappeared-in-dashboard-url/308337)
**Author:** [@Osysh](https://discuss.elastic.co/u/Osysh)\ **Replies:** 4\ **Last updated:** [June 28, 2022, 12:19pm UTC](https://discuss.elastic.co/t/app-state-disappeared-in-dashboard-url/308337 "2022-06-28T12:19:00Z")
Hi, I've noticed that a dashboard url doesn't contains the app state \_a() anymore in web browsers. However it appears in the link in the snapshots. Is it a normal behavior ? Thanks --- ## [Reviewing Logs in Kabana](https://discuss.elastic.co/t/reviewing-logs-in-kabana/306468)
**Author:** [@ctissot941](https://discuss.elastic.co/u/ctissot941)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:40am UTC](https://discuss.elastic.co/t/reviewing-logs-in-kabana/306468 "2022-06-28T11:40:53Z")
Hello, I'm currently reviewing event logs in Kibana as part of SOF ELK. I have over 400,000 logs to search though, I can only see a maximum of 500 at a time to search through. How do I configure Kibana to allow me to s… --- ## [Space before and after a word](https://discuss.elastic.co/t/space-before-and-after-a-word/308345)
**Author:** [@Mrwan\_Mohsen](https://discuss.elastic.co/u/Mrwan_Mohsen)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:35am UTC](https://discuss.elastic.co/t/space-before-and-after-a-word/308345 "2022-06-28T11:35:19Z")
I'm beginner at kibana and i want to search about some word this word must before it space and after it space how can i do it???! --- ## [Separate control filters for each report in a dashboard](https://discuss.elastic.co/t/separate-control-filters-for-each-report-in-a-dashboard/308335)
**Author:** [@behappy\_alwayz0401](https://discuss.elastic.co/u/behappy_alwayz0401)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:33am UTC](https://discuss.elastic.co/t/separate-control-filters-for-each-report-in-a-dashboard/308335 "2022-06-28T11:33:59Z")
Hi, In a dashboard, I have 3 different visualizations and I have a global set of Controls specified at a Dashboard level. Apart from these controls, is it possible to have separate controls displaying for each of the re… --- ## [How to calculate a percentage value on column](https://discuss.elastic.co/t/how-to-calculate-a-percentage-value-on-column/306765)
**Author:** [@Ely\_96](https://discuss.elastic.co/u/Ely_96)\ **Replies:** 2\ **Last updated:** [June 28, 2022, 11:33am UTC](https://discuss.elastic.co/t/how-to-calculate-a-percentage-value-on-column/306765 "2022-06-28T11:33:27Z")
Hi all, I need an help in order to calculate a percentage value inside a column. I'm using Kibana 7.16.2 and I have a table with Lens: 1st column: item name ("Alpha", "Beta", "Gamma"....) from 2nd column to N column … --- ## [How to manually add values in dropdown control](https://discuss.elastic.co/t/how-to-manually-add-values-in-dropdown-control/307742)
**Author:** [@RahulWagh](https://discuss.elastic.co/u/RahulWagh)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 11:03am UTC](https://discuss.elastic.co/t/how-to-manually-add-values-in-dropdown-control/307742 "2022-06-28T11:03:24Z")
I am populating field values in control filter but actually on the dashboard for this control filter I want to show specific values not all. I am using Kibana v7.17 --- ## [Painless script for inventory of previous week](https://discuss.elastic.co/t/painless-script-for-inventory-of-previous-week/308209)
**Author:** [@behappy\_alwayz0401](https://discuss.elastic.co/u/behappy_alwayz0401)\ **Replies:** 9\ **Last updated:** [June 28, 2022, 8:01am UTC](https://discuss.elastic.co/t/painless-script-for-inventory-of-previous-week/308209 "2022-06-28T08:01:05Z")
Hi, I want to fetch the inventory value of the previous week. Is there a way to write a painless script for this? thanks.. --- ## [Exponential result in kibana metric visualization when expecting zero](https://discuss.elastic.co/t/exponential-result-in-kibana-metric-visualization-when-expecting-zero/306302)
**Author:** [@Irene](https://discuss.elastic.co/u/Irene)\ **Replies:** 4\ **Last updated:** [June 28, 2022, 7:41am UTC](https://discuss.elastic.co/t/exponential-result-in-kibana-metric-visualization-when-expecting-zero/306302 "2022-06-28T07:41:36Z")
Hello, I am creating some Dashboards in Kibana version 6.8 to compare data from two different environments, depending on the field "tecnologia". In the dashboard I use metric visualizations to count the number of docume… --- ## [Aggregation with double nested arrays](https://discuss.elastic.co/t/aggregation-with-double-nested-arrays/307976)
**Author:** [@mo-ezzat](https://discuss.elastic.co/u/mo-ezzat)\ **Replies:** 6\ **Last updated:** [June 28, 2022, 7:24am UTC](https://discuss.elastic.co/t/aggregation-with-double-nested-arrays/307976 "2022-06-28T07:24:35Z")
Hello, I'm pretty new to the aggregations but I believe this is a bit complicated I've the following set of data "grossWeight" : 6.43, "netWeight" : 6.89, "previouid" : "", "itemData" : \[ … --- ## [How to control he log flow in ELK](https://discuss.elastic.co/t/how-to-control-he-log-flow-in-elk/308322)
**Author:** [@yasar](https://discuss.elastic.co/u/yasar)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 6:28am UTC](https://discuss.elastic.co/t/how-to-control-he-log-flow-in-elk/308322 "2022-06-28T06:28:02Z")
Hello team, We would like to know about, how to control the log flow in kibana? The Elasticsearch cluster are experiencing huge ingestion rate while the (Performance test) PT happens at application end so that, we are … --- ## [Need to control the log flows in kibana](https://discuss.elastic.co/t/need-to-control-the-log-flows-in-kibana/308213)
**Author:** [@yasar](https://discuss.elastic.co/u/yasar)\ **Replies:** 3\ **Last updated:** [June 28, 2022, 6:09am UTC](https://discuss.elastic.co/t/need-to-control-the-log-flows-in-kibana/308213 "2022-06-28T06:09:36Z")
Hello team, We would like to know about, how to control the log flow in kibana? The Elasticsearch cluster are experiencing huge ingestion rate while the (Performance test) PT happens at application end so that, we are … --- ## [Kibana server is not ready yet](https://discuss.elastic.co/t/kibana-server-is-not-ready-yet/308174)
**Author:** [@Badr\_Atouhlaten](https://discuss.elastic.co/u/Badr_Atouhlaten)\ **Replies:** 13\ **Last updated:** [June 28, 2022, 4:25am UTC](https://discuss.elastic.co/t/kibana-server-is-not-ready-yet/308174 "2022-06-28T04:25:50Z")
i am getting \[Kibana server is not ready yet\] after reboot server Started Kibana. : \[2022-06-14T11:08:40.458+00:00\]\[INFO \]\[plugins-service\] Plugin "cloudSecurityPosture" is disabled. : \[2022-06-14T11:08:40.498+00:00\]\[… --- ## [Bucket Aggregate not working in newer versions](https://discuss.elastic.co/t/bucket-aggregate-not-working-in-newer-versions/307591)
**Author:** [@Ankita\_Pachauri](https://discuss.elastic.co/u/Ankita_Pachauri)\ **Replies:** 3\ **Last updated:** [June 28, 2022, 2:39am UTC](https://discuss.elastic.co/t/bucket-aggregate-not-working-in-newer-versions/307591 "2022-06-28T02:39:46Z")
Hi team, Previously I had a visualisation for top 10 VMS showing the cou usage of the infrastructure. The concept behind the visualisation was: The data was collected from metricbeat Average of system.cpu.user.pct, sy… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=199) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=201)