一.查询注册时间是2020-02-01-2020-02-29且消费也在2020-02-01-2020-02-29期间的女性人数,并以userId进行分组
{
"query": {
"bool": {
"must": [
{
"term": {
"sex": 2
}
},
{
"range": {
"endTime": {
"from": 1580486400000,
"to": 1582991999000,
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
}
],
"filter": [
{
"range": {
"registerTime": {
"from": 1580486400000,
"to": 1582991999000,
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
}
],
"disable_coord": false,
"adjust_pure_negative": true,
"boost": 1
}
},
"size": 0,
"aggs": {
"agg_data": {
"terms": {
"field": "userId"
}
}
}
}
结果:
二.查询注册时间是2020-02-01-2020-02-29且消费也在2020-02-01-2020-02-29期间的女性人数,并以多数据类型字段adCode进行分组
分组语句:
{
"query": {
"bool": {
"must": [
{
"term": {
"sex": 2
}
},
{
"range": {
"endTime": {
"from": 1580486400000,
"to": 1582991999000,
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
}
],
"filter": [
{
"range": {
"registerTime": {
"from": 1580486400000,
"to": 1582991999000,
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
}
],
"disable_coord": false,
"adjust_pure_negative": true,
"boost": 1
}
},
"size": 0,
"aggs": {
"agg_data": {
"terms": {
"field": "adCode.keyword",
"size": 1000
},
"aggs": {
"agg_lable": {
"terms": {
"field": "userId"
}
}
}
}
}
}
结果:
三.采用多字段进行分组,将adCode,userId进行分组统计:
{
"query": {
"bool": {
"must": [
{
"term": {
"sex": 2
}
},
{
"range": {
"endTime": {
"from": 1580486400000,
"to": 1582991999000,
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
}
],
"filter": [
{
"range": {
"registerTime": {
"from": 1580486400000,
"to": 1582991999000,
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
}
],
"disable_coord": false,
"adjust_pure_negative": true,
"boost": 1
}
},
"size": 0,
"aggs": {
"agg_data": {
"terms": {
"field": "adCode.keyword",
"size": 1000
},
"aggs": {
"agg_lable": {
"terms": {
"field": "userId"
}
}
}
}
}
}
结果: