How to count a field if value is not null in elasticsearch

Question

I have indexed some documents in ElasticSearch. Short view looks like this:

{
  "tenant_id":"abcd1234"
  "provider_id":"3456"
   .
   .
   .
   "doctor_summary": ["line1", "line2", "line3"] OR it could be null.
}

I want to calculate this list as 1 if not null,

     query_template = {

        "bool":{
            "must":[
                {"term":{"tenant_id.keyword":tenant_id}},
                {"term":{"provider_id.keyword":provider_id}},
                {"range":{"visit_date":{"gte":from_date,"lte":to_date}}},
                
            ],
            "filter":[]
        
        }
    }



aggs_query = {
   "doctor_summary_count":{
            "value_count":{"field":"doctor_summary.keyword"}
        }
}    

res = CLIENT.search(index = config['elasticsearch']['abcd'],
                        query = query_template,
                        size = 10000,
                        aggs = aggs_query)

After calling this aggregation query, it gives result as ( size of the list * total doctor_summary field).

For example: the result of above query on above document should be 1. (As it is not null). But it gives as 3(because list contains 3 lines.)

Sagar Patel · Accepted Answer · 2022-04-29 08:48:05Z

2

You can use exist query in aggregation with filter aggregation.

Query:

{
  "aggs": {
    "count": {
      "filter": {
       "exists": {
         "field": "doctor_summary.keyword"
       }
      }
    }
  }
}

Response:

"aggregations" : {
    "count" : {
      "doc_count" : 1
    }
  }

answered Apr 29, 2022 at 8:48

Sagar Patel

5,5161 gold badge11 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

How to count a field if value is not null in elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related