What that would be querying in this Dashboard:

In this dashboard are trying to answer following questions:

1. How many reward payments were sent? And what was the total amount of ALGO rewards paid out?
2. How much time elapsed from the first to the last rewards payment?
3. What wallet had the largest rewards payout and how much did they receive? And at the end Create a plot to show the distribution of rewards payouts.

Methods that are used to answering:

At the first by using Fipsides hints: 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

The results of the queries are shown in the following charts.

Reward payment & total amount of Algo

In the above chart we can see the number of wallet that had received rewards are more than 37k and more than 70M Algo was payment.

About of 3.5M Algo paid to largest wallet that had received payments rewards.

What this dashboard shows?

1. More than 3.4M Algo was paid to Lorgest wallet.
2. Distribution of payments are shown to 1K wallet in the last chart in the event that, wide and more than 10K wallets received this payment.
3. Total time elapsed to distribute all amount Algos$ was 15MInute.