Dashboard Purpose
Use this dashboard if you want to:
- Compare last week’s performance against the same week of the previous month.
- Track net sales, order volume, and average sales per order week-over-week.
- Identify trends in discounts, voids, and returns between these two periods.
- Evaluate branch-level performance changes for last week versus the comparable week last month.
Common Use Cases
| Business Question | Answer / Where to Look |
|---|
| Where can I see last week vs same week last month? | View the vs Same Week Last Month tab (default tab). |
| How do I compare branch performance for last week? | Use the Branch Name filter to select branches. |
| What were the net sales and number of orders last week compared to last month? | Check the Net Sales and Number of Orders metrics in the default tab. |
| Can I track discounts, voids, and returns for last week compared to last month? | These metrics are visible in the same tab under Discounts, Voids, and Returns. |
| How can I analyze average sales per order for last week? | Use the Net Sales per Order metric in the dashboard. |
Keywords (for search functionality)
💡Comparison, Last Week, Same Week Last Month, Net Sales, Orders, Discounts, Voids, Returns, Branch Performance, Weekly Comparison
Tab / Section Overview
| Tab Name | Description | Example Case |
|---|
| vs Same Week Last Month | Compares last week's performance metrics with same week last month. | If today was 8/26/2025 , last week will be 18/08/2025 vs Same Week Last Month will be 21/07/2025. |
Shows KPI’s of different number of key metrics on the vs Same Week Last Month tab. Keep in mind this is just part of the dashboard, there’s more to it!
Available Filters
| Filter Name | Description | Notes |
|---|
| Branch Name | Filter data by branch name | Useful for branch-specific weekly performance analysis. |
Metrics & Definitions
| Metric | Definition | Notes |
|---|
| Net Sales | Total revenue generated last week and same week last month. | Shows comparative sales performance. |
| Number of Orders | Total orders placed last week vs same week last month. | Reflects order volume changes week-over-week. |
| Net Sales per Order | Average sales value per order for the weeks compared. | Calculated as Net Sales ÷ Number of Orders. |
| Discounts | Total discount amount applied in each week. | Tracks promotional impact on revenue. |
| Voids | Total voided sales amount for each week. | Measures canceled sales impact. |
| Returns | Total refunded amount due to returns each week. | Indicates revenue loss from product returns. |