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

1.5 hours
  • 3 Learning Objectives

About this Hands-on Lab

Tables are, and have been, a go-to method for displaying information in a readable and easy-to-understand way. Using the Time Series Visual Builder (TSVB) in Kibana, we can take this a step further by creating table visualizations that capitalize on time-series data and display the latest values of fields groups in the familiar, data table format. In this hands-on lab, we will leverage the TSVB to create data table visualizations with time series data.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create and Save the Top Clients Visualization
  1. Create a new table visualization with the TSVB.
  2. Group by the top 10 of clientip and label it as Client.
  3. Calculate the number of events and label it as Requests.
  4. Calculate the sum of bytes, label it as Data, and format it as a bytes number.
  5. Configure the visualization to show the entire time range.
  6. Save the visualization as "Top Clients".
Create and Save the Top Operating Systems Visualization
  1. Create a new table visualization with the TSVB.
  2. Group by the top 10 of machine.os.keyword and label it as OS.
  3. Calculate the number of events and label it as Requests.
  4. Calculate the cardinality of clientip and label it as Clients.
  5. Configure the visualization to show the entire time range.
  6. Save the visualization as "Top Operating Systems".
Create and Save the Top Request Paths Visualization
  1. Create a new table visualization with the TSVB.
  2. Group by the top 10 of request.keyword and label it as Request Path.
  3. Calculate the number of events and label it as Requests.
  4. Calculate the cardinality of clientip and label it as Clients.
  5. Calculate the sum of bytes, label it as Data, and format it as a bytes number.
  6. Configure the visualization to show the entire time range.
  7. Save the visualization as "Top Request Paths".

Additional Resources

You work as a data administrator working in the network operations center of your company's IT department. You have been tasked with creating the following TSVB table visualizations in Kibana to monitor the access logs for your company's website:

Top Clients

  • Group by the top 10 of clientip and label it as Client.
  • Calculate the number of events and label it as Requests.
  • Calculate the sum of bytes, label it as Data, and format it as a bytes number.
  • Configure the visualization to show the entire time range.

Top Operating Systems

  • Group by the top 10 of machine.os.keyword and label it as OS.
  • Calculate the number of events and label it as Requests.
  • Calculate the cardinality of clientip and label it as Clients.
  • Configure the visualization to show the entire time range.

Top Request Paths

  • Group by the top 10 of request.keyword and label it as Request Path.
  • Calculate the number of events and label it as Requests.
  • Calculate the cardinality of clientip and label it as Clients.
  • Calculate the sum of bytes, label it as Data, and format it as a bytes number.
  • Configure the visualization to show the entire time range.

Your lab node node has an 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?