shiko
(shiko)
August 26, 2020, 9:17am
1
I'm kind of a new user for ES and Kibana.
I have a question about the Bucket Script Aggregation
I'm trying to do some calculations with ES, the division of 2 queries ( the ratio).
when I send the queries , it's working .
when I'm using the bucket script aggs to do the devison , it gives me an erorr
// "type": "parsing_exception", "reason": "Unknown key for a START_OBJECT in [news_attention].", "line": 31, "col": 21
this is my query : photo attached
The problem is in your nesting. Count_articles_1
and your bucket script agg need to be nested under aggs
and not siblings to aggs
1 Like
shiko
(shiko)
August 29, 2020, 7:16am
4
this is my query after the modification you proposed,
Thanks alot for helping out.
Blockquote
GET /index/_search
{
"size": 0,
"aggs": {
"count_for_7d": {
"date_range": {
"field": "publishDate",
"format": "yyyy-MM-dd",
"ranges": [
{
"from":"now-8d",
"to": "now-1d",
"key": "count_for_7d"
}
]
}
},
"count_for_1d": {
"date_range": {
"field": "publishDate",
"format": "yyyy-MM-dd",
"ranges": [
{
"from": "now-1d",
"to": "now",
"key": "count_for_1d"
}
]
}
}
,
"my_bucket": {
"bucket_script" :{
"buckets_path":{
"count_for_7d" :"count_for_7d",
"count_for_1d":"count_for_1d",
"key": "my_bucket"
},
"script" : "params.count_for_1d / (params.count_for_1d / 7)"
}
}
}
}
> Blockquote
shiko
(shiko)
September 7, 2020, 9:32am
5
Hello,
It took me some time to have the solution, due to I'm new to ES.
There is the final query that works
GET /index/_search
{
"size": 0,
"aggs": {
"last_week": {
"date_range": {
"field": "publishDate",
"ranges": [
{
"from": "now-8d/d",
"to": "now"
}
]
},
"aggs": {
"count_for_7d": {
"value_count": {
"field": "id"
}
},
"count_for_1d": {
"filter": {
"range": {
"publishDate": {
"gte": "now-1d/d",
"lte": "now"
}
}
},
"aggs": {
"count_1d": {
"value_count": {
"field": "id"
}
}
}
},
"My_Bucket": {
"bucket_script": {
"buckets_path": {
"count_7d": "count_for_7d",
"count_1d": "count_for_1d>count_1d"
},
"script": "(params.count_1d / (params.count_7d - params.count_1d / 7))"
}
}
}
}
}
}
Cheers
system
(system)
Closed
October 5, 2020, 9:32am
6
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.