## 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" } } } } } } } }
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)