Lab
A Cloud Guru

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

Sometimes the best way to visualize data is to just read it. Creating Markdown-formatted visualizations from time series data in Kibana is made possible by the TSVB. In this hands-on lab, you will leverage Markdown and Mustache syntax to create easy-to-read and understandable text-based visualizations from time series data.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

1h 30m

Published

Jul 20, 2021

Challenge

Create and Save the Flights Visualization
1. Create a new Markdown visualization with the TSVB.
2. Calculate the number of events, label it as "Flights", and give it a variable name of "flights".
3. Calculate the cardinality of OriginCityName, label it as "Origin Cities", and give it a variable name of "origins".
4. Calculate the cardinality of DestCityName, label it as "Destination Cities", and give it a variable name of "destinations".
5. Configure the visualization to display the latest value with 1-day intervals, and do not drop the last bucket.
6. Configure the Markdown visualization as follows:
```
So far today, **{{ flights.flights.last.formatted }}** flights have been flown between **{{ origin_cities.origins.last.formatted }}** origin and **{{ destination_cities.destinations.last.formatted }}** destination cities.
```
1. Save the visualization as "Flights".
Challenge

Create and Save the Delayed Flights Visualization
1. Create a new Markdown visualization with the TSVB.
2. Calculate the count of events where FlightDelay is true, label it "Delayed Today", and give it a variable name of "delayed_today".
3. Configure the Delayed Today metric to display the latest value with 1-day intervals, and do not drop the last bucket.
4. Calculate the count of events with an offset of 1 day where FlightDelay is true, label it "Delayed Yesterday", and give it a variable name of "delayed_yesterday".
5. Configure the Delayed Yesterday metric to display the last value with 1-day intervals, and do not drop the last bucket.
6. Configure the Markdown visualization as follows:
```
### Delayed Flights:

So far today, **{{ delayed_today.delayed_today.last.formatted }}** flights have been delayed compared to **{{ delayed_yesterday.delayed_yesterday.last.formatted }}** delayed flights yesterday.
```
1. Save the visualization as "Delayed Flights".
Challenge

Create and Save the Flights by Carrier Visualization
1. Create a new Markdown visualization.
2. Calculate the number of flights, label it "Flights", and give it a variable name of "flights".
3. Group Flights by the top 10 of Carrier, ordered by the number of flights in descending order.
4. Configure the visualization to display the latest value with 1-day intervals, and do not drop the last bucket.
5. Configure the Markdown visualization as follows:
```
Here are the flights broken down by carrier for the day so far:

{{#each _all}}
- **{{ label}}**: {{ flights.last.raw }}
{{/each}}
```
1. Save the visualization as "Flights by Carrier" with the TSVB.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.