# Visualize: Divide values of 2 filters

**URL:** https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028
**Category:** Kibana
**Created:** [November 1, 2017, 12:45pm UTC](https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028 "2017-11-01T12:45:13Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Frank\_Matera](https://avatars.discourse-cdn.com/v4/letter/f/ba9def/32.png) [@Frank\_Matera](https://discuss.elastic.co/u/Frank_Matera)
#### Post date: [November 1, 2017, 12:45pm UTC](https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028/1 "2017-11-01T12:45:13Z")

</div>

Running Kibana 5.6. What I would like to know if it is at all possible, to do (filter2/filter1)\*100 in another way (Completed/ATTEMPTS)\*100. I have tried multiple ways with no luck. Any help would be greatly appreciated.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/1/41d9bc9f52ebb609b33b9d1d14de0133dda85266.png)

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [November 3, 2017, 9:46am UTC](https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028/2 "2017-11-03T09:46:00Z")

</div>

Hi @Frank_Matera,

the Time Series Visual Builder visualization type offers a `Filter Ratio` aggregation, that seems to do what you are asking for. It allows you to enter separate filters for the numerator and the denominator and calculates the fraction. You can then further process it using a `Calculation` aggregation (e.g. to multiply with 100) or just configure the axes the way you want.

---

<div class="post-metadata">

### Author: ![Frank\_Matera](https://avatars.discourse-cdn.com/v4/letter/f/ba9def/32.png) [@Frank\_Matera](https://discuss.elastic.co/u/Frank_Matera)
#### Post date: [November 3, 2017, 2:02pm UTC](https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028/3 "2017-11-03T14:02:50Z")

</div>

Thank you @weltenwort

This looks promising, but I am having issues. If I set it up as a count and apply my filters, I seem to have no issue. I see the data but when I try filter ratio, I do not see any results. Would you be able to assist on what I am doing incorrectly? Thanks again.

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

![image](https://us1.discourse-cdn.com/elastic/original/3X/3/1/31e0d5aa782930139c629e056965ac7b52639368.png)

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [November 3, 2017, 3:26pm UTC](https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028/4 "2017-11-03T15:26:51Z")

</div>

The numerator and denominator fields directly expect the filter expression. If you want to also display the values of "Attempted" and "Completed" you can just add this as an additional metric:

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

It might also be helpful to put the ratio on a separate axis because it will have a dramatically different value range:

![image](https://us1.discourse-cdn.com/elastic/original/3X/4/1/41089a3754f84b7bcb210358370c2eb25649e95f.png)

---

<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: [December 1, 2017, 3:27pm UTC](https://discuss.elastic.co/t/visualize-divide-values-of-2-filters/106028/5 "2017-12-01T15:27:13Z")

</div>

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