from flow.core.fact_events

where EVENT_CONTRACT ilike '%Dimension%'

group by 1

select

count (DISTINCT proposer) Total_users ,

count (DISTINCT tx_id) num_transactions

from flow.core.fact_transactions

where tx_id in (select tx_id from events )

and TX_SUCCEEDED = true