How to use parent/sibiling pipeline aggregation in TVSB

[Redcxx (Luo)]

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

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!

[Marta_Bondyra]

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

Let me know if it helps.
Regards,
Marta