Does Draxlr assemble several findings into one coherent report?

Which revenue source should I total for last month?

Total order revenue was $14,403.87. This covers August 1–31, 2026, and includes all order statuses.

Your best-selling product category is bedding and rugs with 140 units sold. Best-selling is based on total units sold across all time.

SELECT
  p.category AS product_category,
  SUM(oi.quantity) AS total_units_sold
FROM public.order_items oi
JOIN public.products p ON oi.product_id = p.id
GROUP BY p.category
ORDER BY total_units_sold DESC
LIMIT 1

Which cancellation rate do you mean?

The current order cancellation rate is 21.75%. This covers all time.

The final response, printed above.

WITH revenue_last_month AS (
  SELECT
    COALESCE(SUM(o.total_amount), 0) AS total_revenue_last_month
  FROM public.orders o
  WHERE o.placed_at >= TIMESTAMPTZ '2026-08-01 00:00:00+00'
    AND o.placed_at < TIMESTAMPTZ '2026-09-01 00:00:00+00'
), best_selling_category AS (
  SELECT
    p.category::text AS best_selling_product_category,
    SUM(oi.quantity) AS units_sold
  FROM public.order_items oi
  JOIN public.products p ON p.id = oi.product_id
  GROUP BY p.category
  ORDER BY SUM(oi.quantity) DESC
  LIMIT 1
), order_cancellation_rate AS (
  SELECT
    ROUND(
      (COUNT(*) FILTER (WHERE o.status::text ILIKE 'cancel%')::NUMERIC / NULLIF(COUNT(*)::NUMERIC, 0)) * 100,
      2
    ) AS cancellation_rate_percent
  FROM public.orders o
)
SELECT
  r.total_revenue_last_month,
  b.best_selling_product_category,
  b.units_sold,
  c.cancellation_rate_percent
FROM revenue_last_month r
CROSS JOIN best_selling_category b
CROSS JOIN order_cancellation_rate c