Year-over-Year Sales Unit Comparison

German_Rodriguez

This comprehensive report is crucial for businesses aiming to track performance and make informed decisions. By comparing sales units from the current period against the same period last year, stakeholders can gauge the effectiveness of their strategies, identify trends, and adjust operations to enhance profitability.

The report includes daily, weekly, monthly, quarterly, and annual comparisons, providing a holistic view of the business's trajectory and market dynamics. Understanding these metrics helps in optimizing inventory management, marketing campaigns, and sales tactics to better align with consumer demands and market conditions.

Columns and Their Formulas for the Report:

simple_timestamp - The actual date for the data entry
Day Name - The name of the day for simple_timestamp.
1 Yesterday Units (This Year)

SUM(CASE WHEN simple_timestamp = CURRENT_DATE() - INTERVAL 1 DAY THEN units END)

1 Yesterday Units (Last Year)

SUM(CASE WHEN simple_timestamp = DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR + INTERVAL 1 DAY) THEN units END)

1 Yesterday Units Delta %

(SUM(CASE WHEN simple_timestamp = CURRENT_DATE() - INTERVAL 1 DAY THEN units END)

SUM(CASE WHEN simple_timestamp = DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR + INTERVAL 1 DAY) THEN units END))
/ SUM(CASE WHEN simple_timestamp = DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR + INTERVAL 1 DAY) THEN units END)

2 Current Week To Date Units (This Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE())
AND WEEKOFYEAR(simple_timestamp) = WEEKOFYEAR(CURRENT_DATE())
THEN units
END)

2 Current Week Last Year Units (Last Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR)
AND WEEKOFYEAR(simple_timestamp) = WEEKOFYEAR(CURRENT_DATE() - INTERVAL 1 YEAR)
THEN units
END)

2 Current Week Units Delta %

(SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE()) AND WEEKOFYEAR(simple_timestamp) = WEEKOFYEAR(CURRENT_DATE()) THEN units END)

SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR) AND WEEKOFYEAR(simple_timestamp) = WEEKOFYEAR(CURRENT_DATE() - INTERVAL 1 YEAR) THEN units END))
/ SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR) AND WEEKOFYEAR(simple_timestamp) = WEEKOFYEAR(CURRENT_DATE() - INTERVAL 1 YEAR) THEN units END)

3 Current Month To Date Units (This Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE())
AND MONTH(simple_timestamp) = MONTH(CURRENT_DATE())
THEN units
END)

3 Current Month Last Year Units (Last Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR)
AND MONTH(simple_timestamp) = MONTH(CURRENT_DATE())
THEN units
END)

3 Current Month Units Delta %

(SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE()) AND MONTH(simple_timestamp) = MONTH(CURRENT_DATE()) THEN units END)

SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR) AND MONTH(simple_timestamp) = MONTH(CURRENT_DATE()) THEN units END))
/ SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR) AND MONTH(simple_timestamp) = MONTH(CURRENT_DATE()) THEN units END)

4 Current Quarter To Date Units (This Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE())
AND QUARTER(simple_timestamp) = QUARTER(CURRENT_DATE())
THEN units
END)

4 Current Quarter To Date Units (Last Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR)
AND QUARTER(simple_timestamp) = QUARTER(CURRENT_DATE())
THEN units
END)

4 Current Quarter To Date Units Delta %

(SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE()) AND QUARTER(simple_timestamp) = QUARTER(CURRENT_DATE()) THEN units END)

SUM(CASE WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE() - INTERVAL 1 YEAR) AND QUARTER(simple_timestamp) = QUARTER(CURRENT_DATE()) THEN units END))

5 Current Year To Date Units (This Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE())
AND simple_timestamp <= CURRENT_DATE()
THEN (chargetotal)
END)

5 Current Year To Date last year Units (Last Year)

SUM(CASE
WHEN YEAR(simple_timestamp) = YEAR(CURRENT_DATE()) - 1
AND simple_timestamp < DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR)
THEN (chargetotal)
END)

5 Last Year To Date Units Delta %

(5 YTD Demand (This Year) - 5 YTD Demand (LY)) / 5 YTD Demand (LY)