Creating Data Table Visualizations in Kibana 7.6

1 hour
  • 3 Learning Objectives

About this Hands-on Lab

Data tables always have been and will continue to be a popular and intuitive way of visually structuring data in a human-readable way. In this hands-on lab, we will focus on creating and formatting data tables in Kibana.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create and Save the Flight Distance by Carrier Visualization
  1. Create a new data table visualization.
  2. Compute the sum of DistanceMiles labeled as "Miles".
  3. Compute the sum of DistanceKilometers labeled as "Kilometers".
  4. Split the rows on the top 5 of Carrier ordered by the total distanced travelled in descending order and labelled as "Carrier".
  5. Save the visualization as "Flight Distance by Carrier".
Create and Save the Delayed Time by Flight Delay Visualization
  1. Configure the FlightDelayMin field to display as a human readable duration.
  2. Create a new data table visualization.
  3. Compute the average of FlightDelayMin labeled as "Average".
  4. Compute the sum of FlightDelayMin labeled as "Total".
  5. Split the rows on the top 5 of FlightDelayType ordered by the total delayed time in descending order and labelled as "Delay".
  6. Exclude the FlightDelayType of "No Delay"
  7. Save the visualization as "Delayed Time by Flight Delay".
Create and Save the Top Destinations by Flights per Carrier Visualization
  1. Create a new data table visualization.
  2. Compute the count of flights labelled as "Flights"
  3. Split the table on the top 5 of Carrier ordered by the number of flights in descending order and labelled as "Carrier".
  4. Split the rows on the top 5 of Dest with a separate group for other values ordered by the number of flights in descending order and labelled as "Destination".
  5. Save the visualization as "Top Destinations by Flights per Carrier".

Additional Resources

You work as a data analyst for the Federal Aviation Administration, who is being tasked with creating some data table visualizations in Kibana to communicate statistical information about a subset of airlines and their flight data. The following data table visualizations must be created and saved for later use:

Flight Distance by Carrier

  • Compute the sum of DistanceMiles labeled as "Miles".
  • Compute the sum of DistanceKilometers labeled as "Kilometers".
  • Split the rows on the top 5 of Carrier ordered by the total distanced travelled in descending order and labelled as "Carrier".

Delayed Time by Flight Delay

  • Compute the average of FlightDelayMin labeled as "Average" and displayed as a human readable duration.
  • Compute the sum of FlightDelayMin labeled as "Total" and displayed as a human readable duration.
  • Split the rows on the top 5 of FlightDelayType ordered by the total delayed time in descending order and labelled as "Delay".
  • Exclude the FlightDelayType of "No Delay".

Top Destinations by Flights per Carrier

  • Compute the count of flights labelled as "Flights"
  • Split the table on the top 5 of Carrier ordered by the number of flights in descending order and labelled as "Carrier".
  • Split the rows on the top 5 of Dest with a separate group for other values ordered by the number of flights in descending order and labelled as "Destination".

Your lab node node has an Kibana instance that can be accessed in your local web browser by navigating to the public IP address of the lab node over port 8080 (for example, http://public_ip:8080). To log in, use the "elastic" user with the password "elastic_acg".

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?