I am trying to achieve bucket script aggregation for value derived from multiple sub aggregation, how to transverse to the derived value
My query looks like below
POST /sales/_search
{
"size": 0,
"aggs": {
"sales_per_month": {
"date_histogram": {
"field": "date",
"calendar_interval": "month"
},
"aggs": {
"total_sales": {
"sum": {
"field": "price"
}
},
"t-shirts": {
"filter": {
"term": {
"type": "t-shirt"
}
},
"aggs": {
"type": {
"term": {
"field": "type"
}
},
"aggs" : {
"sales" : {
"sum" : {
"field" : "sales"
}
}
}
}
},
"t-shirt-percentage": {
"bucket_script": {
"buckets_path": {
"tShirtSales": "t-shirts>type[]>sales",
"totalSales": "total_sales"
},
"script": "params.tShirtSales / params.totalSales * 100"
}
}
}
}
}
}
How to achieve bucket path for tshirt sales for multi value bucket