# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=835 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 836 --- ## [Combine min and max aggregations in a line graph](https://discuss.elastic.co/t/combine-min-and-max-aggregations-in-a-line-graph/129961)
**Author:** [@spynxo](https://discuss.elastic.co/u/spynxo)\ **Replies:** 1\ **Last updated:** [April 30, 2018, 3:45pm UTC](https://discuss.elastic.co/t/combine-min-and-max-aggregations-in-a-line-graph/129961 "2018-04-30T15:45:56Z")
Hello, Is there a way to combine the min and max aggregations in a line graph. I would like to see a single line with the results of both the min and max aggregations. Thanks! --- ## [Create a pie chart from multiple searches](https://discuss.elastic.co/t/create-a-pie-chart-from-multiple-searches/130009)
**Author:** [@L33T](https://discuss.elastic.co/u/L33T)\ **Replies:** 2\ **Last updated:** [April 30, 2018, 2:16pm UTC](https://discuss.elastic.co/t/create-a-pie-chart-from-multiple-searches/130009 "2018-04-30T14:16:50Z")
Hi, I have a few searches saved from discovery, i\`d like to create some pie charts that contain multiple saved searches, how can i accomplish this? Regards, --- ## [Changing field type in Kibana UI](https://discuss.elastic.co/t/changing-field-type-in-kibana-ui/129896)
**Author:** [@cactus](https://discuss.elastic.co/u/cactus)\ **Replies:** 3\ **Last updated:** [April 30, 2018, 12:39am UTC](https://discuss.elastic.co/t/changing-field-type-in-kibana-ui/129896 "2018-04-30T00:39:31Z")
Hello, I need to change field type from string to text, can I do it via Kibana in index patterns-\>fields or should it be done via static mapping in elasticsearch default template. What is the difference? Thanks Kibana… --- ## [Visualize all the dates a keyword field changes](https://discuss.elastic.co/t/visualize-all-the-dates-a-keyword-field-changes/129300)
**Author:** [@dao](https://discuss.elastic.co/u/dao)\ **Replies:** 2\ **Last updated:** [April 28, 2018, 9:50am UTC](https://discuss.elastic.co/t/visualize-all-the-dates-a-keyword-field-changes/129300 "2018-04-28T09:50:08Z")
I have a serie of documents like this: timestamp CAR.keyword ENGINE\_SERIAL\_NUMBER.keyword 20-02-2017 CAR1 A0001 20-02-2017 CAR2 B0001 21-02-2017 CAR1 A0001 21-02-2017 CAR2 B0001 22-02-2017 CAR1 A0001 2… --- ## [Visual Builder Markdown - Displaying Strings](https://discuss.elastic.co/t/visual-builder-markdown-displaying-strings/129730)
**Author:** [@pepperhat](https://discuss.elastic.co/u/pepperhat)\ **Replies:** 4\ **Last updated:** [April 27, 2018, 6:27pm UTC](https://discuss.elastic.co/t/visual-builder-markdown-displaying-strings/129730 "2018-04-27T18:27:01Z")
Rewriting this as I've learned a couple of things: A bit of background: I'm filtering my query to only return a single result I'm using this to create a "document view" type visual I need to reference the values witho… --- ## [Dashboards, Searches and Visualizations](https://discuss.elastic.co/t/dashboards-searches-and-visualizations/129864)
**Author:** [@tempheon](https://discuss.elastic.co/u/tempheon)\ **Replies:** 3\ **Last updated:** [April 27, 2018, 5:47pm UTC](https://discuss.elastic.co/t/dashboards-searches-and-visualizations/129864 "2018-04-27T17:47:26Z")
Hi ! I want to know, if it's possible to make a dashboard/feature change notification functionality with Elastic Search If someone do a modification on a specific Visualization, if there a way to know if an update has … --- ## [Grok - Optional Spacing](https://discuss.elastic.co/t/grok-optional-spacing/129704)
**Author:** [@chunter85](https://discuss.elastic.co/u/chunter85)\ **Replies:** 5\ **Last updated:** [April 27, 2018, 4:43pm UTC](https://discuss.elastic.co/t/grok-optional-spacing/129704 "2018-04-27T16:43:05Z")
I am having an issue where we have vary amounts of white space after our logger name. There are 13 characters reserved for this field and depending on what the logger is called depends on how much white space there is p… --- ## [Group by on the sum of aggregation](https://discuss.elastic.co/t/group-by-on-the-sum-of-aggregation/128902)
**Author:** [@didinyah](https://discuss.elastic.co/u/didinyah)\ **Replies:** 4\ **Last updated:** [April 27, 2018, 3:39pm UTC](https://discuss.elastic.co/t/group-by-on-the-sum-of-aggregation/128902 "2018-04-27T15:39:37Z")
Hi, I would like to know if there's a way to do an aggregation on the result of the sum. Let's say I have 8 documents. 6 of them have 1 revision 2 of them have 2 revisions I want to get : 1 : 6 hits 2 : 2 hits Th… --- ## [Cannot Search/Filter for Date](https://discuss.elastic.co/t/cannot-search-filter-for-date/129834)
**Author:** [@mmethe](https://discuss.elastic.co/u/mmethe)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 1:43pm UTC](https://discuss.elastic.co/t/cannot-search-filter-for-date/129834 "2018-04-27T13:43:52Z")
I use JDBC to grab sql data and put into elastic search. I can the data in kibana but I cannot filter on a date field, clsddate. input: input { jdbc { jdbc\_driver\_library =\> "/etc/logstash/drivers/mssql-jdbc-6.2.2.j… --- ## [Can't log in kibana as the built-in elastic user](https://discuss.elastic.co/t/cant-log-in-kibana-as-the-built-in-elastic-user/129795)
**Author:** [@panjf2000](https://discuss.elastic.co/u/panjf2000)\ **Replies:** 7\ **Last updated:** [April 27, 2018, 11:42am UTC](https://discuss.elastic.co/t/cant-log-in-kibana-as-the-built-in-elastic-user/129795 "2018-04-27T11:42:25Z")
Hi all, after installing x-pack on elasticsearch and kibana，i tried to log in kibana as the built-in elastic user and it can enter kibana successfully，however，it turned out i log in as the "kibana" user，how would that ha… --- ## [How to Correlate Data?](https://discuss.elastic.co/t/how-to-correlate-data/128547)
**Author:** [@Christoph\_Kiefer](https://discuss.elastic.co/u/Christoph_Kiefer)\ **Replies:** 4\ **Last updated:** [April 27, 2018, 10:52am UTC](https://discuss.elastic.co/t/how-to-correlate-data/128547 "2018-04-27T10:52:40Z")
Dear All Are there ways to mimic somehow the following SQL statement in Kibana / ES? // SELECT \* FROM network\_table // WHERE connection\_id IN ( // SELECT connection\_id FROM connection\_table // WHERE user\_id = "k… --- ## [Kibana Not seeing Indexes](https://discuss.elastic.co/t/kibana-not-seeing-indexes/129783)
**Author:** [@L33T](https://discuss.elastic.co/u/L33T)\ **Replies:** 8\ **Last updated:** [April 27, 2018, 10:37am UTC](https://discuss.elastic.co/t/kibana-not-seeing-indexes/129783 "2018-04-27T10:37:31Z")
Hi, Seem to have an issue with Kibana seeing indexes properly. I have a index pattern called winlogbeat-6.2.4-\* In elastic-hq i can see the indexes winlogbeat-6.2.4-2018.04.20 for each day but when i go to discover i g… --- ## [To get XML formatt](https://discuss.elastic.co/t/to-get-xml-formatt/129804)
**Author:** [@gangireddy\_l](https://discuss.elastic.co/u/gangireddy_l)\ **Replies:** 1\ **Last updated:** [April 27, 2018, 9:59am UTC](https://discuss.elastic.co/t/to-get-xml-formatt/129804 "2018-04-27T09:59:04Z")
HI, Iam using ELk with filebeat for centralized logs.Our logs are in xml format that comes in one line as shown below. \[image\] AND I NEED TO GET LOGS AS SHOWN BELOW..HOW TO SOLVE IT...? \[image\] --- ## [Double Aggregation metric visualization](https://discuss.elastic.co/t/double-aggregation-metric-visualization/129687)
**Author:** [@pgprb](https://discuss.elastic.co/u/pgprb)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 7:31am UTC](https://discuss.elastic.co/t/double-aggregation-metric-visualization/129687 "2018-04-27T07:31:54Z")
Hi there, I'm new to Kibana and I'm trying to make a metric visualization (for now) based on a query dsl. The query is something like this: GET idx/\_search { "aggs": { "top\_tags": { "terms": { "field": "anObjectUU… --- ## [Configure xpack for Elastic Search and Kibana with Active Directory](https://discuss.elastic.co/t/configure-xpack-for-elastic-search-and-kibana-with-active-directory/129584)
**Author:** [@stargate](https://discuss.elastic.co/u/stargate)\ **Replies:** 5\ **Last updated:** [April 27, 2018, 5:34am UTC](https://discuss.elastic.co/t/configure-xpack-for-elastic-search-and-kibana-with-active-directory/129584 "2018-04-27T05:34:41Z")
Hi, We are using trial version of xpack security for ElasticSearch & Kibana and running it on a single node. We have configured 'elasticsearch.yml' and 'kibana.yml' config files with the active directory details. I ha… --- ## [Leading zeros on number field formatting](https://discuss.elastic.co/t/leading-zeros-on-number-field-formatting/129653)
**Author:** [@uoberdorf](https://discuss.elastic.co/u/uoberdorf)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 5:32am UTC](https://discuss.elastic.co/t/leading-zeros-on-number-field-formatting/129653 "2018-04-27T05:32:22Z")
Hi, I am trying to format a numeric field in kibana to show leading zeros. The goal is to receive a fixed length on the field. I configured a formatter on the field in the index management and followed the examples on… --- ## [Refresh the current status OR only show/hide elements of choice](https://discuss.elastic.co/t/refresh-the-current-status-or-only-show-hide-elements-of-choice/128662)
**Author:** [@nikhilkvn](https://discuss.elastic.co/u/nikhilkvn)\ **Replies:** 4\ **Last updated:** [April 27, 2018, 4:47am UTC](https://discuss.elastic.co/t/refresh-the-current-status-or-only-show-hide-elements-of-choice/128662 "2018-04-27T04:47:05Z")
I have an index of documents which loosely translates as: { "time": "2018-04-19T05:26:10.000Z", "status": "alive", "mac": "a1:b1:c1:d1:e1:f1", }, { "time": "2018-04-19T05:26:10.000Z", "status": "dead", "mac": "a… --- ## [Reporting counts based on date criteria](https://discuss.elastic.co/t/reporting-counts-based-on-date-criteria/129573)
**Author:** [@kenneth](https://discuss.elastic.co/u/kenneth)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 4:10am UTC](https://discuss.elastic.co/t/reporting-counts-based-on-date-criteria/129573 "2018-04-27T04:10:25Z")
Hi, I have this SQL table called UserHistory ingested in ElasticSearch. This table simply stores a record every time a user joins a group and when was that user an active member of that group based on the From and To da… --- ## [Java script code to get content from KIBANA](https://discuss.elastic.co/t/java-script-code-to-get-content-from-kibana/129725)
**Author:** [@Mas](https://discuss.elastic.co/u/Mas)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 3:38am UTC](https://discuss.elastic.co/t/java-script-code-to-get-content-from-kibana/129725 "2018-04-27T03:38:30Z")
I need to use an HTTP Request and Find a way in JAVA SCRIPTt to get CONTENT from Kibana I need and want almost this similar thing: var my\_content\_from\_file = file\_content(ext + file\_name) out(my\_content\_from\_file) //I… --- ## [\[Timelion\]Stop showing line if no data is available](https://discuss.elastic.co/t/timelion-stop-showing-line-if-no-data-is-available/129434)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 2:10am UTC](https://discuss.elastic.co/t/timelion-stop-showing-line-if-no-data-is-available/129434 "2018-04-27T02:10:59Z")
Hi, I'm using timelion to draw a graph of signal strength. Data is gathered at 5m intervals. The query below works but the problem is that when data stops coming in, the last value if used to continue drawing a line eve… --- ## [Login form for kibana disabled](https://discuss.elastic.co/t/login-form-for-kibana-disabled/129385)
**Author:** [@wolecharles\_job](https://discuss.elastic.co/u/wolecharles_job)\ **Replies:** 2\ **Last updated:** [April 27, 2018, 12:05am UTC](https://discuss.elastic.co/t/login-form-for-kibana-disabled/129385 "2018-04-27T00:05:47Z")
\[Capture\] Hi Everyone Pls the username and password for kibana are disabled --- ## [Comparing 2 docs](https://discuss.elastic.co/t/comparing-2-docs/124454)
**Author:** [@ganessen23](https://discuss.elastic.co/u/ganessen23)\ **Replies:** 8\ **Last updated:** [April 26, 2018, 10:05pm UTC](https://discuss.elastic.co/t/comparing-2-docs/124454 "2018-04-26T22:05:49Z")
Hi guys, I want to compare 2 docs. Lets say I have doc A & doc B (csv). Both docs contains same logs. A contains 15 lines , and B contains 10 lines (5 lines removed). How should i proceed to find out which lines are mi… --- ## [Unable to sort on @timestamp](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111)
**Author:** [@AaronKalair](https://discuss.elastic.co/u/AaronKalair)\ **Replies:** 8\ **Last updated:** [April 26, 2018, 10:02pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111 "2018-04-26T22:02:25Z")
Hello, I'm using Kibana v5.2.2 and Elasticsearch v5.2.2 I have Kibana setup to view my logs and I want to sort them by the @timestamp field but the little triangle that appears next to \_score to let you sort by score d… --- ## [Kibana Data Table Visualization](https://discuss.elastic.co/t/kibana-data-table-visualization/129592)
**Author:** [@Dhanashree](https://discuss.elastic.co/u/Dhanashree)\ **Replies:** 1\ **Last updated:** [April 26, 2018, 9:00pm UTC](https://discuss.elastic.co/t/kibana-data-table-visualization/129592 "2018-04-26T21:00:44Z")
Hi, How can i get multiple count columns in data table in visualization and add 2 columns and get value in 3rd column one table? --- ## [How to show kibana histogramme with two files values](https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631)
**Author:** [@ali1](https://discuss.elastic.co/u/ali1)\ **Replies:** 1\ **Last updated:** [April 26, 2018, 8:57pm UTC](https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631 "2018-04-26T20:57:50Z")
Hello , i have the following index with these values \[tableau\_index\] and i want to show a histogramme like this : 1- X-Axis contains the value of the Code filed. 2 - Y-Axis contains the value of the Amount filed. c… --- ## [Kibana shows white screen](https://discuss.elastic.co/t/kibana-shows-white-screen/129740)
**Author:** [@shaharzi](https://discuss.elastic.co/u/shaharzi)\ **Replies:** 1\ **Last updated:** [April 26, 2018, 8:32pm UTC](https://discuss.elastic.co/t/kibana-shows-white-screen/129740 "2018-04-26T20:32:30Z")
Hi, Kibana shows white screen, it is not rendering the ui, any one know why? thanks. --- ## [How to Use terms in Y - axis](https://discuss.elastic.co/t/how-to-use-terms-in-y-axis/129354)
**Author:** [@Humornoy](https://discuss.elastic.co/u/Humornoy)\ **Replies:** 2\ **Last updated:** [April 26, 2018, 4:11pm UTC](https://discuss.elastic.co/t/how-to-use-terms-in-y-axis/129354 "2018-04-26T16:11:51Z")
Hello and sorry for my bad english. I have this JSON \[image\] and i need line visualize where x = matchMetric.sTime and y = matchMetric.NumTicks \[image\] … --- ## [Plot Line Chart with Kibana Visualize](https://discuss.elastic.co/t/plot-line-chart-with-kibana-visualize/129301)
**Author:** [@AlexisC](https://discuss.elastic.co/u/AlexisC)\ **Replies:** 6\ **Last updated:** [April 26, 2018, 3:57pm UTC](https://discuss.elastic.co/t/plot-line-chart-with-kibana-visualize/129301 "2018-04-26T15:57:04Z")
I want to plot a specific line chart with Kibana Visualize. My data looks like this Timestamp / Value / Serie 15000 / 5.0 / 1 15500 / 12.5 / 1 16000 / 23 / 1 16500 / 16.2 / 2 17000 / 14.9 / 2 18000 / 4.6 / 3 ... … --- ## [Data table rows with zero count](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305)
**Author:** [@muchypup](https://discuss.elastic.co/u/muchypup)\ **Replies:** 3\ **Last updated:** [April 26, 2018, 2:03pm UTC](https://discuss.elastic.co/t/data-table-rows-with-zero-count/129305 "2018-04-26T14:03:05Z")
I am trying to create a report in Kibana to show all entries with zero count older than 60 days. I can create a filter to get the time range, but Kibana is not showing any records with zero count. I can't find any option… --- ## [How to export Kibana (Dashboards, Visualizations and Searchs) from Command line (e.g curl) to json file](https://discuss.elastic.co/t/how-to-export-kibana-dashboards-visualizations-and-searchs-from-command-line-e-g-curl-to-json-file/129256)
**Author:** [@Edouard\_Fazenda](https://discuss.elastic.co/u/Edouard_Fazenda)\ **Replies:** 2\ **Last updated:** [April 26, 2018, 11:24am UTC](https://discuss.elastic.co/t/how-to-export-kibana-dashboards-visualizations-and-searchs-from-command-line-e-g-curl-to-json-file/129256 "2018-04-26T11:24:33Z")
Dear Community, I have Kibana 6.2.3 installed on my nodes and I wanted to know how I can export (Dashboards, Visualizations and Searchs) to a JSON file in order to backup the définitions in a versionning control system… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=834) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=836)