Dashboard Purpose
Use this dashboard if you want to:
- Compare performance metrics between two custom time periods by selecting specific date ranges.
- Analyze how net sales, number of orders, and average sales per order vary across different time frames.
- Identify percentage changes in key metrics between any two chosen periods to support flexible, tailored business analysis.
- Evaluate branch-level performance across custom periods for deeper insights.
Common Use Cases
| Business Question | Answer / Where to Look |
|---|
| Where can I compare two custom periods? | Use the Period 1 Start Date, Period 1 End Date, Period 2 Start Date, and Period 2 End Date filters at the top to set the periods and compare. |
| How can I compare branch performance between the two periods? | Use the Branch Name filter at the top to select your branch and observe changes in tables and visualizations. |
| How do I monitor net sales differences between two periods? | Review Period 1 Net Sales, Period 2 Net Sales, and Net Sales % Changemetrics. |
| How to analyze order volume changes between periods? | Check Period 1 Number of Orders, Period 2 Number of Orders, and Number of Orders % Change metrics. |
| What if I want to understand changes in average sales per order? | Use Period 1 Net Sales per Order, Period 2 Net Sales per Order, and Net Sales per Order % Change metrics. |
Keywords (for search functionality)
💡Custom Period, Date Range Comparison, Period Comparison, Net Sales, Orders, Percentage Change, Branch Comparison, Sales Trends, Flexible Date Filters
Available Filters
| Filter Name | Description | Notes |
|---|
| Period1 Start Date | Select the start date of the first comparison period. | Required to define Period 1 date range. |
| Period1 End Date | Select the end date of the first comparison period. | Required to define Period 1 date range. |
| Period2 Start Date | Select the start date of the second comparison period. | Required to define Period 2 date range. |
| Period2 End Date | Select the end date of the second comparison period. | Required to define Period 2 date range. |
| Branch Name | Filter data by branch for period comparison. | Optional; enables branch-level comparisons. |
Metrics & Definitions
| Metric | Definition |
|---|
| Period 1 Net Sales | Total net sales during the first selected period. |
| Period 2 Net Sales | Total net sales during the second selected period. |
| Net Sales % Change | Percentage change of net sales between Period 1 and Period 2. |
| Period 1 Number of Orders | Total number of orders during the first selected period. |
| Period 2 Number of Orders | Total number of orders during the second selected period. |
| Number of Orders % Change | Percentage change of orders between the two periods. |
| Period 1 Net Sales per Order | Average net sales per order in Period 1. |
| Period 2 Net Sales per Order | Average net sales per order in Period 2. |
| Net Sales per Order % Change | Percentage change in average net sales per order between periods. |