What the aims of current dashboard?

This dashboard are created to answer this questions:

Many of reward payments that were sent, total amount of ALGO rewards paid out Time elapsed from the first to the last rewards payment. Wallet that had the largest rewards payout and many of Aglos that did they received. And plot results to show the distribution of rewards payouts.

How this dashboard was created:

by Flipside recomndations:

Decoded transaction note to look something like

try_base64_decode_string(tx_message:txn:note) = af/gov1:j{"rewardsPrd":2,"gov":"BQZA4KC2TGQS27X3ZS4VVJSH3PZD3CZXGSYN5OXPQJLHZ6VBT5IVKT7FKU"}

You can use this query to isolate the payouts: select try_base64_decode_string(tx_message:txn:note::string), * from algorand.payment_transaction where block_timestamp::date > '2022-03-30' and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%'

We also know the sender will be: 57QZ4S7YHTWPRAM3DQ2MLNSVLAQB7DTK4D7SUNRIEFMRGOU7DMYFGF55BY Here is an example rewards transaction: https://algoexplorer.io/tx/XXITBNTHCGOSJM47TFHOUIQ3TJYC7EJJJFDLLPJAKHIHTSQWK3TQ

Let's go to observe obtained results.

• Total of wallets that have received rewards are more than 37k and sum of total Algo$ paid out is more than 70M Algo.

• "WC6M5SRAF5NTTODMW5U5CLOFZNEBRLVARXXM4LSI36BVLIIJT4IIMCAYZ4" is the wallet that had received largest rewards.

Results

1. Total Algo$ paid out: aboutt 3.4M.
2. 5K of wallet are showen to plot Distribution and shoen in the last chart.
3. Time elapsed from the first to the last rewards payment was 15 min.