Sales · May 5–8, 2025
Which region brought in the most revenue?
For a sales review, start with completed orders. Each row is one order and each total is in US dollars. A canceled or pending order contributes nothing to completed revenue.
Decision. Start the review with East, which contributed $360 of the $740 in completed revenue. Track pending orders in a separate pipeline figure.
Order value by region
$740 from 5 completed orders
East leads. The $120 canceled order and the $90 pending order are out of scope.
$950 across all 7 submitted orders
Including every submitted order adds $210 to the total. East still leads.
Inspect 7 orders
| Order | Placed | Region | Status | USD |
|---|---|---|---|---|
| 1042 | May 5 | East | Completed | 210 |
| 1043 | May 5 | West | Completed | 170 |
| 1044 | May 6 | Central | Completed | 115 |
| 1045 | May 6 | East | Canceled | 120 |
| 1046 | May 7 | East | Completed | 150 |
| 1047 | May 8 | West | Completed | 95 |
| 1048 | May 8 | West | Pending | 90 |
Run the calculation
Download the orders fixture and load it in SQLite. This query calculates both views for the same dates.
SELECT region,
SUM(CASE WHEN status = 'completed' THEN total_usd ELSE 0 END)
AS completed_usd,
SUM(total_usd) AS submitted_usd
FROM orders
WHERE ordered_on >= '2025-05-05' AND ordered_on < '2025-05-09'
GROUP BY region
ORDER BY completed_usd DESC;
See the prompt
Use DewPoint. Build a sales review dashboard showing completed revenue and order counts by region from May 5 through May 8, 2025. Use USD and exclude canceled and pending orders.