Introduction

In this bounty, we looking into the application calls statics in the last six months of 2021 and the first six months of 2022. we are going to analyze the following items:

1. Comparing the number of TX called per block
2. Comparing the number of TX called per day
3. comparing the number of wallets that make an application calls per day and total
4. number of applications users use
5. compare the number of users for the most usable app

In the charts displayed in this dashboard, we have used the 2021 label for the data obtained for the second six months of 2021, and the 2022 label for the data related to the first six months of 2022.

The data obtained for these two intervals are obtained using the following commands in the application_call_transaction table.

1. BLOCK_TIMESTAMP>= '2022-01-01' --> use for getting rows about 2022
2. BLOCK_TIMESTAMP>= '2021-06-01' and BLOCK_TIMESTAMP < '2022-01-01' --> use for getting rows abuot 2021

1. Comparing the number of TX called per block

There are two IDs in Algorand transactions

1. tx_id
2. tx_group_id

Each transaction has a separate ID that is unique but maybe a partial transaction of a set of transactions related to a smart contract, in which case the TX_GROUP_ID is the same for all of these transactions.

For this reason, we have obtained an average of both IDs( TX_ID and TX_GROUP_ID )

According to the data obtained for transactions made in the first six months of 2022 and the second six months of 2021, we can see that:

1. The average number of transactions per block has almost doubled, from 6.3 transactions per block to 11 transactions per block.
2. The average number of TX_GROUP_ID has not grown much and has increased from 3.8 transactions to 4 transactions per block.

According to the fact that the number of transactions has increased, but the number of TX_GROUP_ID has not grown much, it can be concluded that the amount of App call contracts has increased and we are facing more complex contracts.

2. Comparing the number of TX called per day

In the data related to the average number of daily transactions performed in these two intervals, we can see that the number of TX_GROUP_ID transactions has also increased more, and in 2022, a higher amount of App call transactions has been performed.

1. The increase in App calls can indicate two points. One use of different applications in the Algorand network has increased, and two The number of users of this network has increased.
2. Based on the data we have obtained from previous bounties, we know that the number of users of the Algorand network has grown well, so it is natural that the number of transactions has increased.
3. In the next section, we check the number of users to see if we see an increase in users or not.
4. We also check the number of app IDs used in transactions to see if new applications have been created in this network with the increase in the number of users and whether they are used or not.

3. comparing the number of wallets that make an application calls total

According to the data related to the average number of wallets that have made App Call transactions, it can be seen that there is a significant growth in the number of wallets that have made daily transactions, and the number of wallets that have made transactions has almost quadrupled. The obtained data shows that the increase in the number of Algorand network users has an effect on the increase in the number of transactions, now we will check whether there is a variety of applications or not. For this, we get the number of App IDs used in transactions in these two periods.

The charts in this section show the total number of apps used in transactions in the first six months of 2022 and the second six months of 2021.

We have also shown the number of transactions performed in these two intervals in terms of the number of TX_ID and TX_GROUP_ID in the last two charts.

1. The variety of different numbers of App IDs has increased from 132 thousand App IDs to 179 thousand App IDs.
2. The **number of transactions has multiplied.
3. Since the number of transactions based on tx_group_id has grown less than tx_id, it can be concluded that the contracts have become more complex and the transactions performed in each contract have increased. For example, NFT sales transactions may include 3 to 15 transactions, so while we have 15 transactions, we only have one tx_group_id for them.

5. compare the number of users for the most usable app

In this section, we get the ten App IDs that have the most transactions and calculate the number of transactions for each of them in the two desired intervals.

In the chart above, the ten App IDs with the highest number of transactions for the two intervals are shown. According to this chart:

1. The six App IDs that had the most use in 2022, were not among the ten most used App IDs in the second six months of 2021.
2. App IDs used in 2021 were used less in transactions in 2022.

Conclusion

In this dashboard, we checked the number of transactions performed in the call table. In the obtained charts, we saw that:

1. The use of App calls has increased.
2. The number of users who have made App calls has increased.
3. The number of apps has increased.
4. Most of the popular App IDs have changed and lost their place.

4. Compare the number of APP_ids