flipside

    What percentage of users used the platform?
    kiacryptoWhat percentage of users used the platform?
    Updated 2022-08-30
    select
    count(distinct voter) as voters,
    (select count(distinct signers[0]) from solana.core.fact_transactions where block_timestamp::date >= '2021-12-01') as all_users,
    (voters/all_users)*100 as ratio,
    'Realms' as platform
    from solana.core.fact_proposal_votes
    where
    succeeded = 'TRUE'

    union all

    select
    count(distinct voter) as voters,
    (select count(distinct from_address) from ethereum.core.fact_transactions where block_timestamp::date >= '2021-12-01') as all_users,
    (voters/all_users)*100 as ratio,
    'SnapShot' as platform
    from ethereum.core.ez_snapshot
    where network = 'Ethereum Mainnet'
    Run a query to Download Data