Magento Business Intelligence Help Center

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

Note: This article contains instructions for clients that are utilizing the original architecture and new architecture. You are on the new architecture if you can create Same Table-Calculation columns in your Data Warehouse.

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.

For clients on the original architecture (no option to create Same Table-Calculation columns), 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.

None!!!

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

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