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

本文链接：https://blog.youkuaiyun.com/ls_call520/article/details/122199529

本文探讨了长虹品牌电视的销量占比，按月度、季度和半年度统计平均价格，并深入分析了颜色分类和多维度组合（品牌+颜色）的平均价排名。揭示近期市场动态和消费者偏好。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

## 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"
              }
            }
          }
        }
      }
    }
  }
}