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
- Create a new data table visualization.
- 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". - Save the visualization as "Flight Distance by Carrier".
- Create and Save the Delayed Time by Flight Delay Visualization
- Configure the
FlightDelayMin
field to display as a human readable duration. - Create a new data table visualization.
- Compute the average of
FlightDelayMin
labeled as "Average". - Compute the sum of
FlightDelayMin
labeled as "Total". - 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" - Save the visualization as "Delayed Time by Flight Delay".
- Configure the
- Create and Save the Top Destinations by Flights per Carrier Visualization
- Create a new data table visualization.
- 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". - Save the visualization as "Top Destinations by Flights per Carrier".