# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=632 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 633 --- ## [Possible to show multiple columns on a data table?](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880)
**Author:** [@cgmelastic](https://discuss.elastic.co/u/cgmelastic)\ **Replies:** 4\ **Last updated:** [July 25, 2019, 12:07pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880 "2019-07-25T12:07:01Z")
I'm fairly proficient with Data Table visualizations, but have mostly kept them to 2-3 columns. E.G. |bucket|count| or something like |bucket|count|sibling aggregation|. Now I'd like to do something a little more compli… --- ## [Timelion multiple queries](https://discuss.elastic.co/t/timelion-multiple-queries/189424)
**Author:** [@Anirudhan](https://discuss.elastic.co/u/Anirudhan)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 10:54am UTC](https://discuss.elastic.co/t/timelion-multiple-queries/189424 "2019-07-25T10:54:49Z")
.es(index="\*\*\*\*\*\*",timefield='@updated',metric=avg:mempool\_used,q='species.keyword : "mempools" AND device\_id: 18 AND mempool\_descr.keyword : "Routing Engine"',kibana=true).lines(width=1, stack=true, fill=1).yaxis(label… --- ## [Issue due separated Y Axis' scaling adapting to data bounds in Visual builder in Kibana 7.1](https://discuss.elastic.co/t/issue-due-separated-y-axis-scaling-adapting-to-data-bounds-in-visual-builder-in-kibana-7-1/189569)
**Author:** [@Orunacher-Dataviz](https://discuss.elastic.co/u/Orunacher-Dataviz)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 10:14am UTC](https://discuss.elastic.co/t/issue-due-separated-y-axis-scaling-adapting-to-data-bounds-in-visual-builder-in-kibana-7-1/189569 "2019-07-25T10:14:03Z")
Hi everyone, I am trying to build a time series visual builder using a realtime database. The thing is, when I try to put up to 4 data series ( And even with 2 ) with two distinct physical units hence with two scales on… --- ## [Aggregation part doesn't have significant text part. How can I visualize my significan text code?](https://discuss.elastic.co/t/aggregation-part-doesnt-have-significant-text-part-how-can-i-visualize-my-significan-text-code/187912)
**Author:** [@mr\_searchng](https://discuss.elastic.co/u/mr_searchng)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 10:00am UTC](https://discuss.elastic.co/t/aggregation-part-doesnt-have-significant-text-part-how-can-i-visualize-my-significan-text-code/187912 "2019-07-25T10:00:53Z")
--- ## ["Connection Refused" for Elasticsearch and Kibana on AWS Elastic Beanstalk](https://discuss.elastic.co/t/connection-refused-for-elasticsearch-and-kibana-on-aws-elastic-beanstalk/187836)
**Author:** [@sami-t](https://discuss.elastic.co/u/sami-t)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 9:56am UTC](https://discuss.elastic.co/t/connection-refused-for-elasticsearch-and-kibana-on-aws-elastic-beanstalk/187836 "2019-07-25T09:56:00Z")
I am trying to get the ELK stack deployed on my EC2 instance belonging to an ElasticBeanstalk environment, a Django app. I was able to set-up the ELK stack locally and it worked perfectly fine. But now I am struggling w… --- ## [How to use DSL query from Kibana dev-tools in visualisation?](https://discuss.elastic.co/t/how-to-use-dsl-query-from-kibana-dev-tools-in-visualisation/187846)
**Author:** [@shafeequeaslam](https://discuss.elastic.co/u/shafeequeaslam)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 9:41am UTC](https://discuss.elastic.co/t/how-to-use-dsl-query-from-kibana-dev-tools-in-visualisation/187846 "2019-07-25T09:41:49Z")
I have successfully aggregated and queried a particular content I needed in Kibana Dev Tools. However, I need this information in a tabular form either as CSV or PDF. For this, I need to run the DSL query I constructed i… --- ## [Kibana convert date values](https://discuss.elastic.co/t/kibana-convert-date-values/188041)
**Author:** [@soufiane1](https://discuss.elastic.co/u/soufiane1)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 9:33am UTC](https://discuss.elastic.co/t/kibana-convert-date-values/188041 "2019-07-25T09:33:00Z")
Hello everyone, I've loaded a csv file into logstash, which contains a date field, I can see in elasticSearch JSON that data is successfully loaded but Kibana display it by converting the year value, for example : It … --- ## [TimeLion Fill Colour options](https://discuss.elastic.co/t/timelion-fill-colour-options/188010)
**Author:** [@ek9boy](https://discuss.elastic.co/u/ek9boy)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 9:27am UTC](https://discuss.elastic.co/t/timelion-fill-colour-options/188010 "2019-07-25T09:27:54Z")
Hi, I wanted to know if there is an option to have the line of the graph one colour e.g red showing the critical point however the fill below that line as yellow? Example Below: .es(q=sourcetype:Honda,index=ListedCars,… --- ## [Adding aggregated percentages in data tables or pie charts](https://discuss.elastic.co/t/adding-aggregated-percentages-in-data-tables-or-pie-charts/188934)
**Author:** [@farooq.muhammad41](https://discuss.elastic.co/u/farooq.muhammad41)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 9:08am UTC](https://discuss.elastic.co/t/adding-aggregated-percentages-in-data-tables-or-pie-charts/188934 "2019-07-25T09:08:24Z")
What I am trying to do seems simple and doable but for whatever reason i can't find a way to do it: Use Case: My data in ES is modeled like so (ignoring metadata): { project\_name: Test\_Group1, build\_name: SomeTests1… --- ## [How to link two views in a dashboard?](https://discuss.elastic.co/t/how-to-link-two-views-in-a-dashboard/187881)
**Author:** [@daniel.velasco](https://discuss.elastic.co/u/daniel.velasco)\ **Replies:** 2\ **Last updated:** [July 25, 2019, 8:41am UTC](https://discuss.elastic.co/t/how-to-link-two-views-in-a-dashboard/187881 "2019-07-25T08:41:47Z")
Hi, I'm trying to link two elements from differents index. I mean, If i have a dashboard with two views and i use a view filter in one of them. I would like to see the row with the same id in the other table. I don't … --- ## [Visual Builder - Wrong Average/Count Values](https://discuss.elastic.co/t/visual-builder-wrong-average-count-values/188511)
**Author:** [@livio.zanol](https://discuss.elastic.co/u/livio.zanol)\ **Replies:** 1\ **Last updated:** [July 25, 2019, 8:33am UTC](https://discuss.elastic.co/t/visual-builder-wrong-average-count-values/188511 "2019-07-25T08:33:40Z")
I'm trying to make a visualization for my current sensors (link: https://discuss.elastic.co/t/calculate-kwh/188419) Doing some more deep analisys on the problem, I'm facing an issue that I cannot resolve. The average v… --- ## [Adding new index-pattern in Kibana through REST API](https://discuss.elastic.co/t/adding-new-index-pattern-in-kibana-through-rest-api/191742)
**Author:** [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\ **Replies:** 6\ **Last updated:** [July 25, 2019, 7:55am UTC](https://discuss.elastic.co/t/adding-new-index-pattern-in-kibana-through-rest-api/191742 "2019-07-25T07:55:50Z")
Hi I'm upgrading from 5.6.13 to 7.0.0. I came to know there are few breaking changes. Earlier I use to have a script to create index-pattern, visualizations, dashboards through REST API Can you direct me a sample to d… --- ## [Kibana toolbar autorefresh is missing](https://discuss.elastic.co/t/kibana-toolbar-autorefresh-is-missing/192166)
**Author:** [@WhiteWind](https://discuss.elastic.co/u/WhiteWind)\ **Replies:** 3\ **Last updated:** [July 25, 2019, 7:18am UTC](https://discuss.elastic.co/t/kibana-toolbar-autorefresh-is-missing/192166 "2019-07-25T07:18:32Z")
I can not see autorefresh settings and my toolbar is looks different from the one in screenshots from the docs: --- ## [Kibana 7.2.0 rpm download](https://discuss.elastic.co/t/kibana-7-2-0-rpm-download/191949)
**Author:** [@cool\_guy99](https://discuss.elastic.co/u/cool_guy99)\ **Replies:** 3\ **Last updated:** [July 25, 2019, 6:10am UTC](https://discuss.elastic.co/t/kibana-7-2-0-rpm-download/191949 "2019-07-25T06:10:17Z")
Is there a way to install the rpm file for kibana and follow a different directory structure layout other than what's mentioned here: https://www.elastic.co/guide/en/kibana/current/rpm.html#rpm-layout I want to know if … --- ## [How to use Kibana Query in 7.1.1](https://discuss.elastic.co/t/how-to-use-kibana-query-in-7-1-1/192013)
**Author:** [@premkumar](https://discuss.elastic.co/u/premkumar)\ **Replies:** 2\ **Last updated:** [July 25, 2019, 1:35am UTC](https://discuss.elastic.co/t/how-to-use-kibana-query-in-7-1-1/192013 "2019-07-25T01:35:47Z")
Hi Team, I'm new to ELK stack and i have successfully indexed the server log data to elastic search and able to view the indexed data in kibana. I have been trying to search for a certain set of strings in the message … --- ## [Data not being visualized in histogram](https://discuss.elastic.co/t/data-not-being-visualized-in-histogram/185901)
**Author:** [@dnwobu](https://discuss.elastic.co/u/dnwobu)\ **Replies:** 3\ **Last updated:** [July 24, 2019, 9:53pm UTC](https://discuss.elastic.co/t/data-not-being-visualized-in-histogram/185901 "2019-07-24T21:53:39Z")
I am using Kibana 7 and have a histogram visualization for Core User %. I have confirmed valid data for the cpu's is being sent to Elasticsearch and Kibana can see the data in "Discover". However my visualizations seem t… --- ## [Show all labels date in x axis](https://discuss.elastic.co/t/show-all-labels-date-in-x-axis/192068)
**Author:** [@Nathy\_Rivera](https://discuss.elastic.co/u/Nathy_Rivera)\ **Replies:** 1\ **Last updated:** [July 24, 2019, 9:03pm UTC](https://discuss.elastic.co/t/show-all-labels-date-in-x-axis/192068 "2019-07-24T21:03:24Z")
Hi! I want to show all dates in mi histogram, actually i'm using interval -- hourly but i cant see all the hours in the graph --- ## [Third party plugins are not visible in Kibana 7.1.1](https://discuss.elastic.co/t/third-party-plugins-are-not-visible-in-kibana-7-1-1/192027)
**Author:** [@Rhonda\_Gregory](https://discuss.elastic.co/u/Rhonda_Gregory)\ **Replies:** 1\ **Last updated:** [July 24, 2019, 8:55pm UTC](https://discuss.elastic.co/t/third-party-plugins-are-not-visible-in-kibana-7-1-1/192027 "2019-07-24T20:55:28Z")
Hi, I am trying to experiment with 3rd party plugin. I have ES and Kibana 7.1.1 installed on Centos7 via RPM. I used kibana-plugin tool to install a plugin. I see the following in the kibana log: "Optimization of bundle… --- ## [Aggregating Data for Visualization](https://discuss.elastic.co/t/aggregating-data-for-visualization/191429)
**Author:** [@talqadi7](https://discuss.elastic.co/u/talqadi7)\ **Replies:** 5\ **Last updated:** [July 24, 2019, 8:37pm UTC](https://discuss.elastic.co/t/aggregating-data-for-visualization/191429 "2019-07-24T20:37:07Z")
Hi all, I'm trying visualize data based on an aggregation of a certain column. In this case, its company name. Throughout my data, company names are not standard, and I would like to find a way to either pre-aggregate th… --- ## [Range Aggregation using difference between 2 fields](https://discuss.elastic.co/t/range-aggregation-using-difference-between-2-fields/191946)
**Author:** [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\ **Replies:** 2\ **Last updated:** [July 24, 2019, 8:07pm UTC](https://discuss.elastic.co/t/range-aggregation-using-difference-between-2-fields/191946 "2019-07-24T20:07:16Z")
I want to create a visualization where buckets must be created with range or a value(0-5, 5-10, 10-15). This value is not available in a field but should be derived from difference between 2 fields. --- ## [Drill down pie charts in kibana 7.2.0](https://discuss.elastic.co/t/drill-down-pie-charts-in-kibana-7-2-0/191992)
**Author:** [@vaibhav.rodage](https://discuss.elastic.co/u/vaibhav.rodage)\ **Replies:** 1\ **Last updated:** [July 24, 2019, 7:31pm UTC](https://discuss.elastic.co/t/drill-down-pie-charts-in-kibana-7-2-0/191992 "2019-07-24T19:31:48Z")
let's say I bucket my data by "OS" and those "OS" have some hosts installed "host". What I want to do is that when I click a "OS", another chart on same dashboard(dashboard have other visualizations but that should not u… --- ## [Unable to use scripted fields with Kibana 7.2](https://discuss.elastic.co/t/unable-to-use-scripted-fields-with-kibana-7-2/191037)
**Author:** [@tturpin](https://discuss.elastic.co/u/tturpin)\ **Replies:** 3\ **Last updated:** [July 24, 2019, 7:29pm UTC](https://discuss.elastic.co/t/unable-to-use-scripted-fields-with-kibana-7-2/191037 "2019-07-24T19:29:22Z")
We recently upgraded from Kibana 6.5.1 to 7.2. I'm having very strange behavior with my scripted fields. I'm unable to view any of my searches on the Discover tab. I get an error that states "1 of 161 shards failed", … --- ## [Y-Axis not sorting Ascending or Descending on Vega-Lite](https://discuss.elastic.co/t/y-axis-not-sorting-ascending-or-descending-on-vega-lite/191902)
**Author:** [@BrunoSdeMenezes](https://discuss.elastic.co/u/BrunoSdeMenezes)\ **Replies:** 3\ **Last updated:** [July 24, 2019, 7:28pm UTC](https://discuss.elastic.co/t/y-axis-not-sorting-ascending-or-descending-on-vega-lite/191902 "2019-07-24T19:28:41Z")
Hello There, I'm trying to plot a graph using Vega-Lite, everything works fine, but I need the Y-axis to be reversed. The most recent date on top and the older dates on bottom. I've tried use the sort, but nothing seems… --- ## [Kibana retention rate metric and charts](https://discuss.elastic.co/t/kibana-retention-rate-metric-and-charts/191871)
**Author:** [@Richard\_Bao](https://discuss.elastic.co/u/Richard_Bao)\ **Replies:** 2\ **Last updated:** [July 24, 2019, 6:34pm UTC](https://discuss.elastic.co/t/kibana-retention-rate-metric-and-charts/191871 "2019-07-24T18:34:26Z")
My case is show user use an app retention rate in last 30 day. value = app opened count / total installed app count How to do this by using Kibana? --- ## [Show latest document data on the dashboard](https://discuss.elastic.co/t/show-latest-document-data-on-the-dashboard/191945)
**Author:** [@syedsfayaz](https://discuss.elastic.co/u/syedsfayaz)\ **Replies:** 2\ **Last updated:** [July 24, 2019, 6:12pm UTC](https://discuss.elastic.co/t/show-latest-document-data-on-the-dashboard/191945 "2019-07-24T18:12:10Z")
Hi I am trying to create a custom dashboard either on canvas or on kibana to show the build status of last run or running jenkins job. I want to get data from jenkins api and show its status (Success, Failure, In pro… --- ## [Snapshot of Kibana 7.1 dashboard using phantomjs](https://discuss.elastic.co/t/snapshot-of-kibana-7-1-dashboard-using-phantomjs/191874)
**Author:** [@Rajashree\_Sekar](https://discuss.elastic.co/u/Rajashree_Sekar)\ **Replies:** 1\ **Last updated:** [July 24, 2019, 5:09pm UTC](https://discuss.elastic.co/t/snapshot-of-kibana-7-1-dashboard-using-phantomjs/191874 "2019-07-24T17:09:04Z")
Hi, Im using Kibana 7.1.1, and I want to capture pdf or png of Kibana dashboard. Tried below code, but it is capturing blank page. ======Code starts ====== var page = require('webpage').create(), system = require('s… --- ## [ES SQL Query in Canvas Returning Unexpected Value](https://discuss.elastic.co/t/es-sql-query-in-canvas-returning-unexpected-value/190841)
**Author:** [@thegrockq](https://discuss.elastic.co/u/thegrockq)\ **Replies:** 7\ **Last updated:** [July 24, 2019, 5:03pm UTC](https://discuss.elastic.co/t/es-sql-query-in-canvas-returning-unexpected-value/190841 "2019-07-24T17:03:40Z")
I'm attempting to calculate the sum of disk space used by specific log types and present them in a metric element in Canvas. For example, Winlogbeat: 3.8 TB, DNS: 2.8 TB, etc. I've written a SQL query that returns the e… --- ## [Kibana Index Patterns](https://discuss.elastic.co/t/kibana-index-patterns/191975)
**Author:** [@Aleix\_Abrie\_Prat](https://discuss.elastic.co/u/Aleix_Abrie_Prat)\ **Replies:** 2\ **Last updated:** [July 24, 2019, 4:26pm UTC](https://discuss.elastic.co/t/kibana-index-patterns/191975 "2019-07-24T16:26:12Z")
Hello Everybody, I have a question that I have not found anywhere. I have in kibana an index pattern with a wildcard to take information from more than 1 index in elasticsearch. If I add one more index in elasticsearch,… --- ## [Log file's timestamp instead of kibana default timestamp](https://discuss.elastic.co/t/log-files-timestamp-instead-of-kibana-default-timestamp/191990)
**Author:** [@Shree](https://discuss.elastic.co/u/Shree)\ **Replies:** 8\ **Last updated:** [July 24, 2019, 3:35pm UTC](https://discuss.elastic.co/t/log-files-timestamp-instead-of-kibana-default-timestamp/191990 "2019-07-24T15:35:22Z")
Hi, I am connecting elastic search with kibana without logstash (elk version 7.2). I want to put the timestamp of my log file's instead of when it parsed in kibana. Could someone help me to get the proper way to do it? … --- ## [Possible to show average number of messages across unique IDs?](https://discuss.elastic.co/t/possible-to-show-average-number-of-messages-across-unique-ids/191636)
**Author:** [@cgmelastic](https://discuss.elastic.co/u/cgmelastic)\ **Replies:** 3\ **Last updated:** [July 24, 2019, 2:42pm UTC](https://discuss.elastic.co/t/possible-to-show-average-number-of-messages-across-unique-ids/191636 "2019-07-24T14:42:15Z")
In our logging system, we have a unique ID tying together sets of operations, sort of like a "session" ID. I'm trying to show the average number of log messages per session. The closest I've gotten so far is using a sibl… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=631) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=633)