Filter aggregation in Elasticsearch - Mini Project: Build & Apply

Filter aggregation

📖 Scenario: You have a collection of products in an online store. Each product has a category and a price. You want to find out how many products are in the electronics category and cost less than 500.

🎯 Goal: Create an Elasticsearch query using filter aggregation to count products that belong to the electronics category and have a price less than 500.

📋 What You'll Learn

Create a filter aggregation named electronics_under_500

Use a bool query with must conditions for category equals electronics and price less than 500

Include a match_all query at the top level

Print the full JSON query as the final output

💡 Why This Matters

🌍 Real World

Filter aggregations help online stores analyze product counts based on multiple conditions, like category and price, to make business decisions.

💼 Career

Understanding filter aggregations is important for roles involving Elasticsearch, data analysis, and search engine optimization.

1

Create the base query

Create a JSON object called query with a match_all query inside it.

Elasticsearch

{
  "query": {
    "match_all": {}
  }
}
# Your code here

Need a hint?

The match_all query returns all documents.

2

Add filter aggregation

Add an aggs field to the JSON with a filter aggregation named electronics_under_500.

Elasticsearch

{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "electronics_under_500": {
      "filter": {
        
      }
    }
  }
}
# Your code here

Need a hint?

The filter aggregation lets you count documents matching a filter.

3

Define the filter conditions

Inside the filter aggregation, add a bool query with must conditions: one for term category equals electronics and one for range price less than 500.

Elasticsearch

{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "electronics_under_500": {
      "filter": {
        "bool": {
          "must": [
            
          ]
        }
      }
    }
  }
}
# Your code here

Need a hint?

Use bool with must array to combine filters.

4

Print the final query

Print the full JSON query object exactly as defined in the previous steps.

Elasticsearch

{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "electronics_under_500": {
      "filter": {
        "bool": {
          "must": [
            { "term": { "category": "electronics" } },
            { "range": { "price": { "lt": 500 } } }
          ]
        }
      }
    }
  }
}
# Your code here

Need a hint?

Use print() to display the JSON object.