Magento Business Intelligence Help Center

Year-over-year, month-over-month, week-over-week

The report builder allows you to easily see trends over time and change perspective for time periods you may want to compare. In this article, we will demonstrate how to set up a dashboard to go a level deeper to allow you to create reports for week over week, month over month and year over year analysis.

Before getting started, you will want to familiarize yourself with explore perspectives in more detail here as well as independent time options here.

This analysis contains advanced calculated columns that can only be created by a Magento BI analyst, so file a support request with the subject [YoY MoM WoW ANALYSIS] before getting started with this analysis.

  • Sales_flat_order table
    • created_at (month-day) will be created by an analyst as part of your [YoY WoW MoM ANALYSIS] ticket
    • created_at (month) will be created by an analyst as part of your [YoY WoW MoM ANALYSIS] ticket
    • created_at (day of the month) will be created by an analyst as part of your [YoY WoW MoM ANALYSIS] ticket
    • created_at (day of the week) will be created by an analyst as part of your [YoY WoW MoM ANALYSIS] ticket
    • created_at (hour of the day) will be created by an analyst as part of your [YoY WoW MoM ANALYSIS] ticket

None!!!

Note: Make sure to add all new columns as dimensions to metrics before building new reports.

  • YoY chart
    • Metric A: This year
      • Metric: Number of orders
    • Metric B: Last year
      • Metric: Number of orders
      • Time options: Time range (Custom): 2 years ago to 1 year ago
    • Time period: 1 year ago to 0 years ago
    • Interval: None
    • Group by: created_at (month-day)
      • Show top/bottom: Top 100% sorted by created_at (month-day)
    • Chart Type: Line
  • MoM chart
    • Metric A: This month
      • Metric: Number of orders
    • Metric B: Last month
      • Metric: Number of orders
      • Time options: Time range (Custom): 2 months ago to 1 month ago
    • Time period: 1 month ago to 0 months ago
    • Interval: None
    • Group by: created_at (day of month)
      • Show top/bottom: Top 100% sorted by created_at (day of month)
    • Chart Type: Line
  • WoW chart
    • Metric A: This week
      • Metric: Number of orders
    • Metric B: Last week
      • Metric: Number of orders
      • Time options: Time range (Custom): 2 weekss ago to 1 week ago
    • Time period: 1 week ago to 0 weeks ago
    • Interval: None
    • Group by: created_at (day of week)
      • Show top/bottom: Top 100% sorted by created_at (day of week)
    • Chart Type: Line
  • DoD chart
    • Metric A: Today
      • Metric: Number of orders
    • Metric B: Yesterday
      • Metric: Number of orders
      • Time options: Time range (Custom): 2 days ago to 1 day ago
    • Time period: 1 day ago to 0 days ago
    • Interval: None
    • Group by: created_at (hour of day)
      • Show top/bottom: Top 100% sorted by created_at (hour of day)
    • Chart Type: Line

After compiling all the reports, you can organize them on the dashboard as you desire. The end result may look like the image at the top of this page.

If you run into any questions while building this analysis, or simply want to engage our professional services team to build the analysis for you, simply open a support ticket here.

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

Comments

Powered by Zendesk