niloCopy of Copy of flow weekly
    Updated 2022-12-20
    WITH new_T as (SELECT date_trunc ('week', BLOCK_TIMESTAMP) as TIME,PROPOSER,COUNT (DISTINCT TX_ID) as TXN FROM flow.core.fact_transactions WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - interval'6 months' GROUP BY 1,2)

    SELECT TIME,
    COUNT (DISTINCT PROPOSER) as Users,
    sum (Users) over (order by TIME) as Cum_New_Users
    FROM new_T WHERE TXN >= 5 GROUP BY 1
    Run a query to Download Data