ES7.16.2基础 *** 作之嵌套查询与统计（十四）

ES7.16.2基础 *** 作之嵌套查询与统计（十四）

## global实现全局/局部销量占比
GET tvs/_search
{
  "size": 0, 
  "query": {
    "match": {
      "brand": "长虹"
    }
  },
  "aggs": {
    "single_brand_avg_price": {
      "avg": {
        "field": "price"
      }
    },
    "all_avg_price": {
      "global": {},
      "aggs": {
        "all_brand_avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  }
}

##统计"长虹"品牌电视，近一个月，三个月，6个月的平均价格
GET tvs/_search
{
  "size": 0,
  "query": {
    "term": {
      "brand": "长虹"
    }
  },
  "aggs": {
    "aggs_recent_1_month": {
      "filter": {
        "range": {
          "sold_date": {
            "gte": "now-30d"
          }
        }
      },
      "aggs": {
        "one_month_avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    },
    "aggs_recent_3_month": {
      "filter": {
        "range": {
          "sold_date": {
            "gte": "now-60d"
          }
        }
      },
      "aggs": {
        "3_month_avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    },
    "aggs_recent_6_month": {
      "filter": {
        "range": {
          "sold_date": {
            "gte": "now-6m"
          }
        }
      },
      "aggs": {
        "6_month_avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  }
}

##按颜色分类，求平均价，并按平均价降序排序
GET tvs/_search
{
  "size": 0,
  "aggs": {
    "group_by_color": {
      "terms": {
        "field": "color",
        "size": 10,
        "order": {
          "avg_price": "desc"
        }
      },
      "aggs": {
        "avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  }
}

##按颜色，品牌，求平均价，并按平均价降序
GET tvs/_search
{
  "size": 0,
  "aggs": {
    "group_by_color": {
      "terms": {
        "field": "color"
      },
      "aggs": {
        "group_by_brand": {
          "terms": {
            "field": "brand",
            "order": {
              "avg_price": "desc"
            }
          },
          "aggs": {
            "avg_price": {
              "avg": {
                "field": "price"
              }
            }
          }
        }
      }
    }
  }
}