# Transverse through multiple buckets
**URL:** https://discuss.elastic.co/t/transverse-through-multiple-buckets/253974
**Category:** Elasticsearch
**Created:** [November 2, 2020, 4:01am UTC](https://discuss.elastic.co/t/transverse-through-multiple-buckets/253974 "2020-11-02T04:01:37Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@gokul275](https://discuss.elastic.co/u/gokul275)
#### Post date: [November 2, 2020, 4:01am UTC](https://discuss.elastic.co/t/transverse-through-multiple-buckets/253974/1 "2020-11-02T04:01:37Z")
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
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 30, 2020, 4:01am UTC](https://discuss.elastic.co/t/transverse-through-multiple-buckets/253974/2 "2020-11-30T04:01:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.