es聚合date_histogram 嵌套date_range 查询每日支付数据七天之内注册用户的数据
Elasticsearch | 作者 JustRun | 发布于2019年09月19日 | 阅读数:2108
GET xxxxxxxx/_search
{
"query": {
"bool": {
"must": [
{
"range": {
"order_create_time": {
"gte": 1568044800000,
"lte": 1568822400000
}
}
},
{
"term": {
"order_pay_status": {
"value": "1"
}
}
}
]
}
},
"size":1,
"aggs": {
"pay_day": {
"date_histogram": {
"field": "order_create_time",
"calendar_interval" : "day",
"time_zone": "+01:00",
"format": "yyyy-MM-dd",
"order" : { "_key" : "desc" }
},
"aggs": {
"pay_register_day": {
"date_range": {
"field": "user_register_time",
"format": "yyyy-MM-dd",
"time_zone": "+01:00",
"ranges": [
{"from": "now-7d/d"} //这里应该是当日的支付时间(格式化的order_create_time)-7天,该怎么写呢?
]
}
}
}
}
}
}
{
"query": {
"bool": {
"must": [
{
"range": {
"order_create_time": {
"gte": 1568044800000,
"lte": 1568822400000
}
}
},
{
"term": {
"order_pay_status": {
"value": "1"
}
}
}
]
}
},
"size":1,
"aggs": {
"pay_day": {
"date_histogram": {
"field": "order_create_time",
"calendar_interval" : "day",
"time_zone": "+01:00",
"format": "yyyy-MM-dd",
"order" : { "_key" : "desc" }
},
"aggs": {
"pay_register_day": {
"date_range": {
"field": "user_register_time",
"format": "yyyy-MM-dd",
"time_zone": "+01:00",
"ranges": [
{"from": "now-7d/d"} //这里应该是当日的支付时间(格式化的order_create_time)-7天,该怎么写呢?
]
}
}
}
}
}
}
3 个回复
JustRun - just run
赞同来自:
JustRun - just run
赞同来自:
yjnnyqqq
赞同来自: