block_timestamp::date as time_created,

proposal_id,

count(distinct voter) as vote

from cosmos.core.fact_governance_votes a

join cosmos.core.fact_governance_submit_proposal b on a.proposal_id = b.proposal_id

group by 2