# Elastic Search aggregation query results are case incentive

**URL:** <https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930>\
**Category:** Elasticsearch\
**Created:** [May 15, 2018, 12:27pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930 "2018-05-15T12:27:31Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![srikanth\_nagineni](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@srikanth\_nagineni](https://discuss.elastic.co/u/srikanth_nagineni)\
**Post date:** [May 15, 2018, 12:27pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/1 "2018-05-15T12:27:31Z")

</div>

I am using Elasticsearch 6.2 Version. In the aggregation, query results are returned like `

> Apple 10, apple 20, aPple 30

But I need all the names to be lower case and the final count will be

> apple 60

Is there any way to get the aggregation results like my requirement.

---

<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:** [May 15, 2018, 12:42pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/2 "2018-05-15T12:42:21Z")

</div>

Use a lowercase normalizer on your keyword field.

---

<div class="post-metadata">

**Author:** ![srikanth\_nagineni](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@srikanth\_nagineni](https://discuss.elastic.co/u/srikanth_nagineni)\
**Post date:** [May 15, 2018, 1:02pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/3 "2018-05-15T13:02:23Z")

</div>

This is mappings file:  
"company\_name": {  
"type": "text",  
"fields": {  
"keyword": {  
"type": "keyword",  
},  
},  
"boost": 1.0,  
"analyzer": "lowercase\_analyzer",  
},

---

<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:** [May 15, 2018, 1:25pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/4 "2018-05-15T13:25:52Z")

</div>

Have a look at [https://www.elastic.co/guide/en/elasticsearch/reference/current/normalizer.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/normalizer.html)

---

<div class="post-metadata">

**Author:** ![srikanth\_nagineni](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@srikanth\_nagineni](https://discuss.elastic.co/u/srikanth_nagineni)\
**Post date:** [May 15, 2018, 1:26pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/5 "2018-05-15T13:26:55Z")

</div>

@dadoonet It is working fine. Thank you!

In my case, I am having some special characters also like below:

> Token - count  
> apple, inc - 20  
> apple inc - 10  
> apple inc, - 10  
> apple. inc - 20  
> apple.inc., - 10

I need the output like this:

> Token - count  
> apple inc - 70

Is there any analyzer to satisfy my condition? If yes, Can you point me? Thank you!

---

<div class="post-metadata">

**Author:** ![srikanth\_nagineni](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@srikanth\_nagineni](https://discuss.elastic.co/u/srikanth_nagineni)\
**Post date:** [May 15, 2018, 1:38pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/6 "2018-05-15T13:38:14Z")

</div>

@dadoonet Got it. Just used custom analyzer and used that analyzer in normalize function.

> "dot\_pattern": {  
> "type": "pattern\_replace",  
> "pattern": "\.",  
> "replacement": " "  
> }

---

<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:** [June 12, 2018, 1:47pm UTC](https://discuss.elastic.co/t/elastic-search-aggregation-query-results-are-case-incentive/131930/7 "2018-06-12T13:47:25Z")

</div>

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