GET teacher_dashboard_student_kpi_master_index/_search
{
"size": 0,
"query": {
"bool": {
"filter": [
],
"must": [
]
}
},
"aggs": {
"my_buckets": {
"composite": {
"size": 2,
"sources": [
{
"school_year": {
"terms": {
"field": "school_year",
"order": "asc",
"size": 1
}
}
},
{
"student_id": {
"terms": {
"field": "student_id",
"order": "desc",
"size": 999
}
}
},
{
"metric_id": {
"terms": {
"field": "metric_id"
}
}
}
]
},
"aggs": {
"sum_num": {
"sum": {
"script": "Float.parseFloat(doc['metric_numerator.keyword'].value)"
}
},
"sum_den": {
"sum": {
"field": "metric_denominator"
}
},
"avg": {
"bucket_script": {
"buckets_path": {
"num_cy": "sum_num.value",
"den_cy": "sum_den.value"
},
"script": "(params.num_cy/params.den_cy*100)"
}
}
}
}
}
}