Query editor
WITH weekly_stats AS (SELECTdate_trunc('week', block_time) AS week,APPROX_DISTINCT(address) AS active_usersFROM bitcoin.inputsWHERE block_time >= CAST('2022-01-01' AS timestamp) -- Shorter timeframe for speedAND block_time < date_trunc('week', NOW())GROUP BY 1)SELECTweek,active_users,-- Simple growth metricsLAG(active_users) OVER (ORDER BY week) AS prev_week_users,active_users - LAG(active_users) OVER (ORDER BY week) AS user_change,ROUND(((active_users - LAG(active_users) OVER (ORDER BY week)) /NULLIF(LAG(active_users) OVER (ORDER BY week), 0)) * 100.0, 1) AS weekly_growth_pct,-- 4-week moving averageROUND(AVG(active_users) OVER(ORDER BY weekROWS BETWEEN 3 PRECEDING AND CURRENT ROW), 0) AS users_4week_avg,-- Simple trend indicatorCASEWHEN active_users > LAG(active_users) OVER (ORDER BY week) THEN 'Growing'WHEN active_users < LAG(active_users) OVER (ORDER BY week) THEN 'Declining'ELSE 'Stable'END AS trendFROM weekly_statsWHERE week >= CAST('2022-01-01' AS timestamp)ORDER BY week DESC;