Query editor
WITH first_trade AS (SELECTtx_from AS wallet,MIN(DATE_TRUNC('week', block_time)) AS cohort_weekFROM dex.tradesWHERE blockchain = 'mantle'GROUP BY tx_from),weekly_activity AS (SELECTtx_from AS wallet,DATE_TRUNC('week', block_time) AS active_weekFROM dex.tradesWHERE blockchain = 'mantle'),cohort_retention AS (SELECTf.cohort_week,a.active_week,DATE_DIFF('week', f.cohort_week, a.active_week) AS week_number,COUNT(DISTINCT a.wallet) AS retained_walletsFROM first_trade fJOIN weekly_activity aON f.wallet = a.walletGROUP BY 1,2,3)SELECTcohort_week,week_number,retained_walletsFROM cohort_retentionWHERE week_number <= 8ORDER BY cohort_week, week_number;