Creating Lens Visualizations in Kibana 7.6

2 hours
  • 3 Learning Objectives

About this Hands-on Lab

So you have a question but you’re not entirely sure how to visually communicate the answer. WIth Kibana, we can let lens suggest how best to visualize the answer to our questions. In this hands-on lab, we will leverage the lens interface in Kibana to create intuitive visualizations.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create and Save the “Unique Products Sold Over Time by Manufacturer” Visualization
  1. Create a new Lens visualization.
  2. Select the stacked bar chart configuration.
  3. Configure the x-axis as a date histogram of the field order_date labeled as "Order Date."
  4. Configure the y-axis as a unique count of the field products.product_id labeled as "Unique Products."
  5. Configure a breakdown of the top 10 values of the field products.manufacturer.keyword ordered by the number of unique products in descending order and labeled as "Manufacturer."
  6. Save the visualization as "Unique Products Sold Over Time by Manufacturer."
Create and Save the “Popular Product Categories by Items Sold per Country” Visualization
  1. Create a new Lens visualization.
  2. Select the stacked horizontal bar chart configuration.
  3. Configure the y-axis as the sum of the field products.quantity labeled as "Items Sold."
  4. Configure the x-axis as the top 6 values of the field products.category.keyword ordered by the number of items sold in descending order and labeled as "Category."
  5. Configure a breakdown of the top 10 values of the field geoip.country_iso_code for each category ordered by the number of items sold in descending order and labeled as "Country."
  6. Save the visualization as "Popular Product Categories by Items Sold per Country."
Create and Save the “Top Customers” Visualization
  1. Create a new Lens visualization.
  2. Select the data table configuration.
  3. Add a column for the top 10 values of customer_full_name.keyword, and label it as "Customer."
  4. Add a column for the count of orders, and label it "Orders."
  5. Add a column for the sum of products.quantity, and label it "Items."
  6. Add a column for the sum of products.price, label it as "Dollars," and format it as a dollar amount with 2 decimal places (example: 1,234.567 as $1,234.56).
  7. Order the Customers column by Dollars in descending order.
  8. Save the visualization as "Top Customers."

Additional Resources

You work as a data analyst for a department store chain. You've been tasked with creating the following Lens visualizations in Kibana to help track clothing sales internationally:

Unique Products Sold Over Time by Manufacturer

  • Select the stacked bar chart configuration.
  • Configure the x-axis as a date histogram of the field order_date labeled as "Order Date."
  • Configure the y-axis as a unique count of the field products.product_id labeled as "Unique Products."
  • Configure a breakdown of the top 10 values of the field products.manufacturer.keyword ordered by the number of unique products in descending order and labeled as "Manufacturer."

Popular Product Categories by Items Sold per Country

  • Select the stacked horizontal bar chart configuration.
  • Configure the y-axis as the sum of the field products.quantity labeled as "Items Sold."
  • Configure the x-axis as the top 6 values of the field products.category.keyword ordered by the number of items sold in descending order and labeled as "Category."
  • Configure a breakdown of the top 10 values of the field geoip.country_iso_code for each category ordered by the number of items sold in descending order and labelled as "Country."

Top Customers

  • Select the data table configuration.
  • Add a column for the top 10 values of customer_full_name.keyword, and label it as "Customer."
  • Add a column for the count of orders, and label it "Orders."
  • Add a column for the sum of products.quantity, and label it "Items."
  • Add a column for the sum of products.price, label it as "Dollars," and format it as a dollar amount with 2 decimal places (example: 1,234.567 as $1,234.56).
  • Order the Customers column by Dollars in descending order.

Your lab node has a Kibana instance, which can be accessed in your local web browser. Follow the steps below to log in:

  1. Navigate to the public IP address of the lab node over port 8080 (i.e., http://<PUBLIC_IP>:8080).
  2. Log in to the Kibana instance using the following credentials:
    • Username: elastic
    • 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.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?