WITH sales_data AS (
    SELECT 
        r.region_name,
        s.sales_rep_name,
        DATE_TRUNC('month', o.order_date) as sales_month,
        SUM(o.amount) as revenue,
        COUNT(DISTINCT o.order_id) as deal_count
    FROM orders o
    JOIN sales_reps s ON o.rep_id = s.id
    JOIN regions r ON s.region_id = r.id
    WHERE o.status = 'closed_won'
      AND o.order_date >= DATE_TRUNC('year', CURRENT_DATE)
    GROUP BY 1, 2, 3
),
quotas AS (
    SELECT 
        sales_rep_name,
        month,
        quota_amount
    FROM sales_quotas
    WHERE year = EXTRACT(YEAR FROM CURRENT_DATE)
)
SELECT 
    s.*,
    q.quota_amount,
    (s.revenue / NULLIF(q.quota_amount, 0)) as attainment_pct
FROM sales_data s
LEFT JOIN quotas q ON s.sales_rep_name = q.sales_rep_name 
                   AND s.sales_month = q.month;

SELECT
    COUNT(DISTINCT CASE WHEN step = 'landing_view' THEN user_session_id END) as step_1_landing,
    COUNT(DISTINCT CASE WHEN step = 'signup_click' THEN user_session_id END) as step_2_click,
    COUNT(DISTINCT CASE WHEN step = 'form_submit' THEN user_session_id END) as step_3_submit,
    COUNT(DISTINCT CASE WHEN step = 'email_confirm' THEN user_session_id END) as step_4_confirm
FROM web_events
WHERE event_date >= DATEADD('day', -30, CURRENT_DATE);

import { EmbedDashboard } from '@superset-ui/embedded-sdk';

useEffect(() => {
    EmbedDashboard({
        id: "dashboard_uuid",
        supersetDomain: "https://superset.mycompany.com",
        mountPoint: document.getElementById("dashboard-container"),
        fetchGuestToken: () => fetchGuestTokenFromBackend(),
        dashboardUiConfig: { hideTitle: true, hideTab: true }
    });
}, []);