# Aggreagte Bucket Filtering

**URL:** <https://discuss.elastic.co/t/aggreagte-bucket-filtering/59380>\
**Category:** Elasticsearch\
**Created:** [August 31, 2016, 2:04am UTC](https://discuss.elastic.co/t/aggreagte-bucket-filtering/59380 "2016-08-31T02:04:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![RajaT](https://avatars.discourse-cdn.com/v4/letter/r/ebca7d/32.png) [@RajaT](https://discuss.elastic.co/u/RajaT)\
**Post date:** [August 31, 2016, 2:04am UTC](https://discuss.elastic.co/t/aggreagte-bucket-filtering/59380/1 "2016-08-31T02:04:40Z")

</div>

I have a JSON document that has an array as follows:

{  
...  
...

```
    "diagnosis" : [ {
      "Description" : "18 WEEKS GESTATION OF PREGNANCY"
    }, {
      "Description" : "14 WEEKS GESTATION OF PREGNANCY"
    } ]
    "order_id" : "72C9A1D7AC90AEDDB4F1FAC557FF6DCDF0F16ED29AFFCBDAC1ADED5B524FA419"

```

}

Please note above that diagnosis has multiple values and I am running aggregation as follows.

{  
"size" : 0,  
"query":{  
"term":{  
"order\_id":"72C9A1D7AC90AEDDB4F1FAC557FF6DCDF0F16ED29AFFCBDAC1ADED5B524FA419"  
}  
},  
"aggs":{  
"filter\_diag":{  
"filter":{  
"term":{  
"diagnosis.Description":"18 WEEKS GESTATION OF PREGNANCY"  
}  
},  
"aggs":{  
"group\_by\_diag":{  
"terms":{  
"field":"diagnosis.Description"  
}  
}  
}  
}  
}  
}

My intension was to include only "18 WEEKS GESTATION OF PREGNANCY" in my aggregation. However, it gave me the below output.

"aggregations" : {  
"filter\_diag" : {  
"doc\_count" : 1,  
"group\_by\_diag" : {  
"doc\_count\_error\_upper\_bound" : 0,  
"sum\_other\_doc\_count" : 0,  
"buckets" : [ {  
"key" : "14 WEEKS GESTATION OF PREGNANCY",  
"doc\_count" : 1  
}, {  
"key" : "18 WEEKS GESTATION OF PREGNANCY",  
"doc\_count" : 1  
} ]  
}  
}

I just want 18 WEEKS GESTATION OF PREGNANCY value only and don't want other value.

Is there a way to filter out unwanted values at ElasticSearch level?

---

<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, 10:23pm UTC](https://discuss.elastic.co/t/aggreagte-bucket-filtering/59380/2 "2017-07-05T22:23:48Z")

</div>