Elasticsearch Weighted Avg Aggre

2020-09-23  本文已影响0人  觉释
POST /exams/_search
{
  "size": 0,
  "aggs": {
    "weighted_grade": {
      "weighted_avg": {
        "value": {
          "field": "grade"
        },
        "weight": {
          "field": "weight"
        }
      }
    }
  }
}

返回值

{
  ...
  "aggregations": {
    "weighted_grade": {
      "value": 70.0
    }
  }
}

POST /exams/_doc?refresh
{
  "grade": [1, 2, 3],
  "weight": 2
}
POST /exams/_search
{
  "size": 0,
  "aggs": {
    "weighted_grade": {
      "weighted_avg": {
        "value": {
          "field": "grade"
        },
        "weight": {
          "field": "weight"
        }
      }
    }
  }
}

返回值

{
  ...
  "aggregations": {
    "weighted_grade": {
      "value": 2.0
    }
  }
}

上一篇 下一篇

猜你喜欢

热点阅读