Methodology

Dashboard Objective

Explain the NDC Elections, and showcase their Candidates Activity in Near.

Dashboard Method

Using the Flipside Tables of Near I'll track the activity Using:

Tables Used:

near.core.fact_actions_events_function_call : To get the NDC Activity (Upvotes and Nominations)
near.social.fact_decoded_actions : To get the Social Activity
near.core.fact_nft_mints : To get the NFT Mints Activity
near.core.ez_dex_swaps : To get the Swaps Activity
near.core.fact_transactions : To get Transaction Activity
near.core.dim_address_labels : To label the Sectors and CEX/Bridge projects
near.core.dim_token_labels : To label the Tokens 


How to Get Candidates?

Using the events table, and receiver_id = 'nominations.ndc-gwg.near' we can get all the activity related to the NDC Nominations.

In particular the method_name = 'on_nominate_verified' shows us the activity of the user nominated and their selected house, however, they can change the house so is necessary to get the latest activity by block_timestamp.

The Same happens for the Upvotes and therefore is necessary to get the latest method_name from ('upvote','remove_upvote', 'on_upvote_verified') to measure correctly the Upvotes.

Please Note that Upvotes work as a "Like" to boost the reputation of the candidate, the Election Period starts in September.

Dashboard Sources

Images

I AM HUMAN Image, NDC Logo, Timeline Image, Houses Image

Documents

Near Digital Collective Elections