# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=850 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 851 --- ## [Help needed to create VISUALIZATION](https://discuss.elastic.co/t/help-needed-to-create-visualization/123934)
**Author:** [@chandukreddi](https://discuss.elastic.co/u/chandukreddi)\ **Replies:** 9\ **Last updated:** [March 21, 2018, 8:09pm UTC](https://discuss.elastic.co/t/help-needed-to-create-visualization/123934 "2018-03-21T20:09:53Z")
Hello Experts, I am trying to create Visualization for my Elasticsearch data using Kibana. My Grok Pattern: JAVALOGBACKTIMESTAMP %{YEAR}-%{MONTHNUM}-%{MONTHDAY} %{HOUR}:%{MINUTE}:%{SECOND},%{INT:msec} CASS\_BASE ^%{LO… --- ## [Monitor status of filebeats in Kibana](https://discuss.elastic.co/t/monitor-status-of-filebeats-in-kibana/125056)
**Author:** [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\ **Replies:** 4\ **Last updated:** [March 21, 2018, 7:21pm UTC](https://discuss.elastic.co/t/monitor-status-of-filebeats-in-kibana/125056 "2018-03-21T19:21:39Z")
I was at the Elasticon 2018 and I was told that the ability to monitor filebeats inside of Kibana was available in 6.2 just like we have it for elasticsearch, kibana & logstash. I am not seeing how to turn that on insid… --- ## [Is there a Kibana health API for load balancer?](https://discuss.elastic.co/t/is-there-a-kibana-health-api-for-load-balancer/124862)
**Author:** [@android.kc](https://discuss.elastic.co/u/android.kc)\ **Replies:** 3\ **Last updated:** [March 21, 2018, 5:54pm UTC](https://discuss.elastic.co/t/is-there-a-kibana-health-api-for-load-balancer/124862 "2018-03-21T17:54:33Z")
Tried the following URL https://localhost:5601/\[token\]/api/status on 5.5.2 which works fine and returned the health information. However, the is changed every time after restarting kibana instances. Is there a way to h… --- ## [Is tilemap not available in Kibana 6.\* version? I don't see in my visualizations](https://discuss.elastic.co/t/is-tilemap-not-available-in-kibana-6-version-i-dont-see-in-my-visualizations/123963)
**Author:** [@jason\_smith](https://discuss.elastic.co/u/jason_smith)\ **Replies:** 3\ **Last updated:** [March 21, 2018, 5:04pm UTC](https://discuss.elastic.co/t/is-tilemap-not-available-in-kibana-6-version-i-dont-see-in-my-visualizations/123963 "2018-03-21T17:04:18Z")
Is tilemap not available in Kibana 6.\* version? I don't see in my visualizations --- ## [Line chart from field values](https://discuss.elastic.co/t/line-chart-from-field-values/124913)
**Author:** [@Makra](https://discuss.elastic.co/u/Makra)\ **Replies:** 3\ **Last updated:** [March 21, 2018, 4:09pm UTC](https://discuss.elastic.co/t/line-chart-from-field-values/124913 "2018-03-21T16:09:25Z")
Hi Is it possible to draw line chart from field values ? I want to plot following two fields - error:1, time: 17/11/13-13:28:21.247 error:0, time: 18/11/13-13:28:21.247 error:1, time: 19/11/13-13:28:21.247 error:0, … --- ## [How to make a table report by grouped aggregation count?](https://discuss.elastic.co/t/how-to-make-a-table-report-by-grouped-aggregation-count/124977)
**Author:** [@kora](https://discuss.elastic.co/u/kora)\ **Replies:** 3\ **Last updated:** [March 21, 2018, 1:40pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-report-by-grouped-aggregation-count/124977 "2018-03-21T13:40:26Z")
Hi all. This seems similar as How to make histogram by grouped aggregation count? to me that is nicely answered by @timroes. I have a data that I think has the same structure, although no integers here: { "action": "… --- ## [How to separate Machine Learning jobs in Kibana per user](https://discuss.elastic.co/t/how-to-separate-machine-learning-jobs-in-kibana-per-user/124756)
**Author:** [@vakhtang](https://discuss.elastic.co/u/vakhtang)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 10:39pm UTC](https://discuss.elastic.co/t/how-to-separate-machine-learning-jobs-in-kibana-per-user/124756 "2018-03-20T22:39:41Z")
Hello, I try to provide for the customers dedicated dashboards (User can see only his own dashboards). So, as workaround i installed two Kibana instances with different .kibana indices. Now the user could see his search… --- ## [Issue with plotting daily field values](https://discuss.elastic.co/t/issue-with-plotting-daily-field-values/124777)
**Author:** [@simonetthomas](https://discuss.elastic.co/u/simonetthomas)\ **Replies:** 6\ **Last updated:** [March 21, 2018, 11:12am UTC](https://discuss.elastic.co/t/issue-with-plotting-daily-field-values/124777 "2018-03-21T11:12:50Z")
Hi everyone, I'm relatively new to ES and Kibana. I'm currently searching how to plot field values, wich consists of a float value (y-axis), corresponding to a time (x-axis). As I understand it, it's not possible to do … --- ## [Nested Objects aggregations](https://discuss.elastic.co/t/nested-objects-aggregations/124957)
**Author:** [@yzaretskyy](https://discuss.elastic.co/u/yzaretskyy)\ **Replies:** 2\ **Last updated:** [March 21, 2018, 10:50am UTC](https://discuss.elastic.co/t/nested-objects-aggregations/124957 "2018-03-21T10:50:10Z")
Hi all, I'm looking for ability of using nested fields in aggregations, but Kibana does not support it. Is there are some natural way to add some interceptor or so, to be able to modify/build JSON before sending request… --- ## [Kibana 6 and ElasticSearch 2](https://discuss.elastic.co/t/kibana-6-and-elasticsearch-2/124961)
**Author:** [@boeledi01](https://discuss.elastic.co/u/boeledi01)\ **Replies:** 2\ **Last updated:** [March 21, 2018, 10:26am UTC](https://discuss.elastic.co/t/kibana-6-and-elasticsearch-2/124961 "2018-03-21T10:26:40Z")
Hi, We are running version 2.x of ElasticSearch in our production environment. We are currently in the process of migrating everything to version 6.2+. Meanwhile, we have an urgent need to perform live queries against… --- ## [ERROR in ./optimize/bundles/guard-idcs.entry.js](https://discuss.elastic.co/t/error-in-optimize-bundles-guard-idcs-entry-js/124946)
**Author:** [@ahrtr](https://discuss.elastic.co/u/ahrtr)\ **Replies:** 1\ **Last updated:** [March 21, 2018, 9:46am UTC](https://discuss.elastic.co/t/error-in-optimize-bundles-guard-idcs-entry-js/124946 "2018-03-21T09:46:52Z")
I just generated a new plugin using template-kibana-plugin/ against kibana 6.2, and then saw the following error when accessing http://IP:5601. optmzr log \[09:33:51.859\] \[fatal\]\[optimize\] Optimization failed in 96.… --- ## [How to display Column Data as headers (Transpose Data Table)](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738)
**Author:** [@sahadevgd](https://discuss.elastic.co/u/sahadevgd)\ **Replies:** 2\ **Last updated:** [March 21, 2018, 9:13am UTC](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738 "2018-03-21T09:13:17Z")
Hi Team, I'm working on Kibana 6.0. I'm feeding data via logstash and my data is in csv format. My Data: Time,Status,ServiceName 2018-03-15 15:30,Up,FETCH 2018-03-15 15:30,Up,UPDATE 2018-03-15 15:30,Up,DELETE 2018… --- ## [Region Map does not show](https://discuss.elastic.co/t/region-map-does-not-show/124447)
**Author:** [@BicaLuv](https://discuss.elastic.co/u/BicaLuv)\ **Replies:** 11\ **Last updated:** [March 20, 2018, 7:23pm UTC](https://discuss.elastic.co/t/region-map-does-not-show/124447 "2018-03-20T19:23:23Z")
Hi! I'm playing with my own German region maps. I got a geojson file with the following format: {"type":"FeatureCollection","features":\[ {"type":"Feature","geometry":{"type":"Polygon","coordinates":\[\[\[...\]\]\]},"proper… --- ## [Looking for Freelancer](https://discuss.elastic.co/t/looking-for-freelancer/124622)
**Author:** [@brunstar](https://discuss.elastic.co/u/brunstar)\ **Replies:** 1\ **Last updated:** [March 20, 2018, 11:00pm UTC](https://discuss.elastic.co/t/looking-for-freelancer/124622 "2018-03-20T23:00:08Z")
Hi we are running up against a deadline and looking for freelancer that can help us create some reports using Kibana. We have it set up but need someone who can help with the format/ visualizations of the report. Would … --- ## [How to generate Kibana pie chart for mentioned logs](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309)
**Author:** [@suripaleru](https://discuss.elastic.co/u/suripaleru)\ **Replies:** 5\ **Last updated:** [March 20, 2018, 5:58pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309 "2018-03-20T17:58:31Z")
log row one: {"ORDER\_TYPE":"New","COUNT\_ROWS":"4"} log row two: {"ORDER\_TYPE":"Change","COUNT\_ROWS":"10"} log row two: {"ORDER\_TYPE":"Delete","COUNT\_ROWS":"50"} I want to view above data in Pie like each section to be… --- ## [Dashboard : display the sum of several counts](https://discuss.elastic.co/t/dashboard-display-the-sum-of-several-counts/123883)
**Author:** [@Florent\_Fauvin](https://discuss.elastic.co/u/Florent_Fauvin)\ **Replies:** 4\ **Last updated:** [March 20, 2018, 5:27pm UTC](https://discuss.elastic.co/t/dashboard-display-the-sum-of-several-counts/123883 "2018-03-20T17:27:28Z")
Hello, I would like to display in my dashboard the sum of several counts. For example, today, my search returns the authentication errors for SSH : result: "authentication failure" =\> count:3 result: "Authentication … --- ## [Installing Kibana from apt and fails to start](https://discuss.elastic.co/t/installing-kibana-from-apt-and-fails-to-start/124251)
**Author:** [@sbu](https://discuss.elastic.co/u/sbu)\ **Replies:** 3\ **Last updated:** [March 20, 2018, 5:26pm UTC](https://discuss.elastic.co/t/installing-kibana-from-apt-and-fails-to-start/124251 "2018-03-20T17:26:25Z")
Hi, We're installing and starting Kibana, using the instructions here :- https://www.elastic.co/guide/en/kibana/current/deb.html#deb-repo However, it refuses to start as the kibana user. I would have expected this jus… --- ## [Trendline with visual builder?](https://discuss.elastic.co/t/trendline-with-visual-builder/124808)
**Author:** [@michimau](https://discuss.elastic.co/u/michimau)\ **Replies:** 1\ **Last updated:** [March 20, 2018, 4:08pm UTC](https://discuss.elastic.co/t/trendline-with-visual-builder/124808 "2018-03-20T16:08:09Z")
Is there a way to compute a linear trend line with visual builder? example best! @michimau --- ## [Add line series circle radius](https://discuss.elastic.co/t/add-line-series-circle-radius/124700)
**Author:** [@fxprunayre](https://discuss.elastic.co/u/fxprunayre)\ **Replies:** 3\ **Last updated:** [March 20, 2018, 3:57pm UTC](https://discuss.elastic.co/t/add-line-series-circle-radius/124700 "2018-03-20T15:57:13Z")
Currently, line series can display or not circles and the radius of the circle is defined by the following https://github.com/elastic/kibana/blob/master/src/ui/public/vislib/visualizations/point\_series/line\_chart.js#L94-… --- ## [Discovery, sort by timestamp and then field (int)](https://discuss.elastic.co/t/discovery-sort-by-timestamp-and-then-field-int/124770)
**Author:** [@elvarb](https://discuss.elastic.co/u/elvarb)\ **Replies:** 4\ **Last updated:** [March 20, 2018, 2:41pm UTC](https://discuss.elastic.co/t/discovery-sort-by-timestamp-and-then-field-int/124770 "2018-03-20T14:41:56Z")
I have logs that come in that are only accurate down to a second. The logs are generated when different part of an application is run, so when a function is run it has a unique ID to group those messages together and th… --- ## [All fields are not listed under metric drop down](https://discuss.elastic.co/t/all-fields-are-not-listed-under-metric-drop-down/124789)
**Author:** [@suripaleru](https://discuss.elastic.co/u/suripaleru)\ **Replies:** 4\ **Last updated:** [March 20, 2018, 2:40pm UTC](https://discuss.elastic.co/t/all-fields-are-not-listed-under-metric-drop-down/124789 "2018-03-20T14:40:44Z")
I tried to generate pie chat but I could not see all the fields under Metric which I could see from split slices area. What could be the issue here ? --- ## [Query Array by Position](https://discuss.elastic.co/t/query-array-by-position/124765)
**Author:** [@cawoodm](https://discuss.elastic.co/u/cawoodm)\ **Replies:** 1\ **Last updated:** [March 20, 2018, 2:19pm UTC](https://discuss.elastic.co/t/query-array-by-position/124765 "2018-03-20T14:19:00Z")
We have a URL field split on / into a path array field. We now want to query documents in Kibana which have "something as their first element. The following query fails in Kibana: path\[0\]: something: \[image\] We do ho… --- ## [Kibana: Field collapsing and inner hits not working for visualizations](https://discuss.elastic.co/t/kibana-field-collapsing-and-inner-hits-not-working-for-visualizations/124743)
**Author:** [@fakenine](https://discuss.elastic.co/u/fakenine)\ **Replies:** 1\ **Last updated:** [March 20, 2018, 2:07pm UTC](https://discuss.elastic.co/t/kibana-field-collapsing-and-inner-hits-not-working-for-visualizations/124743 "2018-03-20T14:07:25Z")
Hello, In Kibana, I have created a search that returns the last status for each servers, using field collapsing and inner hits. { "query": { "match": { "event\_name": "server\_status" } }, "collapse":… --- ## [Change table font size visualize object](https://discuss.elastic.co/t/change-table-font-size-visualize-object/124528)
**Author:** [@elk2](https://discuss.elastic.co/u/elk2)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 1:44pm UTC](https://discuss.elastic.co/t/change-table-font-size-visualize-object/124528 "2018-03-20T13:44:36Z")
I would like to change font size on visulize object. How can I do this? { "aggs": \[ { "id": "1", "schema": "metric", "type": "count" }, { "id": "2", "params": { "field": "home", "order": "desc", "orderBy": "… --- ## [Dev tools error](https://discuss.elastic.co/t/dev-tools-error/124484)
**Author:** [@Kamal\_Raj](https://discuss.elastic.co/u/Kamal_Raj)\ **Replies:** 17\ **Last updated:** [March 20, 2018, 1:38pm UTC](https://discuss.elastic.co/t/dev-tools-error/124484 "2018-03-20T13:38:24Z")
When trying to execute GET /\_search { "query": { "match\_all": {} } } Getting error Failed to connect to Console's backend. Please check the Kibana server is up and running Confirmed that my Kibana server is up … --- ## [Can't get a field from the ctx.payload in Kibana watcher](https://discuss.elastic.co/t/cant-get-a-field-from-the-ctx-payload-in-kibana-watcher/124481)
**Author:** [@Preetiv](https://discuss.elastic.co/u/Preetiv)\ **Replies:** 4\ **Last updated:** [March 20, 2018, 1:11pm UTC](https://discuss.elastic.co/t/cant-get-a-field-from-the-ctx-payload-in-kibana-watcher/124481 "2018-03-20T13:11:28Z")
I am setting up a watcher in Kibana and the watcher needs to extract different fields from the ctx.payload. So I tried this for extracting message field from the first hit {{ctx.payload.hits.hits.0.\_source.message}} T… --- ## [Quick Count - Top 5 Values based on documents in the table](https://discuss.elastic.co/t/quick-count-top-5-values-based-on-documents-in-the-table/124762)
**Author:** [@suchand](https://discuss.elastic.co/u/suchand)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 12:58pm UTC](https://discuss.elastic.co/t/quick-count-top-5-values-based-on-documents-in-the-table/124762 "2018-03-20T12:58:16Z")
Hi, @timroes Thank you. Is there any option to show top 10 Values based on the documents in the table. In this same place which showing in the image \[image\] --- ## [How to make histogram by grouped aggregation count?](https://discuss.elastic.co/t/how-to-make-histogram-by-grouped-aggregation-count/124709)
**Author:** [@Artur\_Zhdanov](https://discuss.elastic.co/u/Artur_Zhdanov)\ **Replies:** 11\ **Last updated:** [March 20, 2018, 12:13pm UTC](https://discuss.elastic.co/t/how-to-make-histogram-by-grouped-aggregation-count/124709 "2018-03-20T12:13:33Z")
Hello, I have some events, which user did. /events: {"type":"register", "user.id":"1", "event.id": "1"} {"type":"register", "user.id":"1", "event.id": "2"} {"type":"register", "user.id":"1", "event.id": "3"} {"type… --- ## [Vertical Barchart: Perform Subcalculations and aggregate them](https://discuss.elastic.co/t/vertical-barchart-perform-subcalculations-and-aggregate-them/124720)
**Author:** [@nEihTfool2](https://discuss.elastic.co/u/nEihTfool2)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 12:07pm UTC](https://discuss.elastic.co/t/vertical-barchart-perform-subcalculations-and-aggregate-them/124720 "2018-03-20T12:07:05Z")
Hello, I have a data set of orders which look like this: Customer; Bought Item; Price (of Item); Revenue of Basket; BasketID; Date of Purchase And I want to display in a vertical barchart, how many customers are in sp… --- ## [Plot cum sum metric](https://discuss.elastic.co/t/plot-cum-sum-metric/124730)
**Author:** [@eirc](https://discuss.elastic.co/u/eirc)\ **Replies:** 1\ **Last updated:** [March 20, 2018, 12:05pm UTC](https://discuss.elastic.co/t/plot-cum-sum-metric/124730 "2018-03-20T12:05:37Z")
Hello, I recently setup metricbeat to monitor various metrics over various hosts and I find it very tricky to plot metrics that come in a cumulative sum form like network bytes in any of the visualization options. I ca… [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=849) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=851)