# Two aggregations on different filter in same query

**URL:** https://discuss.elastic.co/t/two-aggregations-on-different-filter-in-same-query/122055
**Category:** Elasticsearch
**Created:** [March 1, 2018, 12:39pm UTC](https://discuss.elastic.co/t/two-aggregations-on-different-filter-in-same-query/122055 "2018-03-01T12:39:28Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![devil\_srj7](https://avatars.discourse-cdn.com/v4/letter/d/8edcca/32.png) [@devil\_srj7](https://discuss.elastic.co/u/devil_srj7)
#### Post date: [March 1, 2018, 12:39pm UTC](https://discuss.elastic.co/t/two-aggregations-on-different-filter-in-same-query/122055/1 "2018-03-01T12:39:28Z")

</div>

I perform two separate request for my aggregations as:

1. For sum of payments of bill number = 3

2. For sum of payments of bill number less than 3

As You can see both the request perform the same operations only the change is the filter.

Is there a way such that I can perform 1 aggregation on different filter and 2nd aggregation on another filter??

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 1, 2018, 2:48pm UTC](https://discuss.elastic.co/t/two-aggregations-on-different-filter-in-same-query/122055/2 "2018-03-01T14:48:31Z")

</div>

Have a look at:

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

---

<div class="post-metadata">

### Author: ![devil\_srj7](https://avatars.discourse-cdn.com/v4/letter/d/8edcca/32.png) [@devil\_srj7](https://discuss.elastic.co/u/devil_srj7)
#### Post date: [March 10, 2018, 12:06pm UTC](https://discuss.elastic.co/t/two-aggregations-on-different-filter-in-same-query/122055/3 "2018-03-10T12:06:46Z")

</div>

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: [April 7, 2018, 12:06pm UTC](https://discuss.elastic.co/t/two-aggregations-on-different-filter-in-same-query/122055/4 "2018-04-07T12:06:49Z")

</div>

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