# Divide Sums with conditions an d group by

**URL:** https://discuss.elastic.co/t/divide-sums-with-conditions-an-d-group-by/223437
**Category:** Kibana
**Created:** [March 13, 2020, 2:47am UTC](https://discuss.elastic.co/t/divide-sums-with-conditions-an-d-group-by/223437 "2020-03-13T02:47:25Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![cheiligers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheiligers/32/73114_2.png) [@cheiligers](https://discuss.elastic.co/u/cheiligers)
#### Post date: [April 3, 2020, 5:14pm UTC](https://discuss.elastic.co/t/divide-sums-with-conditions-an-d-group-by/223437/2 "2020-04-03T17:14:47Z")

</div>

Hi @AClerk,  
I recommend using a Filter Ratio in a TSVB visualization with a Filter Ratio aggregation. There's a great description of how to set this up in this discuss Q&A on [computing and displaying a ratio](https://discuss.elastic.co/t/visual-builder-compute-and-display-a-ratio/128836). It's a slightly older post, and depending on the version of Kibana that you're running, you can also reference the [guide in the docs](https://www.elastic.co/guide/en/kibana/current/visualize.html).

---

_[View the full topic](https://discuss.elastic.co/t/divide-sums-with-conditions-an-d-group-by/223437)._