# Kibana **URL:** https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=518 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 519 --- ## [Query does not find an existent register](https://discuss.elastic.co/t/query-does-not-find-an-existent-register/224456)
**Author:** [@Claudio\_Ract\_Costa](https://discuss.elastic.co/u/Claudio_Ract_Costa)\ **Replies:** 4\ **Last updated:** [March 24, 2020, 8:20pm UTC](https://discuss.elastic.co/t/query-does-not-find-an-existent-register/224456 "2020-03-24T20:20:53Z")
Hi Guys, I am trying to execute a query in Kibana but it does not find any register. Does anyone can help me to figure out what i am doing wrong ? Query used (not working): http.request.body.content:\*CONTR00202460… --- ## [Octagon Analytics - Native iOS Mobile App for Kibana](https://discuss.elastic.co/t/octagon-analytics-native-ios-mobile-app-for-kibana/223868)
**Author:** [@octagon.mobile](https://discuss.elastic.co/u/octagon.mobile)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 7:58pm UTC](https://discuss.elastic.co/t/octagon-analytics-native-ios-mobile-app-for-kibana/223868 "2020-03-24T19:58:48Z")
"Octagon Analytics" - Native iOS application for Kibana. AND it's an OPEN SOURCE project !!! You can find it over here. You can also download the demo project from the App Store. NOTE: To make this app compatible wit… --- ## [Percentage kibana](https://discuss.elastic.co/t/percentage-kibana/221868)
**Author:** [@rwr](https://discuss.elastic.co/u/rwr)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 7:56pm UTC](https://discuss.elastic.co/t/percentage-kibana/221868 "2020-03-24T19:56:25Z")
Hi all I have confused about map in kibana, because I have a case like this: let's say there are 5000 total of data let's say 500 row data is grouped by potential category I want to percentage it using this formula: (… --- ## [No custom color in Metric, Gauge, Goal](https://discuss.elastic.co/t/no-custom-color-in-metric-gauge-goal/220311)
**Author:** [@Angelos](https://discuss.elastic.co/u/Angelos)\ **Replies:** 3\ **Last updated:** [February 25, 2020, 7:41pm UTC](https://discuss.elastic.co/t/no-custom-color-in-metric-gauge-goal/220311 "2020-02-25T19:41:20Z")
Hello, I saw here that in 5.5 there was custom color but I cannot see that option. We are using 7.4 Platinum. There is only a fixed Color Schema. In addition I saw that there is this option in TSVB but in our case we d… --- ## [Calculate the time that passed between the insertion of one record and another](https://discuss.elastic.co/t/calculate-the-time-that-passed-between-the-insertion-of-one-record-and-another/221334)
**Author:** [@yorman\_steven\_ladino](https://discuss.elastic.co/u/yorman_steven_ladino)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 7:33pm UTC](https://discuss.elastic.co/t/calculate-the-time-that-passed-between-the-insertion-of-one-record-and-another/221334 "2020-03-24T19:33:22Z")
Hi, I need your help. I need to calculate the time that passed between the insertion of one record and another. Example I insert a record that tells me the creation of a shift, and after x time I enter a new record wi… --- ## [Filter out results from aggregation based on info from multiple documents](https://discuss.elastic.co/t/filter-out-results-from-aggregation-based-on-info-from-multiple-documents/221356)
**Author:** [@SiriKeet](https://discuss.elastic.co/u/SiriKeet)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 7:08pm UTC](https://discuss.elastic.co/t/filter-out-results-from-aggregation-based-on-info-from-multiple-documents/221356 "2020-03-24T19:08:33Z")
Hi, Here's a simple version of what I'm trying to do: I have a bunch of documents with fields 'id' and 'status'. There can be many documents with the same 'id' value. The value of 'status' can either be 'success' or 'f… --- ## [Filter on metric of visualization using Kibana 6.7](https://discuss.elastic.co/t/filter-on-metric-of-visualization-using-kibana-6-7/221780)
**Author:** [@dooger21](https://discuss.elastic.co/u/dooger21)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 6:31pm UTC](https://discuss.elastic.co/t/filter-on-metric-of-visualization-using-kibana-6-7/221780 "2020-03-24T18:31:24Z")
Hi fiends, It is possible to add a condition on the visualization metric, that is, only the bars whose value is greater than 1? As shown in the image the 'count' is used as the metric and for the X axis a grouping colu… --- ## [How to install Extended Metric Plugin in version 7.6.1](https://discuss.elastic.co/t/how-to-install-extended-metric-plugin-in-version-7-6-1/224756)
**Author:** [@Yungyoung\_Ok](https://discuss.elastic.co/u/Yungyoung_Ok)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 1:56pm UTC](https://discuss.elastic.co/t/how-to-install-extended-metric-plugin-in-version-7-6-1/224756 "2020-03-24T13:56:49Z")
I downloaded it as a 'zip' file from git to install the plugin. After that, I opened package.json and modified kibana version to 7.6.1. And the following command was executed by compressing the plugin file back into a … --- ## [Sankey Flow Chart in Kibana](https://discuss.elastic.co/t/sankey-flow-chart-in-kibana/224549)
**Author:** [@Sajal](https://discuss.elastic.co/u/Sajal)\ **Replies:** 6\ **Last updated:** [March 24, 2020, 1:16pm UTC](https://discuss.elastic.co/t/sankey-flow-chart-in-kibana/224549 "2020-03-24T13:16:51Z")
Hi All, Can anyone help me in understanding Sankey diagram in Kibana ? Thanks Sajal --- ## [Format numbers with color and decimal places in metric aggregation](https://discuss.elastic.co/t/format-numbers-with-color-and-decimal-places-in-metric-aggregation/221703)
**Author:** [@mtudisco](https://discuss.elastic.co/u/mtudisco)\ **Replies:** 2\ **Last updated:** [March 24, 2020, 12:58pm UTC](https://discuss.elastic.co/t/format-numbers-with-color-and-decimal-places-in-metric-aggregation/221703 "2020-03-24T12:58:16Z")
Hi, I have a metric that i sotore with 2 decimal places, it is a number between 0 and 100 representing a percentage. Then i have a table visualization in kibana showing that number with the top hit aggregation. I want t… --- ## [Does Kibana dashboard inherits filters from visualization?](https://discuss.elastic.co/t/does-kibana-dashboard-inherits-filters-from-visualization/224751)
**Author:** [@ElasticLiver](https://discuss.elastic.co/u/ElasticLiver)\ **Replies:** 2\ **Last updated:** [March 24, 2020, 12:40pm UTC](https://discuss.elastic.co/t/does-kibana-dashboard-inherits-filters-from-visualization/224751 "2020-03-24T12:40:11Z")
I have filter by hostgroup in my visualization, and seems that dashboard inherits this filter, but when I press filters in dahboard, Im still habe the posibility to change the hostgroup. this will override my previous f… --- ## [Kibana json input filter](https://discuss.elastic.co/t/kibana-json-input-filter/224812)
**Author:** [@Mohammad\_Mousavi](https://discuss.elastic.co/u/Mohammad_Mousavi)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 11:27am UTC](https://discuss.elastic.co/t/kibana-json-input-filter/224812 "2020-03-24T11:27:22Z")
Hi, I wanna create vertical bar chart with 2 bars. Both of them are sum of one field (Duration) but based on a condition on another field. one bar is sum of duration when and another when now I think I should add… --- ## [Canvas report - Remove border](https://discuss.elastic.co/t/canvas-report-remove-border/224791)
**Author:** [@KevSex](https://discuss.elastic.co/u/KevSex)\ **Replies:** 1\ **Last updated:** [March 24, 2020, 11:12am UTC](https://discuss.elastic.co/t/canvas-report-remove-border/224791 "2020-03-24T11:12:50Z")
Hi, Is there any way to remove the border that is added when a Canvas is exported to PDF format? Cheers! --- ## [Fix header of table visualisation in kibana](https://discuss.elastic.co/t/fix-header-of-table-visualisation-in-kibana/224596)
**Author:** [@Kundan\_Singh](https://discuss.elastic.co/u/Kundan_Singh)\ **Replies:** 3\ **Last updated:** [March 24, 2020, 10:11am UTC](https://discuss.elastic.co/t/fix-header-of-table-visualisation-in-kibana/224596 "2020-03-24T10:11:08Z")
How I can fix header of a table visualization in kibana(7.2) https://github.com/elastic/kibana/blob/7.2/src/legacy/core\_plugins/kibana/public/discover/doc\_table/components/table\_header.html --- ## [Kibana Visual Builder - Color Rules is not working properly](https://discuss.elastic.co/t/kibana-visual-builder-color-rules-is-not-working-properly/224593)
**Author:** [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Replies:** 3\ **Last updated:** [March 24, 2020, 10:08am UTC](https://discuss.elastic.co/t/kibana-visual-builder-color-rules-is-not-working-properly/224593 "2020-03-24T10:08:38Z")
Hi Team, I am using Visual Builder to present data in table format , i tried setting color rule to the metrics which i am showing in table. When i try to set condition and select and release mouse condition is not getti… --- ## [Iterate over array in Kibana](https://discuss.elastic.co/t/iterate-over-array-in-kibana/224638)
**Author:** [@SBH](https://discuss.elastic.co/u/SBH)\ **Replies:** 4\ **Last updated:** [March 24, 2020, 9:13am UTC](https://discuss.elastic.co/t/iterate-over-array-in-kibana/224638 "2020-03-24T09:13:43Z")
Hi I have 3 docs as shown below. It contains the tasks array. I want to have a hit fx in a count for each time the status for the task i fx started. When i search for this in Discover: tasks.status.keyword : "Started" … --- ## [Canvas and cumulative sum](https://discuss.elastic.co/t/canvas-and-cumulative-sum/224685)
**Author:** [@PaulSPG](https://discuss.elastic.co/u/PaulSPG)\ **Replies:** 3\ **Last updated:** [March 24, 2020, 8:29am UTC](https://discuss.elastic.co/t/canvas-and-cumulative-sum/224685 "2020-03-24T08:29:56Z")
Would it be possible to calculate the cumulative sum of a column using f.i. mapColumn. For example the price column of demodata. Something like: filters | demodata | mapColumn "CuSum Price" fn={math 'sum(price + CuSu… --- ## [Kibana - Metric Visualization - Can we present very lengthy numbers in short](https://discuss.elastic.co/t/kibana-metric-visualization-can-we-present-very-lengthy-numbers-in-short/224659)
**Author:** [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Replies:** 2\ **Last updated:** [March 24, 2020, 8:01am UTC](https://discuss.elastic.co/t/kibana-metric-visualization-can-we-present-very-lengthy-numbers-in-short/224659 "2020-03-24T08:01:43Z")
Hi Team, We have used Metric Visualization to present different set of data in the form of Metrics , sometimes the data count will be too much and it leads to 7 ,8,9 digits. Sometimes for an user it will be difficult t… --- ## [\[illegal\_argument\_exception\] unknown type for collapse field \`cluster\_uuid\`, only keywords and numbers are accepted: Check the Elasticsearch Monitoring cluster network connection or the load level of the nodes](https://discuss.elastic.co/t/illegal-argument-exception-unknown-type-for-collapse-field-cluster-uuid-only-keywords-and-numbers-are-accepted-check-the-elasticsearch-monitoring-cluster-network-connection-or-the-load-level-of-the-nodes/224575)
**Author:** [@gururjrk](https://discuss.elastic.co/u/gururjrk)\ **Replies:** 5\ **Last updated:** [March 24, 2020, 5:46am UTC](https://discuss.elastic.co/t/illegal-argument-exception-unknown-type-for-collapse-field-cluster-uuid-only-keywords-and-numbers-are-accepted-check-the-elasticsearch-monitoring-cluster-network-connection-or-the-load-level-of-the-nodes/224575 "2020-03-24T05:46:29Z")
In Kibana when I click on Monitoring getting error \[illegal\_argument\_exception\] unknown type for collapse field cluster\_uuid, only keywords and numbers are accepted: Check the Elasticsearch Monitoring cluster network c… --- ## [Mapping vars](https://discuss.elastic.co/t/mapping-vars/224495)
**Author:** [@edkash](https://discuss.elastic.co/u/edkash)\ **Replies:** 2\ **Last updated:** [March 23, 2020, 10:47pm UTC](https://discuss.elastic.co/t/mapping-vars/224495 "2020-03-23T22:47:37Z")
hello dear, I want to know, how better way to create mapping when I need to view my agent version follow your counts. I inser with post this logs in to variables: category: 2.34.212, agent\_count: 480 mapping: … --- ## [How to use the script field for string](https://discuss.elastic.co/t/how-to-use-the-script-field-for-string/224155)
**Author:** [@somya](https://discuss.elastic.co/u/somya)\ **Replies:** 8\ **Last updated:** [March 23, 2020, 9:48pm UTC](https://discuss.elastic.co/t/how-to-use-the-script-field-for-string/224155 "2020-03-23T21:48:49Z")
I have a message index pattern which has the below string \[INFO\]\[callback\]\[views\]\[2020-03-18 13:06:21\]\[xce\_web\]\[PROD\]\[user\_\_id\_1010510-18-03-2020-13-03-26\]\[167\]:For ABC start time is 2020-03-18 13:03:26.999778 & end tim… --- ## [Canvas: visualize with two different fields within the same index](https://discuss.elastic.co/t/canvas-visualize-with-two-different-fields-within-the-same-index/224689)
**Author:** [@emad101](https://discuss.elastic.co/u/emad101)\ **Replies:** 2\ **Last updated:** [March 23, 2020, 8:53pm UTC](https://discuss.elastic.co/t/canvas-visualize-with-two-different-fields-within-the-same-index/224689 "2020-03-23T20:53:06Z")
Hello, I am trying to make a bar chart in Canvas with two fields. I want the Y-axis to have the unique count on 'filed A' and the X-axis to display the top six names in 'field B' that has the most unique count in 'field… --- ## [Positive flow rate over time for tank level](https://discuss.elastic.co/t/positive-flow-rate-over-time-for-tank-level/224463)
**Author:** [@thoth](https://discuss.elastic.co/u/thoth)\ **Replies:** 7\ **Last updated:** [March 23, 2020, 7:23pm UTC](https://discuss.elastic.co/t/positive-flow-rate-over-time-for-tank-level/224463 "2020-03-23T19:23:52Z")
I have a 'level' value for a tank coming in as a number, which is searchable and aggregatable. Is it possible for me to get a rate over time in which this level is increasing? As the tank nears full it is emptied and th… --- ## [License information could not be obtained from Elasticsearch](https://discuss.elastic.co/t/license-information-could-not-be-obtained-from-elasticsearch/224500)
**Author:** [@mathiznogoud](https://discuss.elastic.co/u/mathiznogoud)\ **Replies:** 4\ **Last updated:** [March 23, 2020, 7:12pm UTC](https://discuss.elastic.co/t/license-information-could-not-be-obtained-from-elasticsearch/224500 "2020-03-23T19:12:07Z")
Greetings, I've just set up ElasticSearch successfully. Later I install Kibana and I encountered this error, the Kibana doesn't go online. I'm using ElasticSearch 7.5.1 with Kibana 7.5.1. I setup both on my virtual Ce… --- ## [How do you create a 2 series vega chart from 2 not nested aggregations](https://discuss.elastic.co/t/how-do-you-create-a-2-series-vega-chart-from-2-not-nested-aggregations/222347)
**Author:** [@TealFawn](https://discuss.elastic.co/u/TealFawn)\ **Replies:** 2\ **Last updated:** [March 23, 2020, 6:03pm UTC](https://discuss.elastic.co/t/how-do-you-create-a-2-series-vega-chart-from-2-not-nested-aggregations/222347 "2020-03-23T18:03:25Z")
I'm trying to create a 2 series vega chart from the following sample response. I have 2 date\_histogram aggregations and I want to plot the doc count for each month. Should I be using a format/transform on the data or sho… --- ## [Using REST API in Curl Command](https://discuss.elastic.co/t/using-rest-api-in-curl-command/224412)
**Author:** [@deep\_dba](https://discuss.elastic.co/u/deep_dba)\ **Replies:** 3\ **Last updated:** [March 23, 2020, 5:14pm UTC](https://discuss.elastic.co/t/using-rest-api-in-curl-command/224412 "2020-03-23T17:14:24Z")
Hello Team, We are trying to curl rest api to update password for admin user and also get roles but it is not giving any result. Can you please if syntex is right. Below is the url we are using url https://hostname:/a… --- ## [Setting tdigest compression for percentile aggregations in visualisations \[Kibana 6.5\]](https://discuss.elastic.co/t/setting-tdigest-compression-for-percentile-aggregations-in-visualisations-kibana-6-5/224661)
**Author:** [@imacpherson](https://discuss.elastic.co/u/imacpherson)\ **Replies:** 3\ **Last updated:** [March 23, 2020, 5:00pm UTC](https://discuss.elastic.co/t/setting-tdigest-compression-for-percentile-aggregations-in-visualisations-kibana-6-5/224661 "2020-03-23T17:00:54Z")
Hi there, I'm running Kibana 6.5 and I have a data table visualisation where I'm showing the 95th percentile of a field, however the value is too inconsistent due to the approximation calculation for percentiles. I've s… --- ## [Convert Number to String Kibana JSON Input](https://discuss.elastic.co/t/convert-number-to-string-kibana-json-input/221297)
**Author:** [@Yasir](https://discuss.elastic.co/u/Yasir)\ **Replies:** 1\ **Last updated:** [March 23, 2020, 4:02pm UTC](https://discuss.elastic.co/t/convert-number-to-string-kibana-json-input/221297 "2020-03-23T16:02:24Z")
Hello, I am trying to use translate in the JSON INPUT to convert ItemValue 0 to Test/String Healthy I have been trying to use painless in the JSON Input but for some reason it doesnt work. Not too familiar with Pain… --- ## [Visualizing a user burndown graph](https://discuss.elastic.co/t/visualizing-a-user-burndown-graph/224276)
**Author:** [@ethranes](https://discuss.elastic.co/u/ethranes)\ **Replies:** 4\ **Last updated:** [March 23, 2020, 3:10pm UTC](https://discuss.elastic.co/t/visualizing-a-user-burndown-graph/224276 "2020-03-23T15:10:53Z")
Hi, I have saved a document into elasticsearch, which has an array of users which include how many hours of work they have remaining, and I'm trying to show this as a bar chart in Kibana. The JSON I've entered looks li… --- ## [How to select the top groups based on the relative occurence of a value in another variable](https://discuss.elastic.co/t/how-to-select-the-top-groups-based-on-the-relative-occurence-of-a-value-in-another-variable/223087)
**Author:** [@Amon](https://discuss.elastic.co/u/Amon)\ **Replies:** 3\ **Last updated:** [March 23, 2020, 3:27pm UTC](https://discuss.elastic.co/t/how-to-select-the-top-groups-based-on-the-relative-occurence-of-a-value-in-another-variable/223087 "2020-03-23T15:27:19Z")
Dear, Two variables in my dataset are important for this question namely : "Country\_code" and "Tunnel\_status". See example Country\_Code Tunnel\_status BE Up NL Up FR … [Previous page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=517) [Next page](https://discuss.elastic.co/c/elastic-stack/kibana/7.md?page=519)