Query editor
WITH daily AS (SELECT *FROM query_8653765WHERE day < CURRENT_DATE),top25 AS (SELECT projectFROM dailyWHERE day >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1ORDER BY SUM(messages) DESCLIMIT 25),win AS (SELECTd.project,d.day,d.messages,d.volume_usd,d.avg_usd_per_message,CASEWHEN d.day >= CURRENT_DATE - INTERVAL '7' DAY THEN '7d'WHEN d.day >= CURRENT_DATE - INTERVAL '30' DAY THEN '30d'WHEN d.day >= CURRENT_DATE - INTERVAL '90' DAY THEN '90d'END AS window_bucketFROM daily dINNER JOIN top25 t ON d.project = t.projectWHERE d.day >= CURRENT_DATE - INTERVAL '90' DAY),-- For nested windows, each day belongs to all larger windows containing itexpanded AS (SELECT project, '7d' AS window_name, messages, volume_usd, avg_usd_per_messageFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '7' DAYAND day < CURRENT_DATEUNION ALLSELECT project, '30d', messages, volume_usd, avg_usd_per_messageFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '30' DAYAND day < CURRENT_DATEUNION ALLSELECT project, '90d', messages, volume_usd, avg_usd_per_messageFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '90' DAYAND day < CURRENT_DATE),agg AS (SELECTproject,window_name,COUNT(*) AS days_in_window,approx_percentile(messages, 0.5) AS msgs_median,approx_percentile(messages, 0.1) AS msgs_p10,approx_percentile(messages, 0.9) AS msgs_p90,approx_percentile(volume_usd, 0.5) AS usd_median,approx_percentile(volume_usd, 0.1) AS usd_p10,approx_percentile(volume_usd, 0.9) AS usd_p90,