introduction

Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th.

First we get the number of successful and successful transactions per day

According to this chart, it can be said that increasing the number of transactions in one day is not the reason for increasing the number of failed transactions because it can be seen that on days when the total number of transactions is the same, the number of failed transactions can be very different. The two days 13 and 16 have almost the same number of transactions, but the number of failed transactions on the thirteenth day is many times more than the number of failed transactions on the sixteenth day.

To do a better check, we check the chart based on transaction hours and the number of transactions per hour.

In the above two charts, we have obtained the number of transactions performed per hour and the percentage of successful and unsuccessful transactions in that hour. In these two charts, We can see that the increase in the number of transactions is not a direct reason for the increase in the percentage of failed transactions, because in some hours when we have the same number of transactions, the amount of failed transactions has been different.

In conclusion, it can be concluded that increasing the number of transactions does not necessarily increase the percentage of failed transactions and other factors are influential in the failure of transactions.

We also see that in times when the rate of failed transactions increases due to the repetition of transactions to be done, the number of transactions increases for a while and this increase continues until the problem of transaction failure is solved and then decreases. Find