📊 Outcome: Visualized sales data

🕑 Estimated Time: ~15min

 

Introduction

You have now prepared an order table that is ready to use for reports and dashboards. In this section, you will learn different options on how to visualize your sales data in Y42.

Step-by-step guide

Chart 1: Bar chart

  1. Open VISUALIZE and create a new visualization "Sales dashboard"
  2. Add a new widget and select the output table "shopify_orders" which you have created before
  3. Create a bar chart with following settings to analyze your shop's performance month over month:
      1. Segment by => Year & Month
      2. Summarize by => SUM of gross_revenue

Bildschirmfoto_2021-10-08_um_17.25.11.png

optional:

  • Add a breakdown by shipping_county

Bildschirmfoto_2021-10-08_um_17.58.40.png

 

 

Chart 2: Treemap

  1. Add a new tab "Sales by country & city"
  2. Add a new widget and select the output table "shopify_orders" again
  3. Create a treemap widget with the following settings to analyze your shop's performance by country and city:
      1. View by => shipping_country
      2. Segment by => shipping_city
      3. Measures => SUM of gross_revenue

Bildschirmfoto_2021-10-08_um_17.59.47.png

Video Explanation

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.