# Percentage Metric outside of Visual Builder **URL:** https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484 **Category:** Kibana **Created:** [January 9, 2020, 8:04pm UTC](https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484 "2020-01-09T20:04:10Z") **Posts on this page:** 5 **Page:** 1
### Author: ![SpinDORK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spindork/32/45310_2.png) [@SpinDORK](https://discuss.elastic.co/u/SpinDORK) #### Post date: [January 9, 2020, 8:04pm UTC](https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484/1 "2020-01-09T20:04:11Z")
Hi, Will we ever get an easy to use Percentage tool for the Metric Visualisation and not simply the Visualisation Builder as this does not accurately show data over multiple years as we can only select the most recent d, w or y. This feature has been requested countless times on the Elastic Github, is there any reason why the developers cannot deliver this feature or is it in the works? Thanks, Steve ---
### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie) #### Post date: [January 9, 2020, 8:41pm UTC](https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484/2 "2020-01-09T20:41:25Z")
Hi, I work on visualizations in Kibana, and recently wrote a post about places we do support showing percents. TSVB is my recommendation for now, as you have seen: [https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations](https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations) We do have reasons for not shipping a percent interface for every visualization. The biggest issue is an interface one: users need to select the _type of percent_ that they are showing, and there's at least these options: - The number represents a percent already, such as CPU % - For a single metric without a split, you need to divide A / B- what's B? Is it another query? - For a metric that's split, you need to divide each metric (A1, A2, A3) / B- is B the subtotal of A1+A2+A3, or is it another number entirely? There's fewer requests than you might think for this too- here are the ones I can find: > > > Right now I tend to create a lot of pie charts to show the percentages of different buckets. Some times having... > > > I'd like to create a percentage histogram (distribution) visualization in Kibana. > Each document has a 'DurationInSeconds' field and I can create a... > > > Describe the feature: > In TSVB visualization, there is a very useful aggregation named "Filter Ratio", where we can get the ratio between... > > > Right now params.\_all.\.values seems to only access each split's previous values in the buckets. In order to create a percentage column... ---
### Author: ![SpinDORK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spindork/32/45310_2.png) [@SpinDORK](https://discuss.elastic.co/u/SpinDORK) #### Post date: [January 10, 2020, 10:17am UTC](https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484/3 "2020-01-10T10:17:53Z")
Hi Wylie thanks for your reply. I want to build this outside of the TSVB due to the limitation with bucket use, the gauges won't load 2019 and 2020 data together and that's not a true representation so we cannot use it. The approach we need is (A1, A2, A3) / 100 which requires the use of Filter Ratio as explained in this discussion you linked; [https://github.com/elastic/kibana/issues/20515](https://github.com/elastic/kibana/issues/20515) If Filter Ratio was available outside TSVB, this would be a doddle. Thanks, Steve ---
### Author: ![SpinDORK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spindork/32/45310_2.png) [@SpinDORK](https://discuss.elastic.co/u/SpinDORK) #### Post date: [January 13, 2020, 3:27pm UTC](https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484/4 "2020-01-13T15:27:14Z")
@wylie TSVB has been updated in 7.4.0 with "Date timerange mode" so my request to include true percentage's outside of Visual Builder becomes redundant I think as I prefer to use TSVB as opposed to the standalone Metric builder, see; [Dashboard not showing multi-year data](https://discuss.elastic.co/t/dashboard-not-showing-multi-year-data/214404/5) Thanks very much for your reply, Steve ---
### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system) #### Post date: [February 10, 2020, 3:39pm UTC](https://discuss.elastic.co/t/percentage-metric-outside-of-visual-builder/214484/5 "2020-02-10T15:39:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.