CODEWITHSUNDEEP
elasticsearchelasticsearch-aggregation
Hamid Reza Khanmirza
Hamid Reza Khanmirza

Reputation: 63

Elastic Search getting average of doc_count out of terms aggregation

I have terms query as follow in elastic search.

GET http://localhost:9200/adapters/request/_search
{
    "query": {
        "bool" : {
            "must" : {
                "match" : { "adapterName" : "EnginePushableAdapter" }
            },
            "filter": {
                "range" : {
                    "request.requestTime" : {
                        "gte" : 1492080226172,
                        "lte" : 1492080725964
                    }
                }
            }
        }
    }, 
    "aggs" : {
        "call_count" : {
            "terms" : {
                "field" : "deviceId"          
            }
        }
    }
}

Is there a way to calcaulate the average of doc_count returned by terms aggregation?like this 

    "avg_agg" : {
        "avg": { "field": "call_count.doc_count" }

    }

In other words, I want to take average of the previous aggregation fields.

Upvotes: 6

Views: 4980

Answers (1)

Ervin
Ervin

Reputation: 746

I think you may be looking for the average bucket aggregation.

https://www.elastic.co/guide/en/elasticsearch/reference/5.3/search-aggregations-pipeline-avg-bucket-aggregation.html

Try something like 

...
"my_count_avg": {
  "avg_bucket": {
    "buckets_path": "call_count>_count"
  }
}

Upvotes: 7

Related Questions