# Aggregating across multiple sub documents?

**URL:** <https://discuss.elastic.co/t/aggregating-across-multiple-sub-documents/131354>\
**Category:** Elasticsearch\
**Created:** [May 10, 2018, 8:32pm UTC](https://discuss.elastic.co/t/aggregating-across-multiple-sub-documents/131354 "2018-05-10T20:32:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Varun\_Somani](https://avatars.discourse-cdn.com/v4/letter/v/ecccb3/32.png) [@Varun\_Somani](https://discuss.elastic.co/u/Varun_Somani)\
**Post date:** [May 10, 2018, 8:32pm UTC](https://discuss.elastic.co/t/aggregating-across-multiple-sub-documents/131354/1 "2018-05-10T20:32:36Z")

</div>

I have a following documents

```
Document 1:
    {
      "county" : "Santa Clara",
      "city": "San Jose",
      "date" : 123432342342,
      "user" : {
        "0" : {
          "name" : "abc",
          "metrics" : {
            "m1" : 100.0,
            "m2" : 200.0
          }
        },
        "1" : {
          "name" : "abc1",
          "metrics" : {
            "m1" : 100.0,
            "m2" : 200.0
          }
        }
      }
    }
    Document2:
       {
          "county" : "Santa Clara",
          "city": "Sunnyvale",
          "date" : 123432342342,
          "user" : {
            "0" : {
              "name" : "abc",
              "metrics" : {
                "m1" : 100.0,
                "m2" : 200.0
              }
            },
            "1" : {
              "name" : "abc1",
              "metrics" : {
                "m1" : 100.0,
                "m2" : 200.0
              }
            }
          }
        }

```

What I want is to aggregate m1 metric of user 0 and user 1 across various cities in a county and get an average/mean/percentile and so on of it.  
so basically values of:

```
document1.user.0.metric.m1 + user.1.metric.m1 + document2.user.0.metric.m1 + document2.user.1.metric.m1 ...

```

How to achieve this in ES query ?

---

<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 7, 2018, 8:33pm UTC](https://discuss.elastic.co/t/aggregating-across-multiple-sub-documents/131354/2 "2018-06-07T20:33:36Z")

</div>

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