# Weighted Average and aggregations

**URL:** <https://discuss.elastic.co/t/weighted-average-and-aggregations/67755>\
**Category:** Elasticsearch\
**Created:** [December 1, 2016, 11:56am UTC](https://discuss.elastic.co/t/weighted-average-and-aggregations/67755 "2016-12-01T11:56:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [December 1, 2016, 12:22pm UTC](https://discuss.elastic.co/t/weighted-average-and-aggregations/67755/2 "2016-12-01T12:22:36Z")

</div>

Actually I did something:

```
GET titubb56k/ihale/_search 
{
"size":0,
  "query": {"match": { "UrunNo": "99" } },
  "aggs":{
      "group_by_tarih":{
        "terms":{ "field": "AlimTarihi",
        "order":{
            "Birim_Fiyat_agirlik_ort":"asc"
          }},
          "aggs" : {
         "Birim_Fiyat_agirlik_ort": {"avg" : { "script" : "[value: doc['BirimFiyat'].value, weight: doc['Adet'].value]" }}
          } } }}

```

but I have error:

```
{
  "error": {
    "root_cause": [
      {
        "type": "parsing_exception",
        "reason": "Unexpected token VALUE_STRING [script] in [Birim_Fiyat_agirlik_ort].",
        "line": 11,
        "col": 72
      }
    ],
    "type": "parsing_exception",
    "reason": "Unexpected token VALUE_STRING [script] in [Birim_Fiyat_agirlik_ort].",
    "line": 11,
    "col": 72
  },
  "status": 400
}
```

---

_[View the full topic](https://discuss.elastic.co/t/weighted-average-and-aggregations/67755)._