Performing Pipeline Aggregations in Elasticsearch 7.13

3 hours
  • 3 Learning Objectives

About this Hands-on Lab

Sometimes what we’d like to aggregate is the output of a previous aggregation. In Elasticsearch, we can accomplish this through pipeline aggregations. In this hands-on lab, we will write pipeline aggregations in Elasticsearch to further aggregate our data in order to answer more complex questions.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Craft an Aggregation to Answer the Question: What Is the Total Distance Travelled per Day and on Which Day was the Most Distance Travelled?

From the Kibana console, craft a pipeline aggregation on the flights dataset that answers the question.

Craft an Aggregation to Answer the Question: What Is the Cumulative Sum of Flight Delay Time in Minutes per Day?

From the Kibana console, craft a pipeline aggregation on the flights dataset that answers the question.

Craft an Aggregation to Answer the Question: What Is the Change in Average Ticket Price per Day and What Is the `min`, `max`, `avg`, and `sum` of That Change?

From the Kibana console, craft a pipeline aggregation on the flights dataset that answers the question.

Additional Resources

Logging In to the Elastic Environment

  1. Navigate to the public IP address of the es1 node provided on the lab page (e.g., http://public_ip).
  2. Log in to Elastic using the username elastic and password elastic_acg.

Lab Scenario

You work as a data analyst for an international airport. You've been tasked with answering the following questions using your company's flights dataset stored in Elasticsearch:

  • Question 1: What is the total distance travelled per day and on which day was the most distance travelled?
  • Question 2: What is the cumulative sum of flight delay time in minutes per day?
  • Question 3: What is the change in average ticket price per day and what is the min, max, avg, and sum of that change?

For each aggregation, set the hits array size to 0 to simplify the aggregation output.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?