# Visual Builder Can't use overall aggregation as input to another aggregation

**URL:** https://discuss.elastic.co/t/visual-builder-cant-use-overall-aggregation-as-input-to-another-aggregation/92152
**Category:** Kibana
**Created:** [July 6, 2017, 5:53pm UTC](https://discuss.elastic.co/t/visual-builder-cant-use-overall-aggregation-as-input-to-another-aggregation/92152 "2017-07-06T17:53:10Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [August 17, 2017, 5:01pm UTC](https://discuss.elastic.co/t/visual-builder-cant-use-overall-aggregation-as-input-to-another-aggregation/92152/6 "2017-08-17T17:01:15Z")

</div>

Visual Builder (TSVB) does have the `Filter Ratio` aggregation. While it does create a time series, it also shows a gauge and has markdown output. If you set your Interval as large as your timespan then you effectively get the single value that represents the whole timestpan.

> [@Doing Math over count of events](https://discuss.elastic.co/t/doing-math-over-count-of-events/97278/6):
>
> Do all your docs have either success or failure? If so, then the visual builder screen I showed should work because it's doing transactionStatus:success/\* In this case \* means all docs, which is both success and failure. If some of your docs don't have either success or failure, then we'll need to use something other than \* for the denominator.

---

_[View the full topic](https://discuss.elastic.co/t/visual-builder-cant-use-overall-aggregation-as-input-to-another-aggregation/92152)._