flipside

    User Retention vs Other Chains 100
    jackguyUser Retention vs Other Chains 100
    Updated 2022-12-17
    SELECT
    active_months,
    count(*) as users
    FROM (
    SELECT
    PROPOSER,
    count(DISTINCT date_trunc('month', block_timestamp)) as active_months
    FROM flow.core.fact_transactions
    GROUP BY 1
    )
    GROUP BY 1
    Run a query to Download Data