# How to use parent/sibiling pipeline aggregation in TVSB

**URL:** https://discuss.elastic.co/t/how-to-use-parent-sibiling-pipeline-aggregation-in-tvsb/244184
**Category:** Kibana
**Created:** [August 7, 2020, 2:09pm UTC](https://discuss.elastic.co/t/how-to-use-parent-sibiling-pipeline-aggregation-in-tvsb/244184 "2020-08-07T14:09:12Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Redcxx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redcxx/32/73872_2.png) [@Redcxx](https://discuss.elastic.co/u/Redcxx)
#### Post date: [August 7, 2020, 2:09pm UTC](https://discuss.elastic.co/t/how-to-use-parent-sibiling-pipeline-aggregation-in-tvsb/244184/1 "2020-08-07T14:09:12Z")

</div>

As title said, may I know how to use parent/sibiling pipeline aggregation? They appear gray in the interface:

 ![Screenshot 2020-08-07 at 15.06.36](https://us1.discourse-cdn.com/elastic/original/3X/5/f/5ffd7e91ddc67aa574c4db612f0772a09f0c7c6c.png)  
Let say I have two fields called `itemCount1` and `itemCount2`, is there a way to find the ratio of `itemCount1` to `itemCount2`? That is, sum of `itemCount1` / sum of `itemCount2`.  
Thank you!

---

<div class="post-metadata">

### Author: ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [August 11, 2020, 7:16pm UTC](https://discuss.elastic.co/t/how-to-use-parent-sibiling-pipeline-aggregation-in-tvsb/244184/2 "2020-08-11T19:16:31Z")

</div>

Hi @Redcxx,  
that's because you're creating two independant metrics here - instead of clicking the '+' on the right side of label, click on the '+' on the level of single aggregation (in your case, on the right side of "Aggregation" and "Field". Here's the tutorial that solves similar problem to what you're having: [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)

Let me know if it helps.  
Regards,  
Marta

---

<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: [September 8, 2020, 7:16pm UTC](https://discuss.elastic.co/t/how-to-use-parent-sibiling-pipeline-aggregation-in-tvsb/244184/3 "2020-09-08T19:16:56Z")

</div>

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