# Consult a problem about "bucket\_script and sum\_bucket "

**URL:** https://discuss.elastic.co/t/consult-a-problem-about-bucket-script-and-sum-bucket/156645
**Category:** Elasticsearch
**Created:** [November 14, 2018, 11:32am UTC](https://discuss.elastic.co/t/consult-a-problem-about-bucket-script-and-sum-bucket/156645 "2018-11-14T11:32:03Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![xmingyang](https://avatars.discourse-cdn.com/v4/letter/x/c4cdca/32.png) [@xmingyang](https://discuss.elastic.co/u/xmingyang)
#### Post date: [November 14, 2018, 11:32am UTC](https://discuss.elastic.co/t/consult-a-problem-about-bucket-script-and-sum-bucket/156645/1 "2018-11-14T11:32:03Z")

</div>

**data source:**

area amout  
bj 100  
sh 200  
sh 200

**I need calculate the result:**

area amout percentage  
bj 300 300/500  
sh 200 200/500

How to achieve this? thanks!

I try to do this，but it is wrong.

curl -X POST "[http://localhost:9200/corp\_info6/\_doc/\_search](http://localhost:9200/corp_info6/_doc/_search)" -H 'Content-Type: application/json' -d'  
{  
"aggs": {  
"ind\_terms": {

```
  "terms": {
    "field": "area"
  },
  "aggs": {
    "sum_weight": {
      "sum": {
        "field": "amout "
      } 
    },
      "t-percentage": {
                "bucket_script": {
                    "buckets_path": {
                      "sum1": "sum_weight",
                      "total": "sum_sum_weight"
                    },
                    "script": "params.sum1 / params.total "
                }
            }
    }     
},
    "sum_sum_weight": {
        "sum_bucket": {
            "buckets_path": "ind_terms>sum_weight" 
        }
    }

```

}  
}'

---

<div class="post-metadata">

### Author: ![xmingyang](https://avatars.discourse-cdn.com/v4/letter/x/c4cdca/32.png) [@xmingyang](https://discuss.elastic.co/u/xmingyang)
#### Post date: [November 15, 2018, 6:25am UTC](https://discuss.elastic.co/t/consult-a-problem-about-bucket-script-and-sum-bucket/156645/2 "2018-11-15T06:25:05Z")

</div>

please!

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 13, 2018, 6:25am UTC](https://discuss.elastic.co/t/consult-a-problem-about-bucket-script-and-sum-bucket/156645/3 "2018-12-13T06:25:07Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.