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