# Count of a particular item in array

**URL:** <https://discuss.elastic.co/t/count-of-a-particular-item-in-array/157719>\
**Category:** Elasticsearch\
**Created:** [November 21, 2018, 1:54pm UTC](https://discuss.elastic.co/t/count-of-a-particular-item-in-array/157719 "2018-11-21T13:54:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sangeeth](https://avatars.discourse-cdn.com/v4/letter/s/c89c15/32.png) [@Sangeeth](https://discuss.elastic.co/u/Sangeeth)\
**Post date:** [November 21, 2018, 1:54pm UTC](https://discuss.elastic.co/t/count-of-a-particular-item-in-array/157719/1 "2018-11-21T13:54:13Z")

</div>

There are 5 documents each with a field "fruits" which is of type array.  
#1 fruits = ["apple","apple","orange"]  
#2 fruits = ["orange","grapes","mango"]  
#3 fruits = ["mango","apple","apple"]  
#4 fruits = ["apple","mango"]  
#5 fruits = ["apple"]

I want to get the total number of occurrences of "apple" in fruits from all documents. Kindly help

---

<div class="post-metadata">

**Author:** ![byronvoorbach](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/byronvoorbach/32/8283_2.png) [@byronvoorbach](https://discuss.elastic.co/u/byronvoorbach)\
**Post date:** [November 21, 2018, 3:09pm UTC](https://discuss.elastic.co/t/count-of-a-particular-item-in-array/157719/2 "2018-11-21T15:09:36Z")

</div>

One way could be:

```
GET _search
{
  "size": 0,
  "aggs": {
    "amount_of_apples": {
      "terms": {
        "include": "apple", 
        "field": "fruit"
      }
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![Sangeeth](https://avatars.discourse-cdn.com/v4/letter/s/c89c15/32.png) [@Sangeeth](https://discuss.elastic.co/u/Sangeeth)\
**Post date:** [November 22, 2018, 5:22am UTC](https://discuss.elastic.co/t/count-of-a-particular-item-in-array/157719/3 "2018-11-22T05:22:26Z")

</div>

Hi there,

I tried as per your suggestion but instead of returning the number of apples(which is 5) , it is returning the number of documents containing apple( i.e. 3 ) . How to get the former answer i.e . the number of apples

---

<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:** [December 20, 2018, 5:22am UTC](https://discuss.elastic.co/t/count-of-a-particular-item-in-array/157719/4 "2018-12-20T05:22:28Z")

</div>

Closed on December 20, 2018, 5:22am UTC

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