# Kibana visualization to calculate percentage **URL:** \ **Category:** Kibana\ **Created:** [July 13, 2021, 2:06pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553 "2021-07-13T14:06:10Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![prabhakar\_talari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhakar_talari/32/46469_2.png) [@prabhakar\_talari](https://discuss.elastic.co/u/prabhakar_talari)\ **Post date:** [July 13, 2021, 2:06pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/1 "2021-07-13T14:06:10Z")
All, I am trying to calculate percentage based on hits with filter query for example index=test and status=disconnected - disconnected\_hits index=test total\_hits percentage = disconnected\_hits/total\_hits \* 100 from Metric visualization am trying to achieve this but not able to achieve Could some one help me the best ways to achieve this in Kibana Thanks, ---
**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:** [July 13, 2021, 2:18pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/2 "2021-07-13T14:18:13Z")
This is a complex calculation, and I think you might only be able to do this using TSVB or Vega in Kibana 7.13. Starting in Kibana 7.14, Lens will offer this feature too. TSVB has a feature called **Filter Ratio** which might work, and if that isn't powerful enough you have to use Vega. We have documentation about this, see the [descriptions of each editor in 7.13](https://www.elastic.co/guide/en/kibana/7.13/create-panels-with-editors.html) and [in 7.14](https://www.elastic.co/guide/en/kibana/7.14/create-panels-with-editors.html), as well as the [list of features in 7.13](https://www.elastic.co/guide/en/kibana/7.13/aggregation-reference.html#other-features) and [the list of features in 7.14](https://www.elastic.co/guide/en/kibana/7.14/aggregation-reference.html#other-features). ---
**Author:** ![prabhakar\_talari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhakar_talari/32/46469_2.png) [@prabhakar\_talari](https://discuss.elastic.co/u/prabhakar_talari)\ **Post date:** [July 13, 2021, 2:49pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/3 "2021-07-13T14:49:35Z")
Thank you for the details. am currently at 7.11.1 seems i need to upgrade to achieve this use case ---
**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:** [July 13, 2021, 4:21pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/4 "2021-07-13T16:21:45Z")
I don't think you need to upgrade- TSVB can probably handle this use case in your version, and if that doesn't work then Vega might work. Kibana 7.14 isn't released yet. ---
**Author:** ![prabhakar\_talari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhakar_talari/32/46469_2.png) [@prabhakar\_talari](https://discuss.elastic.co/u/prabhakar_talari)\ **Post date:** [July 13, 2021, 4:29pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/5 "2021-07-13T16:29:20Z")
> [@wylie](#): > > TSVB has a feature called **Filter Ratio** Yes, the % is working fine in TSVB but I didn't see any option to multiply output with 100. My current output is 0.998 but would like to display it as 99.8 only this am not able to achieve. am not much familiar with vega but will try Thank you for your suggestions Thanks, ---
**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:** [July 13, 2021, 4:32pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/6 "2021-07-13T16:32:53Z")
You can choose to use the Percent formatter in TSVB. ---
**Author:** ![prabhakar\_talari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhakar_talari/32/46469_2.png) [@prabhakar\_talari](https://discuss.elastic.co/u/prabhakar_talari)\ **Post date:** [July 13, 2021, 4:44pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/7 "2021-07-13T16:44:44Z")
Thank you .. now I have created dashboard with exact requirement. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 10, 2021, 4:45pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-calculate-percentage/278553/8 "2021-08-10T16:45:20Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.