shreexDimension X 3
    Updated 2023-03-31
    with users as (
    select
    distinct txs.tx_id as txs,
    proposer,
    txs.block_timestamp::date as min_date
    from flow.core.fact_transactions txs left join flow.core.fact_events et on et.tx_id=txs.tx_id
    where event_contract='A.e3ad6030cbaff1c2.DimensionX'
    )
    select
    date_trunc('month',min_date) as date ,
    count(distinct proposer) as users,
    sum(users) over (order by date) as user_growth
    from users
    GROUP BY date