count (distinct active_users) as Active_Users_Count

from (select

date_trunc (week,block_timestamp) as Week

,tx_from as active_users

,count (distinct block_timestamp::date) as days

from osmosis.core.fact_transactions

where tx_status = 'SUCCEEDED'

group by 1,2

having days >= 4)