Creating Time Series Visualizations with the Time Series Visual Builder (TSVB) in Kibana 7.6

2 hours
  • 3 Learning Objectives

About this Hands-on Lab

The Time Series Visual Builder (TSVB) in Kibana provides a more detailed and customizable way of visualizing data. In this hands-on lab, you will use the TSVB to create elaborate time series visualizations.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create and save the Flights by Status Over Time visualization
  1. Create a new time series visualization with the TSVB.
  2. Calculate the number of events and label it as Flights.
  3. Group Flights by the following filters:
    • Cancelled and FlightDelay are both false, labelled as On Time, and colored green.
    • FlightDelay is true, labelled as Delayed, and colored yellow.
    • Cancelled is true, labelled as Cancelled, and colored red.
  4. Configure the visualization as a stacked bar chart with 1 hour time intervals.
  5. Save the visualization as "Flights by Status Over Time."
Create and save the Flight Delays by Delay Type Over Time visualization
  1. Create a new time series visualization with the TSVB.
  2. Calculate the number of events where FlightDelay is true, and label it as Delays.
  3. Group Delays by the top 10 of FlightDelayType ordered by the number of delays in descending order.
  4. Configure the visualization as a stacked bar chart with the rainbow split color theme and 1 hour time intervals.
  5. Add a second series that calculates the number of events where FlightDelay is true, and label it as Total Delays.
  6. Configure the Total Delays series as an invisible line graph. (We just want to see the value in the legend and tooltip).
  7. Save the visualization as "Flight Delays by Delay Type Over Time."
Create and save the Flights by Carrier Over Time visualization
  1. Create a new time series visualization with the TSVB.
  2. Calculate the number of events where Cancelled is false and label it as Flights.
  3. Group Flights by the top 10 carriers ordered by the number of flights in descending order.
  4. Configure the visualization as a stacked bar chart with the rainbow split color theme and 1 hour time intervals.
  5. Add an annotation with the following requirements:
    • Annotates all occurrences of a cancelled flight (Cancelled is true).
    • Annotates using a red line and the "Exclamation Triangle" icon.
    • Annotations should display "Cancelled Flight: " followed by the flight number (FlightNum).
  6. Save the visualization as "Flights by Carrier Over Time."

Additional Resources

You work as a data analyst for an online booking company. You've been tasked with creating the following TSVB time series visualizations in Kibana to monitor the hourly status of flights for a number of carriers:

Flights by Status Over Time

  • Calculate the number of events and label it as Flights.
  • Group Flights by the following filters:
    • Cancelled and FlightDelay are both false, labelled as On Time and colored green.
    • FlightDelay is true, labelled as Delayed and colored yellow.
    • Cancelled is true, labelled as Cancelled and colored red.
  • Configure the visualization as a stacked bar chart with 1 hour time intervals.

Flight Delays by Delay Type Over Time

  • Calculate the number of events where FlightDelay is true and label it as Delays.
  • Group Delays by the top 10 of FlightDelayType ordered by the number of delays in descending order.
  • Configure the visualization as a stacked bar chart with the rainbow split color theme and 1 hour time intervals.
  • Add a second series that calculates the number of events where FlightDelay is true and label it as Total Delays.
  • Configure the Total Delays series as an invisible line graph (We just want to see the value in the legend and tooltip).

Flights by Carrier Over Time

  • Calculate the number of events where Cancelled is false and label it as Flights.
  • Group Flights by the top 10 carriers ordered by the number of flights in descending order.
  • Configure the visualization as a stacked bar chart with the rainbow split color theme and 1 hour time intervals.
  • Add an annotation with the following requirements:
    • Annotates all occurrences of a cancelled flight (Cancelled is true).
    • Annotates using a red line and the "Exclamation Triangle" icon.
    • Annotations should display "Cancelled Flight: " followed by the flight number (FlightNum).

Your lab node node has a Kibana instance which can be accessed in your local web browser by navigating to the public IP address of the lab node over port 8080 (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?