Intro:

A realm is a Solana program launched by any DAO to support its governance through proposals and voting.

As said in the question, the aim of this dashboard is to track the DAOs on Realm and find out the features of them by considering these metrics:

• Number of Members (assuming unique voters is what he means here)
• Total Votes
• Number of Proposals
• Date of Last Proposal
• Date of Creation

Method and Metrics:

• Used table-→ solana.core.fact_proposal_votes
  • GOVERNANCE_PLATFORM ilike '%realms%'
• Identify DAOs-→ Realms_id
• Type of analysis-→

  • Overall

  1. Daily
• Special DAO-→ realms_id ='81dgxBYogwBPS17aUCY1ScFqSKrehECdFxA8Ywa9CiVb' stands for Flipside governance

Outcomes:

1. Because of the provided data by Flipside appeared since December 1st, the lowest time or creation date of Serum and Mango are on December 1st as a leading created DAOs.
2. The Flipside governance is the last created DAOs by creation date of proposal on June 24.
3. From the date of last proposal, the Synthetify has last proposal on August 13 and its the latest one.
4. The Grape, The Imperium of Rain and Mango are the three most popular DAOs by considering the number of votes.
5. By considering the total number of Members, The Imperium of Rain, Grape are two of the leading DAOs.
6. From the total number of proposals, the MonkeDAO and Mango are the DAOs with most number of proposals,

Outcomes 2:

The application of each DAO on realm are demonstrated in the weekly basis in this part.

1. The weekly number of proposals shown the largest number of proposals belong to MonkeDAO and Mango in the weekly basis.

2. By considering the area chart and space of each DAO, the Grape and The Imperium of Rain have largest space and relatively highest number of votes in the weekly basis analysis.

3. The highest participation of Realms DAOs happened on the week between May 2 to 9 according to the figures of votes and Members.

4. On week between May 2 to 9, The Imperium of Rain (pink bar) has the largest participation with 842 unique members.

5. The cumulative figures are very useful because the time of first and last proposal and Also the number of votes and members demonstrated on them. For example, the Psy Finance has the first proposal on March 28 and the total captured votes are 237 by 126 unique members.

   \

Live Realm stats:

The Live Realm analysis is provided here. Just put the realm id of your favorite DAO and find out info about the number of proposal, votes and Members.

Also, the vote analysis of the whole proposals provided in the normalized bar chart to capture that proposal passed or rejected.