From Visual Exploration to Conversational AI

-- AI Generated: Cohort Retention Analysis (Replaces Tableau LODs)
WITH cohort_items AS (
  SELECT user_id, DATE_TRUNC('month', MIN(created_at)) AS cohort_month
  FROM tenant.events GROUP BY 1
),
user_activities AS (
  SELECT e.user_id, EXTRACT(month FROM AGE(e.created_at, c.cohort_month)) AS month_number
  FROM tenant.events e
  JOIN cohort_items c ON e.user_id = c.user_id
)
SELECT cohort_month, month_number, COUNT(DISTINCT user_id) AS active_users
FROM cohort_items JOIN user_activities USING (user_id)
GROUP BY 1, 2 ORDER BY 1, 2;