# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=347 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 348 --- ## [User system Kibana](https://discuss.elastic.co/t/user-system-kibana/268747)
**Author:** [@alipujaistopo](https://discuss.elastic.co/u/alipujaistopo)\ **Replies:** 1\ **Last updated:** [March 31, 2021, 1:16am UTC](https://discuss.elastic.co/t/user-system-kibana/268747 "2021-03-31T01:16:48Z")
Is it the system in Kibana that runs the service has a system user: kibana? --- ## [Track user logged into Kibana and track their activities](https://discuss.elastic.co/t/track-user-logged-into-kibana-and-track-their-activities/268779)
**Author:** [@rohitarorait82](https://discuss.elastic.co/u/rohitarorait82)\ **Replies:** 1\ **Last updated:** [March 31, 2021, 1:14am UTC](https://discuss.elastic.co/t/track-user-logged-into-kibana-and-track-their-activities/268779 "2021-03-31T01:14:28Z")
Hi All, For the monitoring purpose, we need to do the analysis on below two points in Kibana Which all users logged in to Kibana What all activities they performed/which all query they executed. Can somebody please h… --- ## [How to add hostname value in email subject or body](https://discuss.elastic.co/t/how-to-add-hostname-value-in-email-subject-or-body/268820)
**Author:** [@AnamikaN](https://discuss.elastic.co/u/AnamikaN)\ **Replies:** 1\ **Last updated:** [March 30, 2021, 10:21pm UTC](https://discuss.elastic.co/t/how-to-add-hostname-value-in-email-subject-or-body/268820 "2021-03-30T22:21:40Z")
Hi, I would like to add 'hostname' in email subject or body whenever i get 'Failed authentication error' in log messages. I have created an index and it has data for 3 servers. So whenever we see auth error in logs, i w… --- ## [Kibana showing different Packetbeat data](https://discuss.elastic.co/t/kibana-showing-different-packetbeat-data/268834)
**Author:** [@Claudio\_Ract\_Costa](https://discuss.elastic.co/u/Claudio_Ract_Costa)\ **Replies:** 3\ **Last updated:** [March 30, 2021, 8:16pm UTC](https://discuss.elastic.co/t/kibana-showing-different-packetbeat-data/268834 "2021-03-30T20:16:50Z")
Hi Guys, I have two version of Elasticsearch x Kibana (Version 7.6 and version 7.12) When i am analysing data in Kibana, using Discover, the information is showed in different ways for each ES/Kibana version. Example: … --- ## [Kibana Alert API not handling float value correcly](https://discuss.elastic.co/t/kibana-alert-api-not-handling-float-value-correcly/268141)
**Author:** [@leela\_kumili](https://discuss.elastic.co/u/leela_kumili)\ **Replies:** 3\ **Last updated:** [March 30, 2021, 7:19pm UTC](https://discuss.elastic.co/t/kibana-alert-api-not-handling-float-value-correcly/268141 "2021-03-30T19:19:44Z")
I have created a monitor in Kibana using ES query Blockquote { "size": 0, "aggregations": { "byType": { "terms": { "field": "type.keyword", "size": 10, "min\_doc\_count": 1, "shard\_min\_doc\_count": 0, "show\_term… --- ## [Username and password do not work on a shared dashboard](https://discuss.elastic.co/t/username-and-password-do-not-work-on-a-shared-dashboard/268832)
**Author:** [@AlfredoC](https://discuss.elastic.co/u/AlfredoC)\ **Replies:** 1\ **Last updated:** [March 30, 2021, 6:26pm UTC](https://discuss.elastic.co/t/username-and-password-do-not-work-on-a-shared-dashboard/268832 "2021-03-30T18:26:30Z")
I am sharing a dashboard on a web page. To be able to see the dashboard, it asks me for username and password; I enter them, but it does not allow me to see the dashboard, it asks me again for username and password, and … --- ## [Is there a way to parse country names to Geospatial Coordinates?](https://discuss.elastic.co/t/is-there-a-way-to-parse-country-names-to-geospatial-coordinates/268716)
**Author:** [@caitlyn.carlisle](https://discuss.elastic.co/u/caitlyn.carlisle)\ **Replies:** 4\ **Last updated:** [March 30, 2021, 6:12pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-parse-country-names-to-geospatial-coordinates/268716 "2021-03-30T18:12:23Z")
I am attempting to create a map using Kibana. I currently only have the country name as one of my data points but was wondering if there was a way to easily convert it to the Geospatial Coordinates? I am using a Logstash… --- ## [I need help with the filter](https://discuss.elastic.co/t/i-need-help-with-the-filter/268822)
**Author:** [@Eduardo\_Bubniak](https://discuss.elastic.co/u/Eduardo_Bubniak)\ **Replies:** 1\ **Last updated:** [March 30, 2021, 5:48pm UTC](https://discuss.elastic.co/t/i-need-help-with-the-filter/268822 "2021-03-30T17:48:44Z")
I intend to build a dashboard showing only untreated errors that occur in the api, I am using error.exception.type to identify the types of errors, but I only need to track errors that do not have the keyword "company na… --- ## [Count elements in JSON payload](https://discuss.elastic.co/t/count-elements-in-json-payload/268325)
**Author:** [@cjeanne](https://discuss.elastic.co/u/cjeanne)\ **Replies:** 3\ **Last updated:** [March 30, 2021, 5:26pm UTC](https://discuss.elastic.co/t/count-elements-in-json-payload/268325 "2021-03-30T17:26:42Z")
Hello, I'm trying to detect index on read-only with a watcher. I use http input, and I juste want to count the result. My json watcher : { "trigger": { "schedule": { "interval": "10m" } }, "input":… --- ## [Could not able to create index-pattern in 7.12.0](https://discuss.elastic.co/t/could-not-able-to-create-index-pattern-in-7-12-0/268812)
**Author:** [@sasvmware](https://discuss.elastic.co/u/sasvmware)\ **Replies:** 2\ **Last updated:** [March 30, 2021, 3:43pm UTC](https://discuss.elastic.co/t/could-not-able-to-create-index-pattern-in-7-12-0/268812 "2021-03-30T15:43:11Z")
Index pattern is not getting saved in kibana in 7.12.0 --- ## [Visualizing Prometheus Histogram](https://discuss.elastic.co/t/visualizing-prometheus-histogram/268668)
**Author:** [@waczi](https://discuss.elastic.co/u/waczi)\ **Replies:** 5\ **Last updated:** [March 30, 2021, 2:40pm UTC](https://discuss.elastic.co/t/visualizing-prometheus-histogram/268668 "2021-03-30T14:40:19Z")
Hi, which type of aggregation should I use for the Prometheus Histogram Metrics generated like shown below. I would like to sum count and values arrays, for given time period, and then based on that create histogram… --- ## [How to limit the size of horizontal bar in Kibana Canvas data table](https://discuss.elastic.co/t/how-to-limit-the-size-of-horizontal-bar-in-kibana-canvas-data-table/268710)
**Author:** [@tangkalo](https://discuss.elastic.co/u/tangkalo)\ **Replies:** 2\ **Last updated:** [March 30, 2021, 2:24pm UTC](https://discuss.elastic.co/t/how-to-limit-the-size-of-horizontal-bar-in-kibana-canvas-data-table/268710 "2021-03-30T14:24:41Z")
Hi, I have a data table that is very wide and the header column titles are long. Is there a way I can limit the size of scroll bar and also wrap the words in each of the column header so that they fit into the fixed-size… --- ## [Elasticsearch Kibana user authentication](https://discuss.elastic.co/t/elasticsearch-kibana-user-authentication/268712)
**Author:** [@twilight](https://discuss.elastic.co/u/twilight)\ **Replies:** 3\ **Last updated:** [March 30, 2021, 2:10pm UTC](https://discuss.elastic.co/t/elasticsearch-kibana-user-authentication/268712 "2021-03-30T14:10:29Z")
Hello, I have installed ES and Kibana 7.12 on an Amazon Linux AMI using the rpm packages. But I cannot see any user authentication settings in either of the config files. I have installed metricbeat on some other serv… --- ## [SUM for colum1 and filter](https://discuss.elastic.co/t/sum-for-colum1-and-filter/268110)
**Author:** [@EduardoM](https://discuss.elastic.co/u/EduardoM)\ **Replies:** 9\ **Last updated:** [March 30, 2021, 1:07pm UTC](https://discuss.elastic.co/t/sum-for-colum1-and-filter/268110 "2021-03-30T13:07:03Z")
I am trying to do the following: Select Sum (durationprev) from ptx\*-… where location = abc0011 and status = auto as running AVAL= running / total. filters | essql query="SELECT SUM(duration) AS running FROM \\"dat… --- ## [Want to set 'measurement.name' as a filter](https://discuss.elastic.co/t/want-to-set-measurement-name-as-a-filter/268738)
**Author:** [@Jungeun](https://discuss.elastic.co/u/Jungeun)\ **Replies:** 2\ **Last updated:** [March 30, 2021, 12:52pm UTC](https://discuss.elastic.co/t/want-to-set-measurement-name-as-a-filter/268738 "2021-03-30T12:52:18Z")
If you look at the picture attached, I'm trying to visualize the value of "measurement.value" according to "measurement.name" with "up.version". However, I cannot get the value based on the "measurement.name’ from the Y… --- ## [Can we display TSVB Gauge in default color without any documents/value being populated](https://discuss.elastic.co/t/can-we-display-tsvb-gauge-in-default-color-without-any-documents-value-being-populated/268731)
**Author:** [@Shaiju\_Sam](https://discuss.elastic.co/u/Shaiju_Sam)\ **Replies:** 2\ **Last updated:** [March 30, 2021, 11:19am UTC](https://discuss.elastic.co/t/can-we-display-tsvb-gauge-in-default-color-without-any-documents-value-being-populated/268731 "2021-03-30T11:19:01Z")
Hi, We have created multiple TSVB gauge graph to show the health of the infrastructure using the filter ratio aggregation however few gauges are displaying in green with 0%(document being generated in ES) and few gauges… --- ## [Week of the year / sunday of the week](https://discuss.elastic.co/t/week-of-the-year-sunday-of-the-week/267529)
**Author:** [@lachlann562](https://discuss.elastic.co/u/lachlann562)\ **Replies:** 1\ **Last updated:** [March 30, 2021, 9:58am UTC](https://discuss.elastic.co/t/week-of-the-year-sunday-of-the-week/267529 "2021-03-30T09:58:53Z")
Week of the year is challenging when handling year rolling, etc. a previous article was: Week of the year aggregations using Painless - Elastic Stack / Elasticsearch - Discuss the Elastic Stack I found a simple solutio… --- ## [Generating a CSV file from curl with Kibana, results in just 'Processing' in the output csv file](https://discuss.elastic.co/t/generating-a-csv-file-from-curl-with-kibana-results-in-just-processing-in-the-output-csv-file/268374)
**Author:** [@eeijlar](https://discuss.elastic.co/u/eeijlar)\ **Replies:** 3\ **Last updated:** [March 30, 2021, 8:02am UTC](https://discuss.elastic.co/t/generating-a-csv-file-from-curl-with-kibana-results-in-just-processing-in-the-output-csv-file/268374 "2021-03-30T08:02:00Z")
I am using the following shell snipped to download csvs for a a series of queries that I have collected up in Kibana: for filename in ${KIBANA\_QUERIES}/\*.rison; do echo "Processing que… --- ## [\[SMTP-Alert Settings\] using hosts file static IP instead of DNS lookup](https://discuss.elastic.co/t/smtp-alert-settings-using-hosts-file-static-ip-instead-of-dns-lookup/267909)
**Author:** [@Ahmed\_Abdulaleem](https://discuss.elastic.co/u/Ahmed_Abdulaleem)\ **Replies:** 2\ **Last updated:** [March 30, 2021, 7:55am UTC](https://discuss.elastic.co/t/smtp-alert-settings-using-hosts-file-static-ip-instead-of-dns-lookup/267909 "2021-03-30T07:55:24Z")
In Alert scenario How to force KIaban to use hosts file instead of DNS Lookup to define SMTP server. --- ## [Scripted field to calculate a machine score](https://discuss.elastic.co/t/scripted-field-to-calculate-a-machine-score/268657)
**Author:** [@ITchandj](https://discuss.elastic.co/u/ITchandj)\ **Replies:** 5\ **Last updated:** [March 30, 2021, 7:37am UTC](https://discuss.elastic.co/t/scripted-field-to-calculate-a-machine-score/268657 "2021-03-30T07:37:18Z")
Hallo !!! i want to write a scripted field that can calculate a machine score in kibana.. Please any idea how i can resolve it. Thank you in advance. --- ## [Vega Kibana Maps Offline Implementation](https://discuss.elastic.co/t/vega-kibana-maps-offline-implementation/268680)
**Author:** [@gerardo\_dutan](https://discuss.elastic.co/u/gerardo_dutan)\ **Replies:** 2\ **Last updated:** [March 30, 2021, 2:45am UTC](https://discuss.elastic.co/t/vega-kibana-maps-offline-implementation/268680 "2021-03-30T02:45:28Z")
I've noticed that the implementation of Vega maps have changed in the latest version of kibana, 12.0. I submitted an issue on Github, elastic/kibana/issues/87853, a while ago to fix a bug in the previous implementation … --- ## [Kibana Dashboard Two Charts Within a Single Panel](https://discuss.elastic.co/t/kibana-dashboard-two-charts-within-a-single-panel/268708)
**Author:** [@azulgrana](https://discuss.elastic.co/u/azulgrana)\ **Replies:** 4\ **Last updated:** [March 29, 2021, 10:42pm UTC](https://discuss.elastic.co/t/kibana-dashboard-two-charts-within-a-single-panel/268708 "2021-03-29T22:42:33Z")
Hi there, I came across the below image while I was browsing the forum and I wonder if you can give some info on the following 2 things... 1 - What are the steps for placing two charts, see User Authentications, within… --- ## [How can I change the font size of the x-axis and y-axis](https://discuss.elastic.co/t/how-can-i-change-the-font-size-of-the-x-axis-and-y-axis/268663)
**Author:** [@francieliton\_araujo](https://discuss.elastic.co/u/francieliton_araujo)\ **Replies:** 1\ **Last updated:** [March 29, 2021, 10:15pm UTC](https://discuss.elastic.co/t/how-can-i-change-the-font-size-of-the-x-axis-and-y-axis/268663 "2021-03-29T22:15:15Z")
please How can I change the font size of the x-axis and y-axis, it can be through css or another way. --- ## [ILM - Frozen Tier - Searchable Snapshot](https://discuss.elastic.co/t/ilm-frozen-tier-searchable-snapshot/268599)
**Author:** [@austinsonger](https://discuss.elastic.co/u/austinsonger)\ **Replies:** 3\ **Last updated:** [March 29, 2021, 9:16pm UTC](https://discuss.elastic.co/t/ilm-frozen-tier-searchable-snapshot/268599 "2021-03-29T21:16:49Z")
Please read the image for my question: --- ## [Visualize 2 values evolution (sum) with a Pie chart](https://discuss.elastic.co/t/visualize-2-values-evolution-sum-with-a-pie-chart/268669)
**Author:** [@Anto1](https://discuss.elastic.co/u/Anto1)\ **Replies:** 1\ **Last updated:** [March 29, 2021, 5:08pm UTC](https://discuss.elastic.co/t/visualize-2-values-evolution-sum-with-a-pie-chart/268669 "2021-03-29T17:08:30Z")
Hello ! I'm kind of a beginner in creating Kibana visualizations, and I'm actually facing this issue : I have a lot of logs, and some are containing the following fields "inSuccess" (eg. 2), "inError" (eg. 1), which … --- ## [Kibana grok patterns match exact string](https://discuss.elastic.co/t/kibana-grok-patterns-match-exact-string/268257)
**Author:** [@alidrsn](https://discuss.elastic.co/u/alidrsn)\ **Replies:** 3\ **Last updated:** [March 29, 2021, 4:26pm UTC](https://discuss.elastic.co/t/kibana-grok-patterns-match-exact-string/268257 "2021-03-29T16:26:48Z")
Hello there, I want to ingest a log with grok patterns in kibana. The log time format is slightly different from ready-made drafts as belove. 03/24 21:56:55.300 INFO Security..... Time Format -\> dd/MM hh:mm:ss.SSS … --- ## [How to get different Exceptions volume /count occured in given Pod in Kibana](https://discuss.elastic.co/t/how-to-get-different-exceptions-volume-count-occured-in-given-pod-in-kibana/268167)
**Author:** [@mvrnaidu](https://discuss.elastic.co/u/mvrnaidu)\ **Replies:** 1\ **Last updated:** [March 29, 2021, 3:51pm UTC](https://discuss.elastic.co/t/how-to-get-different-exceptions-volume-count-occured-in-given-pod-in-kibana/268167 "2021-03-29T15:51:05Z")
I have some 6 pods running in a container and i need to get all types of Exceptions from their logs by day wise, and also need to get alerts everyday to my email box .how to implement this in Kibana ? thanks in adva… --- ## [Add new values to the field if not available](https://discuss.elastic.co/t/add-new-values-to-the-field-if-not-available/266881)
**Author:** [@Shashankdevaraj](https://discuss.elastic.co/u/Shashankdevaraj)\ **Replies:** 1\ **Last updated:** [March 29, 2021, 3:35pm UTC](https://discuss.elastic.co/t/add-new-values-to-the-field-if-not-available/266881 "2021-03-29T15:35:45Z")
I am splitting the rows on a field called names, if some names are not available in a given time frame I want to add it and display NA across other columns. Please help. Example table: name country state n1 c1 … --- ## ["cannot divide by 0" TinyMath error in Visual builder](https://discuss.elastic.co/t/cannot-divide-by-0-tinymath-error-in-visual-builder/268251)
**Author:** [@preetish\_P](https://discuss.elastic.co/u/preetish_P)\ **Replies:** 2\ **Last updated:** [March 29, 2021, 3:26pm UTC](https://discuss.elastic.co/t/cannot-divide-by-0-tinymath-error-in-visual-builder/268251 "2021-03-29T15:26:53Z")
Hello Elastic community, I am trying to build a metric in visual builder with 2 aggregations and a Math aggregation below them. But I am getting "Cannot divide by 0". Below is my structure of data: sr\_number some\_… --- ## ["Elastic did not load properly". Kibana failed loading in Browser](https://discuss.elastic.co/t/elastic-did-not-load-properly-kibana-failed-loading-in-browser/268043)
**Author:** [@DEEPTHI\_SONA\_G](https://discuss.elastic.co/u/DEEPTHI_SONA_G)\ **Replies:** 3\ **Last updated:** [March 29, 2021, 2:39pm UTC](https://discuss.elastic.co/t/elastic-did-not-load-properly-kibana-failed-loading-in-browser/268043 "2021-03-29T14:39:22Z")
I have tried installing Elasticsearch and kibana in centos7. Both of them are working fine. But when it come to loading kibana on browser we get the error " Elastic did not load properly. Check the server output for more… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=346) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=348)