Using aggregation with filters in elastic search

Question

I have an elastic search running with documents like this one:

{
  id: 1,
  price: 620000,
  propertyType: "HO",
  location: {
    lat: 51.41999,
    lon: -0.14426
  },
  active: true,
  rentOrSale: "S",
}

I'm trying to use aggregates to get statistics about a certain area using aggregations and the query I'm using is the following:

{
  "sort": [
    {
      "id": "desc"
    }
  ],
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "rentOrSale": "s"
          }
        },
        {
          "term": {
            "active": true
          }
        }
      ]
    },
    "filtered": {
      "filter": {
        "and": [
          {
            "geo_distance": {
              "distance": "15.0mi",
              "location": {
                "lat": 51.50735,
                "lon": -0.12776
              }
            }
          }
        ]
      }
    }
  },
  "aggs": {
    "propertytype_agg": {
      "terms": {
        "field": "propertyType"
      },
      "aggs": {
        "avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    },
    "bed_agg": {
      "terms": {
        "field": "numberOfBedrooms"
      },
      "aggs": {
        "avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  }
}

But in the result I can't see the aggregations. As soon as I remove either the bool or filtered part of the query I can see the aggregations. I can't figure out why this is happening, nor how do I get the aggregations for these filters. I've tried using the answer to this question but I've not been able to solve it. Any ideas?

Olly Cruickshank · Accepted Answer · 2014-12-21 19:19:08Z

1

I think your query need to be slightly re-arranged - move the "filtered" further up and repeat the "query" command:

"query": {
  "filtered": {
   "query" : {
     "bool": {
          ...
     }
   },  
   "filter": {
    ...     
    }
  }
}

edited Dec 21, 2014 at 19:19

answered Dec 21, 2014 at 12:32

Olly Cruickshank

6,2094 gold badges36 silver badges30 bronze badges

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

2 Comments

ip. Over a year ago

Are you sure I need to nest the aggregations? They aggregate separate thing and it seams to be working fine.

Olly Cruickshank Over a year ago

You're right - it does work, I've updated my answer.

Collectives™ on Stack Overflow

Using aggregation with filters in elastic search

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