# Aggregation on data of type array grouped by field of object

**URL:** <https://discuss.elastic.co/t/aggregation-on-data-of-type-array-grouped-by-field-of-object/107517>\
**Category:** Elasticsearch\
**Created:** [November 14, 2017, 8:58am UTC](https://discuss.elastic.co/t/aggregation-on-data-of-type-array-grouped-by-field-of-object/107517 "2017-11-14T08:58:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akshay\_Jaiswal](https://avatars.discourse-cdn.com/v4/letter/a/c89c15/32.png) [@Akshay\_Jaiswal](https://discuss.elastic.co/u/Akshay_Jaiswal)\
**Post date:** [November 14, 2017, 8:58am UTC](https://discuss.elastic.co/t/aggregation-on-data-of-type-array-grouped-by-field-of-object/107517/1 "2017-11-14T08:58:06Z")

</div>

Given an array I want to aggregate average value of **rating** field for all objects grouped by **name** field in JSON i.e quality and value.

Expected output :  
quality - avg rating 2.5  
value - avg rating 3

I have an array similar to as given below:

array : [  
{  
"name": "quality",  
"rating": 4,  
"range": 5  
},  
{  
"name": "value",  
"rating": 4,  
"range": 5  
},  
{  
"name": "quality",  
"rating": 1,  
"range": 5  
},  
{  
"name": "value",  
"rating": 2,  
"range": 5  
}  
]

---

<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 12, 2017, 8:58am UTC](https://discuss.elastic.co/t/aggregation-on-data-of-type-array-grouped-by-field-of-object/107517/2 "2017-12-12T08:58:12Z")

</div>

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