Problem with average response time

Elastic Stack Elasticsearch
1

We are trying to execute below query but unable to get the average of a specific field , but if we use only the "app_id" we get the average response time , and if we use "app_id" and "contaner_url" we get the result but the average response time is always null, kindly help.

GET /_search
{
"from": 0,
"size": 10,
"aggs": {
"avg_response_time": {
"avg": {
"field": "timer_page_load"
}
}
},
"query": {
"bool": {
"must":[
{
"term": {
"app_id": "40DNASLD"
}
},
{
"term": {
"container_url.keyword" : "https://xyz.abc.com/smartit/app/#/ticket-console"
}
}
],
"filter": {
"range": {
"timestamp": {
"gte": "now-15m",
"lt": "now"
}
}
}
}
},
"sort": [
{
"timestamp": {
"order": "desc"
}
}
]
}

2

if you execute that query without aggs and without filtering for app_id, just using the container_url.keyword filter. Do you get any results?

--Alex

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.