# Visual Time Builder filter limitation

**URL:** <https://discuss.elastic.co/t/visual-time-builder-filter-limitation/98673>\
**Category:** Kibana\
**Created:** [August 29, 2017, 10:50am UTC](https://discuss.elastic.co/t/visual-time-builder-filter-limitation/98673 "2017-08-29T10:50:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexandre\_Juma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexandre_juma/32/21704_2.png) [@Alexandre\_Juma](https://discuss.elastic.co/u/Alexandre_Juma)\
**Post date:** [August 29, 2017, 10:50am UTC](https://discuss.elastic.co/t/visual-time-builder-filter-limitation/98673/1 "2017-08-29T10:50:47Z")

</div>

Hi all,

I'm having a hard time achieving some simple stuff I normally do with Timelion.

The use case is quite simple (i.e: % of distinct clients with specific condition):

> cardinality(field) metric (with applied filter)  
> divide  
> cardinality(field) metric (no filter)  
> multiply x 100

In timelion I would do something like this:

> .es(index='myindex', q="DownStream\_RXPOWER:\>4.9 || DownStream\_RXPOWER:\<-4.9", metric='cardinality:MAC\_CM').divide(.es(index='myindex', metric='cardinality:MAC\_CM')).multiply(100).label("%Of Unique Clients with problem")

In visual time builder, the "Group by filter" seems to affect all metrics created in the label with doesn't let me create a variable for the calculation that is not affected by the filter.

 ![example_visual_build_calculation](https://us1.discourse-cdn.com/elastic/original/3X/0/6/06af208b994b523cbd0d0a0bba32019d06dada6d.png)

Does anyone knows how work around this? Or am I seeing things wrong?

BR  
AJ

---

<div class="post-metadata">

**Author:** ![simianhacker](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simianhacker/32/3383_2.png) [@simianhacker](https://discuss.elastic.co/u/simianhacker)\
**Post date:** [August 29, 2017, 6:45pm UTC](https://discuss.elastic.co/t/visual-time-builder-filter-limitation/98673/2 "2017-08-29T18:45:20Z")

</div>

Check out the "filter ratio" aggregation, it allows you to set a filter for the numerator and denominator. Then choose which aggregation you want to use for the values (cardinality of a field is an option).

FYI... I just noticed a bug where you can't choose a string field for the cardinality in the filter ratio so I'm submitting a PR for that right now.

---

<div class="post-metadata">

**Author:** ![simianhacker](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simianhacker/32/3383_2.png) [@simianhacker](https://discuss.elastic.co/u/simianhacker)\
**Post date:** [August 29, 2017, 7:03pm UTC](https://discuss.elastic.co/t/visual-time-builder-filter-limitation/98673/3 "2017-08-29T19:03:03Z")

</div>

It should look something like this:

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

Here is the PR for fixing the cardinality feature in "filter ratio": [https://github.com/elastic/kibana/pull/13762](https://github.com/elastic/kibana/pull/13762)

---

<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:** [September 26, 2017, 7:03pm UTC](https://discuss.elastic.co/t/visual-time-builder-filter-limitation/98673/4 "2017-09-26T19:03:07Z")

</div>

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