# Creating Line and Area Visualizations in Kibana 7.6

2 hours
• 3 Learning Objectives

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.

## Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

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".
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".
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".

You work as a data analyst for an online clothing store. You've been tasked with creating the following line and area chart visualizations in Kibana to analyze the trends in product sales over time:

Line Chart: Sales Velocity Over Time

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

Line Chart: Sales Over Time

• Calculate the total number of `products.quantity` and label it as "Items".
• 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).
• Configure the x-axis as a date histogram of the field `order_date` labelled as "Time" with an automatic interval and no partial buckets.

Area Chart: Sales by Category Over Time

• 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).
• Split the chart on the top 5 of `customer_gender` ordered by the sales in descending order and labelled as "Gender".
• Split the series on the top 3 of `category.keyword` ordered by the sales in descending order and labelled as "Category"
• Configure the x-axis as a date histogram of the field `order_date` labelled as "Time" with an automatic interval and no partial buckets.

Your lab node node has an Kibana instance that 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.