Aggregated elastic query

stuff.json

{
	"size": 0,
	"query": {
		"bool": {
			"must": [
				{ "exists": {"field": "status" } },
				{ "exists": {"field": "class_name" } },
				{ "exists": {"field": "test_name" } }
			]
		}
	},
	"aggs": {
		"by_testcase": {
			"terms": {
				"size": 1000,
				"script": {
					"source": "doc['class_name.keyword'].value + '.' + doc['test_name.keyword'].value;",
					"lang": "painless"
				}
			},
			"aggs": {
				"by_best_case": {
					"max": {
						"script": {
							"lang": "painless",
							"source": "if(doc['status'].value == 'pass') {return 2;} else if(doc['status'].value == 'skip') {return 1;} else {return 0;}"
						}
					}
				}
			}
		}
	}
}