Number of $OCEAN in use for voting per round

[AngelaKTE]

Problem
I'd like to get the number of $OCEAN in use for voting per round to give information about the demand of $OCEAN for OceanDAO voting. Currently, the voting overview only shows

• number of individual wallets
• number of yes/no votes (aka $OCEAN used for voting yes or no)
• number of total votes (aka $OCEAN total votes across all proposals) -> but this includes duplicates, since a wallet owner can vote with the same $OCEAN token on >1 proposals
  Voting overview: https://docs.google.com/spreadsheets/d/1e4xb6m-aKcBhwob_p7ereSFneXFPpDjUbSjz13smmHI/edit#gid=1767052349 --> sheet "round results", column "i"

Solution
What's missing is the number of $OCEAN in use for voting per round:
a) record every wallet and respective number of votes cast (yes + no) per proposal
b) sum up the votes cast, but EXCLUDE the number of $OCEAN votes cast by the same wallet for >1 proposal

[idiom-bytes]

Hi Angela,

I have mentioned below what functionality/logic exists that could be leveraged to provide you with the results you are looking for. Due to timelines for R11, I hope you or someone in your team could help deliver this task, otherwise, we will try to do it in the future.

Please clone + submit PR in order to make this process as fast as possible, while providing new functionality for anyone who needs it.

Ticket Overview

The two functions mentioned below, are responsible for collecting all voter information foreach: propsal & round.

• These functions can be further expanded upon (by re-using/re-implementing) so that it yields results based on unique wallets.

calculateProposalSummary(activeProposals, voterScores, proposalScores)
https://github.com/oceanprotocol/DAOBot/blob/c45ba901337e8b1b5db36e98f0aafe3d59c88df0/src/gsheets/sync_gsheets_active_proposal_votes_snapshot.js#L55

&

calculateRoundSummary(activeProposals, voterScores, proposalScores)
https://github.com/oceanprotocol/DAOBot/blob/c45ba901337e8b1b5db36e98f0aafe3d59c88df0/src/gsheets/sync_gsheets_active_proposal_votes_snapshot.js#L92

calculateRoundSummary in particular, is already doing some of this work, and could be leveraged to calculate [Unique Ocean Voted].

[AngelaKTE]

Thanks, will take it to the research group https://oceanpearl.io/projects/c2b3b1dAaD-governauts-rewards-systems-research

@claudiaHash join us in case you are interested in DAO analytics, pls sign-up here to keep you posted: https://forms.gle/zNNLdi8aUKystz3QA