The Time Series Visual Builder (TSVB) is a great way of visualizing top “n” aggregations within time series data. By showcasing data in this way, we can visually represent the significance of the most recent values in a time-series. In this hands-on lab, we will leverage the TSVB in Kibana to create Top N visualizations from time-series data.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create and Save the Top Categories Visualization
- Create a new top n visualization with the TSVB.
- Calculate the sum of
products.quantity, label it as Items Sold, and color it blue. - Group Items Sold by the top 10 of
products.category.keywordby items sold in descending order. - Configure the visualization to show the latest value with daily intervals and do not drop the last bucket.
- Save the visualization as "Top Categories".
- Create and Save the Top Manufacturers by Unique Products Visualization
- Create a new top n visualization with the TSVB.
- Calculate the cardinality of
products.product_name.keyword, label it as Products, and color it green. - Group Products by the top 10 of
products.manufacturer.keywordby products in descending order. - Configure the visualization to show the latest value with daily intervals and do not drop the last bucket.
- Save the visualization as "Top Manufacturers by Unique Products".
- Create and Save the Top Cities by Sales Visualization
- Create a new top n visualization with the TSVB.
- Calculate the sum of
products.price, label it as Sales, color it orange, and display it as a dollar amount with 2 decimal places (example: 1,234.567 as $1,234.56). - Group Sales by the top 10 of
geoip.city_nameby sales in descending order. - Configure the visualization to show the latest value with daily intervals and do not drop the last bucket.
- Save the visualization as "Top Cities by Sales".
