ElasticSearch test expression script with aggregation and sub aggregations

create_entries.json

{
  "color": "black",
  "testVal": 25,
  "testQuantity": 5
}

mapping.json

{
	"mappings" : {
		"test" : {
			"properties" : {
			  "color": { "type" : "string", "index" : "not_analyzed" },
				"testVal" : { "type" : "long", "index" : "not_analyzed" },
				"testQuantity" : { "type" : "long", "index" : "not_analyzed" }
			}
		}
	}
}

query.json

{
  "aggs": {
    "testColor": {
      "terms": {
        "field": "color"
      },
      "aggs": {
        "testAgg": {
          "sum": {
            "lang": "expression",
            "script": "doc['testVal'].value * doc['testQuantity'].value"        
          }
        }
      }
    }
  }
}

urls

mapping:
  http://localhost:9200/test/test/ PUT

create_entries:
  http://localhost:9200/test/test/ POST
  
query:
  http://localhost:9200/test/test/_search?search_type=count POST