The month closes on the 12th of the next one.Data and decision dashboards for business.

Query

SELECT SUM(net_sales) AS week_sales,
       SUM(net_sales) / NULLIF((SELECT SUM(net_sales) FROM sales_lines
         WHERE iso_year = 2025 AND iso_week = 45), 0) - 1 AS vs_last_year
FROM sales_lines
WHERE iso_year = 2026 AND iso_week = 45;

Query

SELECT region, EXTRACT(YEAR FROM invoice_date) AS yr, SUM(net_sales) AS ytd_sales
FROM sales_lines
WHERE EXTRACT(DOY FROM invoice_date) <= EXTRACT(DOY FROM CURRENT_DATE)
GROUP BY region, yr;

Query

SELECT iso_week,
       (SUM(net_sales) - SUM(cost_of_sales)) / NULLIF(SUM(net_sales), 0) AS gross_margin
FROM sales_lines
WHERE iso_year = 2026 AND iso_week IN (44, 45)
GROUP BY iso_week;

Query

SELECT snapshot_date,
       SUM(open_amount) / NULLIF(SUM(credit_sales_90d), 0) * 90 AS days_to_collect
FROM ar_snapshots
WHERE snapshot_date IN ('2026-10-31', '2026-11-08')
GROUP BY snapshot_date;

Query

SELECT sku, iso_week,
       (SUM(net_sales) - SUM(cost_of_sales)) / NULLIF(SUM(net_sales), 0) AS gross_margin
FROM sales_lines
WHERE invoice_date >= CURRENT_DATE - INTERVAL '8 weeks'
GROUP BY sku, iso_week;

Query

SELECT invoice_date, unit_cost,
       unit_cost / LAG(unit_cost) OVER (ORDER BY invoice_date) - 1 AS change
FROM purchase_lines
WHERE sku = 'SD-330'
ORDER BY invoice_date DESC
LIMIT 2;

Query

SELECT customer_code,
       CURRENT_DATE - MAX(order_date) AS days_since_last_order,
       AVG(days_between_orders) AS usual_gap
FROM customer_orders
WHERE customer_code = '1042'
GROUP BY customer_code;

Query

SELECT DATE_TRUNC('month', ship_date) AS month, destination_type,
       SUM(courier_cost) / COUNT(DISTINCT order_id) AS cost_per_order
FROM shipments
GROUP BY month, destination_type;

Query

SELECT DATE_TRUNC('month', ship_date) AS month,
       AVG(CASE WHEN destination_type = 'island' THEN 1.0 ELSE 0 END) AS island_share
FROM shipments
GROUP BY month;

Query

SELECT SUM(units_per_month * (unit_cost_now - unit_cost_before)) AS margin_lost_per_month
FROM sku_monthly
WHERE sku = 'SD-330';

Query

SELECT customer_code, SUM(open_amount) AS overdue, MAX(days_past_due) AS days
FROM ar_open_items
WHERE days_past_due > 30
GROUP BY customer_code
ORDER BY overdue DESC
LIMIT 5;

Query

SELECT SUM(net_amount) AS unposted_returns
FROM returns_inbox
WHERE received_date = '2026-11-05' AND posted_to_erp = FALSE;