Query editor
-- repeat_rate_90d (按“天活跃次数”)WITH user_day AS (SELECT DISTINCT taker, date_trunc('day', block_time) AS tx_dateFROM dex.tradesWHERE block_time >= current_timestamp - INTERVAL '90' DAYAND project='uniswap' AND blockchain='ethereum'),cnt AS (SELECT taker, COUNT(*) AS active_daysFROM user_dayGROUP BY taker)SELECTCOUNT(*) AS total_users,COUNT_IF(active_days >= 2) AS repeat_users,CAST(COUNT_IF(active_days >= 2) AS DOUBLE)/COUNT(*) AS repeat_rateFROM cnt