# Show values as percent of a bucket

**URL:** <https://discuss.elastic.co/t/show-values-as-percent-of-a-bucket/198459>\
**Category:** Kibana\
**Created:** [September 6, 2019, 5:32pm UTC](https://discuss.elastic.co/t/show-values-as-percent-of-a-bucket/198459 "2019-09-06T17:32:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rafael.cunha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafael.cunha/32/50099_2.png) [@rafael.cunha](https://discuss.elastic.co/u/rafael.cunha)\
**Post date:** [September 6, 2019, 5:32pm UTC](https://discuss.elastic.co/t/show-values-as-percent-of-a-bucket/198459/1 "2019-09-06T17:32:13Z")

</div>

I'm trying to create a sales pipeline chart that will show me, per campaing, the percent conversion of each stage based on the audience of each campaing. For example, my index writes the following data per campaign:  
Sent - 220  
Opened - 110  
Replyed - 50

I'd like Kibana to show:  
Sent - 100% (=220/220)  
Opened - 50% (=110/220)  
Replyed - 22.7% (=50/220)

I have created a line chart, in which each line represents one campaign. The y-axis represents the sum of users in each pipeline stage and the x-axis is a terms aggregation on each stage, as exemplified in the attached image.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/9/99fd29b9976dd89cca1beadaef21936d98a5c432.jpeg)

Is it possible to convert this chart to percentages based on the first bucket terms aggregation? If so, could anyone point me in the right direction? (I know how to do this kind of thing in timelion or visual builder, but unfortunately my x-axis is not time-based). I'm using Kibana 7.3.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [September 13, 2019, 11:01am UTC](https://discuss.elastic.co/t/show-values-as-percent-of-a-bucket/198459/2 "2019-09-13T11:01:57Z")

</div>

The only way to do this is with Timelion and Visual Builder. It's not possible with the current aggregations available in the Line Chart.

---

<div class="post-metadata">

**Author:** ![rafael.cunha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafael.cunha/32/50099_2.png) [@rafael.cunha](https://discuss.elastic.co/u/rafael.cunha)\
**Post date:** [September 13, 2019, 5:22pm UTC](https://discuss.elastic.co/t/show-values-as-percent-of-a-bucket/198459/3 "2019-09-13T17:22:56Z")

</div>

Thanks for the reply, Marius.

Regards,

---

<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:** [October 11, 2019, 5:23pm UTC](https://discuss.elastic.co/t/show-values-as-percent-of-a-bucket/198459/4 "2019-10-11T17:23:00Z")

</div>

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