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.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create and Save the Flights Visualization
- Create a new Markdown visualization with the TSVB.
- Calculate the number of events, label it as "Flights", and give it a variable name of "flights".
- Calculate the cardinality of
OriginCityName, label it as "Origin Cities", and give it a variable name of "origins". - Calculate the cardinality of
DestCityName, label it as "Destination Cities", and give it a variable name of "destinations". - Configure the visualization to display the latest value with 1-day intervals, and do not drop the last bucket.
- 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.- Save the visualization as "Flights".
- Create and Save the Delayed Flights Visualization
- Create a new Markdown visualization with the TSVB.
- Calculate the count of events where
FlightDelayistrue, label it "Delayed Today", and give it a variable name of "delayed_today". - Configure the Delayed Today metric to display the latest value with 1-day intervals, and do not drop the last bucket.
- Calculate the count of events with an offset of 1 day where
FlightDelayistrue, label it "Delayed Yesterday", and give it a variable name of "delayed_yesterday". - Configure the Delayed Yesterday metric to display the last value with 1-day intervals, and do not drop the last bucket.
- 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.- Save the visualization as "Delayed Flights".
- Create and Save the Flights by Carrier Visualization
- Create a new Markdown visualization.
- Calculate the number of flights, label it "Flights", and give it a variable name of "flights".
- Group Flights by the top 10 of
Carrier, ordered by the number of flights in descending order. - Configure the visualization to display the latest value with 1-day intervals, and do not drop the last bucket.
- 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}}- Save the visualization as "Flights by Carrier" with the TSVB.
