flipside

    Months Active Metrics on Flow
    mattkstewMonths Active Metrics on Flow
    Updated 2022-12-19
    with tab1 as (
    select
    proposer,
    count(distinct date_trunc('month', block_timestamp)) as Months_active

    from flow.core.fact_transactions
    group by 1
    )

    select
    avg(months_active),
    median(months_active),
    max(months_active)
    from tab1
    -- by 1

    Run a query to Download Data