Rough Gist to aggregate nested values

runme.sh

#!/bin/sh
es_host="http://localhost:9200"
curl -XDELETE "$es_host/contests"
curl -XPUT "$es_host/contests" -d '
{
   "settings": {
      "index.number_of_replicas": 0,
      "index.number_of_shards": 1,
      "index.refresh_interval": -1
   },
   "mappings": {
      "contest": {
         "properties": {
            "contestant": {
               "type": "nested",
               "properties": {
                  "id": {
                     "type": "string",
                     "index": "not_analyzed"
                  },
                  "timing": {
                     "type": "integer"
                  },
                  "expectedTiming": {
                     "type": "integer"
                  }
               }
            }
         }
      }
   }
}'

curl -XPUT "http://localhost:9200/contests/contest/1" -d'
{
    "contestant": [
      {
        "id": "alice",
        "data": [
          {
            "timing": 1,
            "expectedTiming": 2
          },
          {
            "timing": 2,
            "expectedTiming": 2
          }
        ]
      },
      {
        "id": "jane",
        "data": [
          {
            "timing": 3,
            "expectedTiming": 2
          },
          {
            "timing": 4,
            "expectedTiming": 2
          }
        ]
      }
    ]
}'

curl -XPUT "http://localhost:9200/contests/contest/2" -d'
{
    "contestant": [
      {
        "id": "alice",
        "data": [
          {
            "timing": 1,
            "expectedTiming": 2
          },
          {
            "timing": 2,
            "expectedTiming": 2
          }
        ]
      },
      {
        "id": "jane",
        "data": [
          {
            "timing": 3,
            "expectedTiming": 2
          },
          {
            "timing": 4,
            "expectedTiming": 2
          }
        ]
      }
    ]
}'
curl -XPOST 'http://localhost:9200/contests/_flush'
curl -XGET "http://localhost:9200/contests/_search" -d'
{
   "aggs": {
      "myResults": {
         "nested": {
            "path": "contestant"
         },
         "aggs": {
            "per_contestant": {
               "terms": {
                  "field": "id"
               },
               "aggs": {
                  "timingInfo": {
                     "sum": {
                        "field": "contestant.data.timing"
                     }
                  }
               }
            }
         }
      }
   }
}'