# Elasticsearch terms aggregation based on id field need name field as a display

**URL:** <https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808>\
**Category:** Elasticsearch\
**Created:** [September 29, 2016, 12:20pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808 "2016-09-29T12:20:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![raja\_augstin](https://avatars.discourse-cdn.com/v4/letter/r/9de053/32.png) [@raja\_augstin](https://discuss.elastic.co/u/raja_augstin)\
**Post date:** [September 29, 2016, 12:20pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808/1 "2016-09-29T12:20:39Z")

</div>

is there anyway that we can buckets based on id and display based on Name?

{  
"aggs" : {  
"topAdvisors" : {  
"terms" : {  
"field" : "advRepNum"  
}  
}  
}  
}

Output :  
"buckets":  
[  
{  
"key": "9813",  
"doc\_count": 433  
},  
{  
"key": "19076",  
"doc\_count": 275  
},  
{  
"key": "6877",  
"doc\_count": 30  
},  
{  
"key": "19347",  
"doc\_count": 67  
}  
]

```
Expected Output:		
		"buckets":
        [
            {
                "key": "John",
                "doc_count": 433
            },
            {
                "key": "Smith",
                "doc_count": 275
            },
            {
                "key": "Tom",
                "doc_count": 30
            },
            {
                "key": "Ben",
                "doc_count": 67
            }
        ]
```

---

<div class="post-metadata">

**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\
**Post date:** [September 29, 2016, 2:20pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808/2 "2016-09-29T14:20:36Z")

</div>

This is not possible. You would have to perform follow-up requests in order to resolve the name given the id.

---

<div class="post-metadata">

**Author:** ![raja\_augstin](https://avatars.discourse-cdn.com/v4/letter/r/9de053/32.png) [@raja\_augstin](https://discuss.elastic.co/u/raja_augstin)\
**Post date:** [September 29, 2016, 2:34pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808/3 "2016-09-29T14:34:56Z")

</div>

what should be the followup request to proceed furthur.

---

<div class="post-metadata">

**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\
**Post date:** [October 14, 2016, 3:05pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808/4 "2016-10-14T15:05:41Z")

</div>

You would have to run a term query on the id and look up the name in the returned document.

---

<div class="post-metadata">

**Author:** ![raja\_augstin](https://avatars.discourse-cdn.com/v4/letter/r/9de053/32.png) [@raja\_augstin](https://discuss.elastic.co/u/raja_augstin)\
**Post date:** [November 14, 2016, 12:55pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808/5 "2016-11-14T12:55:27Z")

</div>

Can you please provide sample \_id query with that aggregations.

---

<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:05pm UTC](https://discuss.elastic.co/t/elasticsearch-terms-aggregation-based-on-id-field-need-name-field-as-a-display/61808/6 "2017-07-05T22:05:51Z")

</div>