# How to create a Visualization with %

**URL:** <https://discuss.elastic.co/t/how-to-create-a-visualization-with/225259>\
**Category:** Kibana\
**Created:** [March 26, 2020, 5:49pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with/225259 "2020-03-26T17:49:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Claudio\_Ract\_Costa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/claudio_ract_costa/32/26095_2.png) [@Claudio\_Ract\_Costa](https://discuss.elastic.co/u/Claudio_Ract_Costa)\
**Post date:** [March 26, 2020, 5:49pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with/225259/1 "2020-03-26T17:49:37Z")

</div>

HI Guys,

How can I create a Visualization like this one bellow ?

![image](https://us1.discourse-cdn.com/elastic/original/3X/8/e/8e95fd01a76065f05a2e5fcab9b0728fc7d8236a.png)

I would like to insert it in a Dashboard.

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [March 27, 2020, 4:35am UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with/225259/2 "2020-03-27T04:35:17Z")

</div>

Hi  
You should be able to achieve this in Visual Builder as well. Here is one detailed post on the same.

> [@Display a percentage column in any table visualization (Data Table or Visual Builder Table)](https://discuss.elastic.co/t/display-a-percentage-column-in-any-table-visualization-data-table-or-visual-builder-table/182412):
>
> Hi I am struggling to find a way to add a percentage (%) column to a table that contains more than one aggregation. I know that you can add a % column to a table in the visual builder visualisation, however it seems that you can only add 1 aggregation and multiple metrics. My use case is as follows: I want to be able to aggregate by 'Car Brand', 'Car Model', 'Model Year' and then apply a Count metric on each unique row in the table and then lastly (which is my question) add a % column that doe…

Hope it helps.

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![Claudio\_Ract\_Costa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/claudio_ract_costa/32/26095_2.png) [@Claudio\_Ract\_Costa](https://discuss.elastic.co/u/Claudio_Ract_Costa)\
**Post date:** [March 31, 2020, 11:41pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with/225259/3 "2020-03-31T23:41:59Z")

</div>

Perfect Rashmi.  
This kind of visualization is possible using Visual Builder with Filter Ratio aggregation

Thanks !

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 28, 2020, 11:43pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with/225259/4 "2020-04-28T23:43:27Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.