Revenue dropped 18%. Why?

Optional analyst view. The business answer and proof summary are shown above.

WITH monthly_revenue AS (
  SELECT date_trunc('month', date::date) AS month, segment, product, SUM(revenue) AS revenue
  FROM demo_trust_loop
  WHERE date >= DATE '2026-01-01' AND date < DATE '2026-03-01'
  GROUP BY 1, 2, 3
),
periods AS (
  SELECT
    SUM(CASE WHEN month = DATE '2026-01-01' THEN revenue ELSE 0 END) AS prior_revenue,
    SUM(CASE WHEN month = DATE '2026-02-01' THEN revenue ELSE 0 END) AS current_revenue
  FROM monthly_revenue
)
SELECT
  prior_revenue,
  current_revenue,
  current_revenue - prior_revenue AS revenue_delta,
  ROUND((current_revenue - prior_revenue) / NULLIF(prior_revenue, 0) * 100, 1) AS revenue_delta_pct
FROM periods;