Search⌘ K
AI Features

Challenge: Aggregations

Explore how to perform and combine different aggregation queries in Elasticsearch using a movie dataset. Learn to calculate average earnings by studio, count movies by release year, analyze runtime distributions, and identify top-rated movies by category. This lesson helps you understand practical aggregation techniques to derive insights from complex datasets.

Challenge

You are working with a dataset of movie information stored in Elasticsearch. The dataset includes several attributes for each movie, such as title, lifetime_gross, year, studio, rating, runtime, budget, releaseDate, voteAvg, and voteCount. Your task is to perform different aggregation queries in Elasticsearch.

The movies index comprises several fields with their respective data types and purposes, including:

  • title: This text ...