Solana New user Challenge

In this challenge, I aimed to measure the usage of Solana. Taking into account some key metrics such as transaction fees, failed transactions and its ratio.

From the chart on average transaction fees per hour, it can be seen that March 30th and April 11th had higher transaction fees than others. This signifies that there was more transaction on these days than on other days.

Total number of transactions per hour during the 14 days.

The total number of transactions per hour in the last 14 days on the Solana network is 1.5 million.

To achieve this, we divide the total transactions by the number of hours.

he total number of failed transactions per hour in the last 14 days

The failed transaction per hour depicts the total number of transactions on the Solana network that was not successful.

To achieve this, we use a case statement to count the number of unsuccessful transactions and divide by the total number of hours.

Ratio of failed transactions per hour during the last 14 days.

The ratio of the failed transactions shows the number of transactions that failed in a series of transactions in one hour.

It is gotten by multiplying the failed transaction by 100 and dividing it by the total transactions.

Average transaction fee grouped by hour. Use data from the last 14 days.

Conclusion

In conclusion, it can be seen be denoted that for every transaction, there is an average of 25% failed transactions.

flipside

flipside

Solana New user Challenge