# Aggregation - Filter by Count

**URL:** <https://discuss.elastic.co/t/aggregation-filter-by-count/37441>\
**Category:** Elasticsearch\
**Created:** [December 17, 2015, 7:58am UTC](https://discuss.elastic.co/t/aggregation-filter-by-count/37441 "2015-12-17T07:58:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![inzanez](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@inzanez](https://discuss.elastic.co/u/inzanez)\
**Post date:** [December 17, 2015, 7:58am UTC](https://discuss.elastic.co/t/aggregation-filter-by-count/37441/1 "2015-12-17T07:58:46Z")

</div>

Hi

I'm just doing some aggregation queries on logdata I've collected with elasticsearch. What I would love to do is something like "get a distinct count of 'xxx' but only if distinct\_count(xxx) is greater than 20" for instance. Getting distinct counts works perfect so far, just missing the rest somehow.  
Is this even possible to only get results back where the distinct count is \< or \> a given value?

---

<div class="post-metadata">

**Author:** ![ebuildy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ebuildy/32/6070_2.png) [@ebuildy](https://discuss.elastic.co/u/ebuildy)\
**Post date:** [December 17, 2015, 9:03am UTC](https://discuss.elastic.co/t/aggregation-filter-by-count/37441/2 "2015-12-17T09:03:09Z")

</div>

Did you try the new pipeline aggregations?

[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-selector-aggregation.html)

Sorry, dont have the solution in mind, but this should help, don't hesitate to post your solution here!

Thanks,

---

<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:** [July 5, 2017, 11:30pm UTC](https://discuss.elastic.co/t/aggregation-filter-by-count/37441/3 "2017-07-05T23:30:18Z")

</div>


