==Introduction==

In this analysis we want to take a look at users retention on Flow, Solana and Ethereum Network.

in This Dashboard, date starts from '2022-04-20' cause first date in Flow Transactions table is equal to this date.

First chart On the left shows Users Retention on flow Chain. most users almost 73% of them had their next tx before 24 hours from first tx, and 22% of them had their tx between 1 and 7 days after first tx, this means most users comeback before 24 hours to do next tx on Flow chain.

Lets take a look at next pie chart , solana retention, situation here is different cause almost 42% of users comeback between 7 and 30 days, this means this users doing next transactions between 7 and 30 days after first Transactions.

and last Pie Chart Shows users retention on Ethereum Network, users retention percent value between users who transact in less 24 hours and between 7 and 30 days are so close.

==Conclusion==

Most flow users doing Their next transactions less than 24 hours from first tx.

while Solana users transact between 7 and 30 days.

and Ethereum users had both results we mentioned above cause number and percent of users who transact before 24 hour and between 7 and 30 days from firs tx are so close.

It can be concluded , Cause Ethereum had more Unique Users we can expect more users retention variety compare to other chain.

==Approach==

in this dashboard we used datediff Functions to find difference between first tx and next tx for each user.

Then calculate average this difference for each users.

in last step we used CASE statement to define how many users are in each bucket.

in 3 pie charts below you can see users retention percent on each blockchain and each bucket we define in last part.

Lets take a look at Users Retention numbers on each chain.

first chart shows number of users who Transact in different times after First Tx on flow chain, as you can see (mentioned above about this results as percent) most users had their next tx before 24 hours after first tx almost 3.1m Users.

Solana users who made transactions between 7 and 30 days after first tx are more compare to other users transact in different time range almost 1.2m Users.

And in Ethereum chain number of users who made next transactions from first tx is really close to users who transact between 7 and 30 days.