# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=391 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 392 --- ## [Vega chart not plotting correctly](https://discuss.elastic.co/t/vega-chart-not-plotting-correctly/257675)
**Author:** [@GavinBeattie](https://discuss.elastic.co/u/GavinBeattie)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 4:17pm UTC](https://discuss.elastic.co/t/vega-chart-not-plotting-correctly/257675 "2020-12-04T16:17:08Z")
I have just upgraded to v7.10 and was pleased to see that the Vega visualisation has moved out of experimental. Unfortunately, exitsing charts show the marks offsets from where they should be. I have created a new chart … --- ## [Why the order of split rows change the displayed values on Kibana table visualization](https://discuss.elastic.co/t/why-the-order-of-split-rows-change-the-displayed-values-on-kibana-table-visualization/257168)
**Author:** [@Incauto](https://discuss.elastic.co/u/Incauto)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 4:15pm UTC](https://discuss.elastic.co/t/why-the-order-of-split-rows-change-the-displayed-values-on-kibana-table-visualization/257168 "2020-12-04T16:15:42Z")
Im counting documents with repeated values of the field throughput\_mb\_range grouped by the name of an interface. My metric is Count. My first split row is the name of the interface with a size of 600. My second split … --- ## [Kibana canvas collapse json inside table](https://discuss.elastic.co/t/kibana-canvas-collapse-json-inside-table/255263)
**Author:** [@Carlos\_Fernando\_Palm](https://discuss.elastic.co/u/Carlos_Fernando_Palm)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 3:51pm UTC](https://discuss.elastic.co/t/kibana-canvas-collapse-json-inside-table/255263 "2020-12-04T15:51:30Z")
Hello. I am showing some json inside a table. Thanks to this post: the json is shown correctly. I was wondering if there is a way to collapse said json when it gets really long, so the user does not have to use the mou… --- ## [Sequence diagram in Canvas](https://discuss.elastic.co/t/sequence-diagram-in-canvas/257021)
**Author:** [@Kasun\_Perera](https://discuss.elastic.co/u/Kasun_Perera)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 3:48pm UTC](https://discuss.elastic.co/t/sequence-diagram-in-canvas/257021 "2020-12-04T15:48:56Z")
Can we draw a sequence diagram using Canvas? --- ## [Bar length in Horizontal bar graph is differing based on color condition](https://discuss.elastic.co/t/bar-length-in-horizontal-bar-graph-is-differing-based-on-color-condition/255580)
**Author:** [@Pranusha119](https://discuss.elastic.co/u/Pranusha119)\ **Replies:** 3\ **Last updated:** [December 4, 2020, 3:10pm UTC](https://discuss.elastic.co/t/bar-length-in-horizontal-bar-graph-is-differing-based-on-color-condition/255580 "2020-12-04T15:10:39Z")
This is the Code and result without color conditioning { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "width":806 data: { url: { %context%: true index: index\_ssd\_2 body: { … --- ## [Logstash Apache Logs - pipeline ingest help needed](https://discuss.elastic.co/t/logstash-apache-logs-pipeline-ingest-help-needed/257655)
**Author:** [@retroisbest](https://discuss.elastic.co/u/retroisbest)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 3:03pm UTC](https://discuss.elastic.co/t/logstash-apache-logs-pipeline-ingest-help-needed/257655 "2020-12-04T15:03:29Z")
Hi there, I am using filebeat to push my logs and can see the apache logs using the kibana discover page. im using the apache module with filebeat 7.10 Im struggling ingesting this info so the fields are mapped correc… --- ## [Can we globally store the alert recipient mail and use it as to address watcher email actions](https://discuss.elastic.co/t/can-we-globally-store-the-alert-recipient-mail-and-use-it-as-to-address-watcher-email-actions/257152)
**Author:** [@Akhil\_Mohan](https://discuss.elastic.co/u/Akhil_Mohan)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 3:01pm UTC](https://discuss.elastic.co/t/can-we-globally-store-the-alert-recipient-mail-and-use-it-as-to-address-watcher-email-actions/257152 "2020-12-04T15:01:41Z")
Our aim is to store the mail address as global and use that email address in email actions in watcher as TO address.can you suggest is it possible? --- ## [Kibana Alerts](https://discuss.elastic.co/t/kibana-alerts/256849)
**Author:** [@werner.fletcher](https://discuss.elastic.co/u/werner.fletcher)\ **Replies:** 12\ **Last updated:** [December 4, 2020, 2:40pm UTC](https://discuss.elastic.co/t/kibana-alerts/256849 "2020-12-04T14:40:10Z")
Good day, We've upgraded our subscription to Gold today but i still cannot see the Alerting option for Kibana. I want to set up email alerts to notify me when certain keywords appear in the logs shipped by the Filebeat… --- ## [How to create and embedd Visualizaitions in kibana plugin](https://discuss.elastic.co/t/how-to-create-and-embedd-visualizaitions-in-kibana-plugin/257601)
**Author:** [@K\_Chaitanya](https://discuss.elastic.co/u/K_Chaitanya)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 2:23pm UTC](https://discuss.elastic.co/t/how-to-create-and-embedd-visualizaitions-in-kibana-plugin/257601 "2020-12-04T14:23:47Z")
Hi, I am trying to create a visualization from gui in kibana. and then trying to fetch that visualization (later will export that visualization as json and include it in the package) into kibana plugin using visualizati… --- ## [Create Kibana plugin to write x-large queries](https://discuss.elastic.co/t/create-kibana-plugin-to-write-x-large-queries/257616)
**Author:** [@malsioufi](https://discuss.elastic.co/u/malsioufi)\ **Replies:** 2\ **Last updated:** [December 4, 2020, 1:50pm UTC](https://discuss.elastic.co/t/create-kibana-plugin-to-write-x-large-queries/257616 "2020-12-04T13:50:15Z")
I have an Elasticsearch index of millions of documents. Elasticsearch provides the ability to build statistics and aggregations out of this data and Kibana provides a nice out-of-the-box way to visualize this data. Howe… --- ## [How to set up looging level in Kibana](https://discuss.elastic.co/t/how-to-set-up-looging-level-in-kibana/257649)
**Author:** [@grynhtjnyuk](https://discuss.elastic.co/u/grynhtjnyuk)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 1:06pm UTC](https://discuss.elastic.co/t/how-to-set-up-looging-level-in-kibana/257649 "2020-12-04T13:06:32Z")
hi, could you tell me how to set up explicitly logging level in Kibana as INFO? --- ## [TSVB derivative not showing data when time \< 4 hours](https://discuss.elastic.co/t/tsvb-derivative-not-showing-data-when-time-4-hours/257614)
**Author:** [@bering](https://discuss.elastic.co/u/bering)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 12:42pm UTC](https://discuss.elastic.co/t/tsvb-derivative-not-showing-data-when-time-4-hours/257614 "2020-12-04T12:42:16Z")
My use case is collecting wait stats from MS SQL server, these metrics records waits on different things, I collect these waits every 5 minutes. These waits are just growing until the server restarts, so using TSVB with… --- ## [Multiple projects in same Kibana](https://discuss.elastic.co/t/multiple-projects-in-same-kibana/257347)
**Author:** [@xacobecm](https://discuss.elastic.co/u/xacobecm)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 11:36am UTC](https://discuss.elastic.co/t/multiple-projects-in-same-kibana/257347 "2020-12-04T11:36:57Z")
This is my first post here, so hello everybody and thanks in advance for any help given. I've been working with elastic for a while now, until now I implemented it in the project's k8s cluster. Now, for multiple develo… --- ## [Location based dashboard](https://discuss.elastic.co/t/location-based-dashboard/257559)
**Author:** [@vibhz](https://discuss.elastic.co/u/vibhz)\ **Replies:** 4\ **Last updated:** [December 4, 2020, 11:22am UTC](https://discuss.elastic.co/t/location-based-dashboard/257559 "2020-12-04T11:22:51Z")
Hi, I am trying to create location based dashboard in kibana. location details are not available in the log message, we have to add a logic to map these. Please help. Usecase : Each location contains 400 servers, once w… --- ## [Elasticsearch bucket script aggregation in Kibana](https://discuss.elastic.co/t/elasticsearch-bucket-script-aggregation-in-kibana/257026)
**Author:** [@lakshman-battini](https://discuss.elastic.co/u/lakshman-battini)\ **Replies:** 2\ **Last updated:** [December 4, 2020, 9:33am UTC](https://discuss.elastic.co/t/elasticsearch-bucket-script-aggregation-in-kibana/257026 "2020-12-04T09:33:28Z")
I am trying to create the visualization in Kibana, to show the count of orders whose average api time is less than 60 Sec. Below are the sample ES index documents: order\_id time api 1 50.0 /login 1 … --- ## [Canvas Search field with auto suggest](https://discuss.elastic.co/t/canvas-search-field-with-auto-suggest/257366)
**Author:** [@Alfar](https://discuss.elastic.co/u/Alfar)\ **Replies:** 3\ **Last updated:** [December 4, 2020, 9:23am UTC](https://discuss.elastic.co/t/canvas-search-field-with-auto-suggest/257366 "2020-12-04T09:23:18Z")
Hi there, Are there any ways to create a search field with auto suggest in Kibana Canvas.I already tried with drop down filter, but it does not work for search and auto suggest.Thankful for the positive responses --- ## [Mapping is present but field is missing](https://discuss.elastic.co/t/mapping-is-present-but-field-is-missing/257500)
**Author:** [@pskhanapur](https://discuss.elastic.co/u/pskhanapur)\ **Replies:** 2\ **Last updated:** [December 4, 2020, 9:01am UTC](https://discuss.elastic.co/t/mapping-is-present-but-field-is-missing/257500 "2020-12-04T09:01:19Z")
I have field which has mapping. I can verify that using GET /INDEX/\_mapping. However it is not visible in the fields in the search option in (Index pattern page). The field is visible in the Discover as well --- ## [DateTime in Human Readable format Kibana](https://discuss.elastic.co/t/datetime-in-human-readable-format-kibana/257618)
**Author:** [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Replies:** 2\ **Last updated:** [December 4, 2020, 8:18am UTC](https://discuss.elastic.co/t/datetime-in-human-readable-format-kibana/257618 "2020-12-04T08:18:50Z")
Hi Team, I was trying to create a metric visualization to show when was the last time server health is checked Max(DateTime) really doesnot make more sense to user,so i created the scripted field "LastCheckInHumanReada… --- ## [Visualization show date format have day of week in Kibana](https://discuss.elastic.co/t/visualization-show-date-format-have-day-of-week-in-kibana/257301)
**Author:** [@thuhaa](https://discuss.elastic.co/u/thuhaa)\ **Replies:** 4\ **Last updated:** [December 4, 2020, 7:22am UTC](https://discuss.elastic.co/t/visualization-show-date-format-have-day-of-week-in-kibana/257301 "2020-12-04T07:22:33Z")
My index have date time type attribute. I want to create visualize use date histogram aggregation with interval days. It will be show date format like 2020-12-02. But I want to date show format have day of week like 2020… --- ## [How to filter field with count in datatable](https://discuss.elastic.co/t/how-to-filter-field-with-count-in-datatable/257462)
**Author:** [@tungpzostar](https://discuss.elastic.co/u/tungpzostar)\ **Replies:** 2\ **Last updated:** [December 4, 2020, 4:25am UTC](https://discuss.elastic.co/t/how-to-filter-field-with-count-in-datatable/257462 "2020-12-04T04:25:47Z")
I have field state which has 2 values "BEGIN" and "END", I want to show count when state is "BEGIN" so I've tried { "query": { "match\_phrase": { "state": "BEGIN" } } } but nothing works, any idea how … --- ## [Setup SSO with Azure](https://discuss.elastic.co/t/setup-sso-with-azure/257591)
**Author:** [@Ej\_Eric\_H](https://discuss.elastic.co/u/Ej_Eric_H)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 4:18am UTC](https://discuss.elastic.co/t/setup-sso-with-azure/257591 "2020-12-04T04:18:31Z")
Hello, I am trying to setup SSO on elastic cloud using the instructions below. How do i complete the "create a role Mapping" step? I am new to this program, sorry if this is basic knowledge. Is the API the only way? If… --- ## [How to create bar chart with time intervals x axis in kibana?](https://discuss.elastic.co/t/how-to-create-bar-chart-with-time-intervals-x-axis-in-kibana/257359)
**Author:** [@Cristiane\_Marcarini](https://discuss.elastic.co/u/Cristiane_Marcarini)\ **Replies:** 3\ **Last updated:** [December 3, 2020, 6:15pm UTC](https://discuss.elastic.co/t/how-to-create-bar-chart-with-time-intervals-x-axis-in-kibana/257359 "2020-12-03T18:15:57Z")
how to create bar chart with time intervals x axis in kibana? Can be with JSON or grok. --- ## [Error Metricbeats in Kibana](https://discuss.elastic.co/t/error-metricbeats-in-kibana/256402)
**Author:** [@Cristiane\_Marcarini](https://discuss.elastic.co/u/Cristiane_Marcarini)\ **Replies:** 2\ **Last updated:** [December 3, 2020, 6:10pm UTC](https://discuss.elastic.co/t/error-metricbeats-in-kibana/256402 "2020-12-03T18:10:34Z")
\[exception\] Security must be explicitly enabled when using a \[basic\] license. Enable security by setting \[xpack.security.enabled\] to \[true\] in the elasticsearch.yml file and restart the node.: Check the Elasticsearch Mon… --- ## [Find the unique transactions between passed and failed logs](https://discuss.elastic.co/t/find-the-unique-transactions-between-passed-and-failed-logs/257556)
**Author:** [@kartikr9107](https://discuss.elastic.co/u/kartikr9107)\ **Replies:** 1\ **Last updated:** [December 3, 2020, 5:44pm UTC](https://discuss.elastic.co/t/find-the-unique-transactions-between-passed-and-failed-logs/257556 "2020-12-03T17:44:04Z")
I've created a visualization to show metrics like Total requests, Unique Tests(unique count of test field), Tests failed (Sum bucket with filter for failed tests unique count), Test passed(Sum bucket with filter for pass… --- ## [Upload csv file without timestamp to kibana with ML fails](https://discuss.elastic.co/t/upload-csv-file-without-timestamp-to-kibana-with-ml-fails/257376)
**Author:** [@christophe\_spielmann](https://discuss.elastic.co/u/christophe_spielmann)\ **Replies:** 1\ **Last updated:** [December 3, 2020, 5:02pm UTC](https://discuss.elastic.co/t/upload-csv-file-without-timestamp-to-kibana-with-ml-fails/257376 "2020-12-03T17:02:24Z")
Hello, in the data visualizer of the Machine learning, we used to have a feature to upload a csv. there is blog about that https://www.elastic.co/blog/importing-csv-and-log-data-into-elasticsearch-with-file-data-visual… --- ## [How can I create a sequence diagram using Vega or Vega-lite?](https://discuss.elastic.co/t/how-can-i-create-a-sequence-diagram-using-vega-or-vega-lite/257502)
**Author:** [@shalintha](https://discuss.elastic.co/u/shalintha)\ **Replies:** 3\ **Last updated:** [December 3, 2020, 4:35pm UTC](https://discuss.elastic.co/t/how-can-i-create-a-sequence-diagram-using-vega-or-vega-lite/257502 "2020-12-03T16:35:39Z")
I want to create a Sequence diagram using Vega visualize for my Kibana Dashboard. Is there a way to create Sequence diagram using Vega or Vega-lite (or using D3js)? --- ## [How to make the "Discover" tab data to Table view](https://discuss.elastic.co/t/how-to-make-the-discover-tab-data-to-table-view/257001)
**Author:** [@qub123](https://discuss.elastic.co/u/qub123)\ **Replies:** 12\ **Last updated:** [December 3, 2020, 4:14pm UTC](https://discuss.elastic.co/t/how-to-make-the-discover-tab-data-to-table-view/257001 "2020-12-03T16:14:43Z")
Hi, Right now the default looks of the discover mode is not in table view, just wondering is there a setting to change the documents show in a table view, instead of document per document ? --- ## [How to create visualisation in kibana for stickiness(Ratio of DAU/MAU)](https://discuss.elastic.co/t/how-to-create-visualisation-in-kibana-for-stickiness-ratio-of-dau-mau/257340)
**Author:** [@dharanesh](https://discuss.elastic.co/u/dharanesh)\ **Replies:** 3\ **Last updated:** [December 3, 2020, 3:59pm UTC](https://discuss.elastic.co/t/how-to-create-visualisation-in-kibana-for-stickiness-ratio-of-dau-mau/257340 "2020-12-03T15:59:34Z")
Hi, i am new to kibana, i created separate visualisation for DAU and MAU now i want to create another chats which shows Ratio of DAU and MAU, how to do this in kibana , is it possible to create charts for this in kibana. … --- ## [Kibana preserve custom time from dasboard to Discover](https://discuss.elastic.co/t/kibana-preserve-custom-time-from-dasboard-to-discover/257284)
**Author:** [@Rnx](https://discuss.elastic.co/u/Rnx)\ **Replies:** 1\ **Last updated:** [December 3, 2020, 3:55pm UTC](https://discuss.elastic.co/t/kibana-preserve-custom-time-from-dasboard-to-discover/257284 "2020-12-03T15:55:28Z")
How to preserve chosen time in Kibana Dashboard by clicking on link to Discover panel? I need to view documents from specific time according to peaks in graphs in Dashboard. Therefore my chosen time is within 3-4 min ti… --- ## [Kibana requesting too many doc values](https://discuss.elastic.co/t/kibana-requesting-too-many-doc-values/147760)
**Author:** [@mightyguava](https://discuss.elastic.co/u/mightyguava)\ **Replies:** 4\ **Last updated:** [December 3, 2020, 3:40pm UTC](https://discuss.elastic.co/t/kibana-requesting-too-many-doc-values/147760 "2020-12-03T15:40:07Z")
We have an elasticsearch cluster that indexes some events that flow through our system for debugging use. These events have pretty widely varying formats, so they end up generating a lot of different fields. Kibana maps … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=390) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=392)