Osmosis Governance

    Q13. Create a dashboard that maps community participation in governance. On average, how long does it take for a new wallet to become active in Osmosis governance? Do wallets that are active in governance vote on every proposal? Or do they only vote on select proposals?

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Introduction

    Staked OSMO holders are eligible to vote on governance proposals. Browse the available proposals, and use one's staked tokens to cast a vote.

    In this dashboard we will be using osmosis.core.fact_governance_votes table to analyze user participations in governance as following:

    • Daily community participation in governance(Daily number of votes)
    • Number of votes to each proposal
    • Percentage of votes to each proposal
    • Average days it takes for a new wallet to become active in Osmosis governance
    • 10 wallets that takes most days to become active in Osmosis governance

    As you see in the above chart the highest number of votes recorded on Apr 23,2022 by about 133.5K votes.

    The above chart shows the number of votes to each proposal by proposal ids. We can see most of the votes went to proposal id range from 159 to 259. The proposal id 206 by about 57.6K had the most votes between all proposals.

    To find average days we can measure difference between the wallets creation date and first vote date by these wallets, And then calculate average da