Count based on number of occurrences - ElasticSearch

Question

I have indexed around 30K documents in an ElasticSearch index. Each of these documents has a field called severity, which is an Integer value. These integers can range from 0 to 5, in increments of 1 (0,1,2,3,4,5). I would like to get a count of the number of documents with severity 0, severity 1, severity 2, etc....

I have tried value_count and range, but they both seem to be unsuitable for my purpose.

This is what one of my documents looks like. Some values have been removed, but the essential thing is to aggregate based on severity

{
   "_index": "incident_db",
   "_type": "incidents",
   "_source": {
      "incident": {
         "name": "something",
         "severity": 3
      }
   }
}

Val · Accepted Answer · 2016-05-19 13:32:29Z

3

Why not simply using a terms aggregation like this:

POST /incident_db/_search
{
  "size": 0,
  "aggs": {
    "counts": {
      "terms": {
        "field": "incident.severity"
      }
    }
  }
}

answered May 19, 2016 at 13:32

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Abhay Bhargav Over a year ago

Thanks! I didnt realize in my n00bness that I can do a term search in ES.

Abhay Bhargav Over a year ago

Sorry, I meant to immediately do that, but it didnt allow me to. Thanks again

Collectives™ on Stack Overflow

Count based on number of occurrences - ElasticSearch

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related