Lab
A Cloud Guru

Creating Line and Area Visualizations in Kibana 7.6

Line and area visualizations are so similar in appearance, but each has its own strengths in the types of questions they are used to answer. In this hands-on lab, we will leverage line and area visualizations in Kibana to answer some questions about our data.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

2h 0m

Published

Jul 20, 2021

Challenge

Create and Save the Sales Velocity over Time Visualization
1. Create a new line visualization.
2. Calculate the rate of change (derivative) of the total number of products.price, label it as " Velocity", and display it as a dollar amount with 2 decimal places (example: 1,234.567 as $1,234.56).
3. Configure the x-axis as a date histogram of the field order_date labelled as "Time" with an automatic interval and no partial buckets.
4. Add a threshold line at the value "0".
5. Save the visualization as "Sales Velocity Over Time".
Challenge

Create and Save the Sales over Time Visualization
1. Create a new line visualization.
2. Calculate the total number of products.quantity and label it as "Items".
3. On a separate y-axis, calculate the total number of products.price label it as "Sales", and display it as a dollar amount with 2 decimal places (example: 1,234.567 as $1,234.56).
4. Configure the x-axis as a date histogram of the field order_date labelled as "Time" with an automatic interval and no partial buckets.
5. Save the visualization as "Sales Over Time".
Challenge

Create and Save the Sales by Category over Time Visualization
1. Create a new area visualization.
2. Calculate the total number of products.price, label it as "Sales", and display it as a dollar amount with 2 decimal places (example: 1,234.567 as $1,234.56).
3. Split the chart on the top 5 of customer_gender ordered by the sales in descending order and labelled as "Gender".
4. Split the series on the top 3 of category.keyword ordered by the sales in descending order and labelled as "Category"
5. Configure the x-axis as a date histogram of the field order_date labelled as "Time" with an automatic interval and no partial buckets.
6. Save the visualization as "Sales by Category Over Time".

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.