2.3 Visualize order data in a dashboard

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. 1. Segment by => Year & Month
      2. Summarize by => SUM of gross_revenue

optional:

• Add a breakdown by shipping_county

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. 1. View by => shipping_country
      2. Segment by => shipping_city
      3. Measures => SUM of gross_revenue

Video Explanation