# Visual builder - Filter Ratio: repeated issues with "params.numerator != null && params.denominator != null"
**URL:** https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286
**Category:** Kibana
**Created:** [January 8, 2019, 12:53am UTC](https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286 "2019-01-08T00:53:53Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@dygerati](https://discuss.elastic.co/u/dygerati)
#### Post date: [January 8, 2019, 12:53am UTC](https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286/1 "2019-01-08T00:53:53Z")
I've been experimenting with the Visual Builder (experimental) in Kibana for a series of different charts and time series. I'm primarily trying to use the Filter Ratio aggregation, and I've repeatedly run across a specific error:
[[Album] Imgur  ](https://imgur.com/a/7efEFXD)
My knowledge here is limited, but it looks like the filter for either the numerator or denominator is resulting in zero documents for at least one of the intervals.
This is hard to avoid; are there suggested methods for managing this kind of thing?
For instance, I have an 'email' document with the boolean field "wasOpened" to flag if the email was opened by the recipient. I'd like to chart the open rate over time (by day), but there may be a day where no emails were opened, or even when no emails were sent (the denominator).
How can I handle this?
Thanks!
---
### Author:  [@dygerati](https://discuss.elastic.co/u/dygerati)
#### Post date: [January 9, 2019, 11:43pm UTC](https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286/2 "2019-01-09T23:43:20Z")
Any thoughts here? Is the visual builder just expected to be pretty buggy right now? I'm attempting what would seem to be a very simple use case and still having issues with this error:
[[Album] Imgur  ](https://imgur.com/a/0tO1uBY)
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [January 21, 2019, 4:52pm UTC](https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286/3 "2019-01-21T16:52:15Z")
Hello,
We fixed a bug and it will be in upcoming 6.6.0: [https://github.com/elastic/kibana/issues/24188](https://github.com/elastic/kibana/issues/24188)
It sounds like it takes care of your problem?
Thanks,
Bhavya
---
### Author:  [@dygerati](https://discuss.elastic.co/u/dygerati)
#### Post date: [January 23, 2019, 6:03am UTC](https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286/4 "2019-01-23T06:03:14Z")
Thanks bhavyarm, that does look like it could be the culprit. Look forward to the patch.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 20, 2019, 6:03am UTC](https://discuss.elastic.co/t/visual-builder-filter-ratio-repeated-issues-with-params-numerator-null-params-denominator-null/163286/5 "2019-02-20T06:03:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.