BlockTrackerweight of votes
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
count(voter) as voters,
count(CASE when weight_of_vote>0 then voter end) as eligible_voters,
eligible_voters / voters as rate
FROM (
SELECT
voter,
COALESCE(sum(vote_weight) , 0) as weight_of_vote
FROM osmosis.core.fact_governance_votes
GROUP BY 1
)
Run a query to Download Data