# Aggregation count of mail domains using elastisearch

**URL:** <https://discuss.elastic.co/t/aggregation-count-of-mail-domains-using-elastisearch/133806>\
**Category:** Elasticsearch\
**Created:** [May 30, 2018, 7:33am UTC](https://discuss.elastic.co/t/aggregation-count-of-mail-domains-using-elastisearch/133806 "2018-05-30T07:33:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rakeshallampati](https://avatars.discourse-cdn.com/v4/letter/r/85f322/32.png) [@rakeshallampati](https://discuss.elastic.co/u/rakeshallampati)\
**Post date:** [May 30, 2018, 7:33am UTC](https://discuss.elastic.co/t/aggregation-count-of-mail-domains-using-elastisearch/133806/1 "2018-05-30T07:33:18Z")

</div>

I have following documents in my index:

```
{
    "name":"rakesh"
    "age":"26"
    "email":"rakesh@gmail.com"
}

{
    "name":"sam"
    "age":"24"
    "email":"samjoe@elastic.com"
}

{
    "name":"joseph"
    "age":"26"
    "email":"joseph@gmail.com"
}

{
    "name":"genny"
    "age":"24"
    "email":"genny@hotmail.com"
}

```

Now i need to get the count of all mail domains. Like:

```
@gmail.com:2,
@hotmail.com:1,
@elastic.com:1

```

using elastic search aggregations.

I already have an existing data in my index. so i cannot able to use the analyzers over it. can able to find the records which matches the given query. But i need have a count of each domain.

Thanks in advance for your help.

---

<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 30, 2018, 10:07am UTC](https://discuss.elastic.co/t/aggregation-count-of-mail-domains-using-elastisearch/133806/2 "2018-05-30T10:07:38Z")

</div>

May be using something like [https://www.elastic.co/guide/en/elasticsearch/reference/current/analysis-simplepattern-tokenizer.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/analysis-simplepattern-tokenizer.html) would help?

---

<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 27, 2018, 10:11am UTC](https://discuss.elastic.co/t/aggregation-count-of-mail-domains-using-elastisearch/133806/3 "2018-06-27T10:11:00Z")

</div>

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