Donut chart on the left shows top 10 wallets that had most number of transactions in which ~471K transactions has been executed by them and most share of it belongs to ==terra1m4hq3r4xacwam3zk40kh0892gwlfzdpcxafd7u== with 48% of transactions or ~226K.

Area chart on the left shows daily graph of active users at once, as we see after its spike on May 31,2022 with 11K transactions it has been bearish until August 2022 which since then we see increasing trend which continues and maxes out highest on Jan 16, 2023 with 13.6K transactions

so we can say that this trend in general, it is bullish.

Single number above shows total active users that have been extracted according my approach explained in Methodology which are 394 unique users.

Donut chart above has divided extracted 394 active wallets to groups that are expanded from “Active Every day“ to “Active between 50%-60% of days“ in which as we see wallets that has lowest activity which are only active between 50-60% of days has majority of wallets with 32.2%(128 wallets), and wallets that have highest activity which are wallets that active everyday have lowest numbers which are 2.03% or 8 wallets.

• Bar chart above depicts activity statistics of extracted 394 active wallets in which two metrics of Transaction Difference Days which shows total days that each wallet has been from it’s first transaction to it’s last on Terra, Register Days and which shows total days that each wallets has had at least one transaction on them.
• 146 of these wallets has 246 register days which is highest, but only 4 of these wallets has been active for 247 days which is highest.
• Total registered days of these wallets is 73,842 days and their total activity days is 51,389

This section discusses successful transactions of each group of activity of wallets separately

This section discusses over all statics of active wallets

Donut chart above shows total successful transactions of wallets that has been active each day, which their total successful transactions is ~34.5K, and ==terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5== has most share of them with 35.8% or ~12.3K transactions.

Donut chart above shows total successful transactions of wallets that has been more than 90% of days, which their total successful transactions is ~577.6K, and ==terra1m4hq3r4xacwam3zk40kh0892gwlfzdpcxafd7u== has most share of them with 39.2% or ~226.6K transactions.

Donut chart above shows total successful transactions of wallets that has been active between 80% to 90% of days, which their total successful transactions is ~40.4K, and ==terra1fp37y0ls2ydjaww6a4mvaqprtxlf458nxmsea2== has most share of them with 21.7% or ~8.7K transactions.

Donut chart above shows total successful transactions of wallets that has been active between 70% to 80% of days, which their total successful transactions is ~65.4K, and ==terra14ps3ldhwzmpmap5cft49295h7v229lnrny3k8e== has most share of them with 19.5% or ~12.7K transactions.

Donut chart above shows total successful transactions of wallets that has been active between 60% to 70% of days, which their total successful transactions is ~66.8K, and ==terra1luagdjcr9c9yvp3ak4d7chjm5gldcmgln5rku5== has most share of them with 16% or ~10.7K transactions.

Donut chart above shows total successful transactions of wallets that has been active between 50% to 60% of days, which their total successful transactions is ~60K, and ==terra1kt8lugz899cwdukshzsz99cltkak6kpujp0zaq== has most share of them with 8.17% or ~4.8K transactions.

This section discusses top 10 wallets with most transaction count

this section discusses transactions of active users over time to see that if the trend is increasing or decreasing?

Conclusions

• According my definition of active wallets provided on Approach section of the dashboard 394 wallets has been extracted as active wallets

• Majority of these wallets has transacted between 50-60 percent of days

• 37% of active wallets has 246 register days

• Users that have successful transactions more than 90% of days has most number of successful transactions with 577.6K transactions

• Users that have successful transactions every day has least number of successful transactions with 34.5K transactions

• Other groups of active wallets has successful transactions between 40K-60k transactiosn.

  \n

Approach

1. In this dashboard, it is done in such a way that we first found the number of membership days of each user by datediff('day' , min(block_timestamp::date) , CURRENT_DATE ) as TRANSACTIONS_DIFFENRENCE_DAYS
2. Then we counted the number of unique days that each user made a transaction as REGISTER_DAYS
3. Then, from the combination of the above two pieces of information, we extracted people who had transactions for more than half of the membership days, for example, if a user has been a member for 2 months, he has had at least 30 transactions in these 2 months.
4. Then we divided these active wallet to groups and counted their successful transactions.
5. And finally top 10 wallets with most executed transactions shown, with daily and monthly transactions of active wallets.

Methodology

Table shown here is used to create queries:

• ==terra.core.fact_transactions==

Bar chart on the left shows monthly graph of each active users, as we see it’s general trend is bullish towards January 2023 which maxes out on Jan 2023 with 190K transactions and most executed transaction on a single month has recorded for ==terra1m4hq3r4xacwam3zk40kh0892gwlfzdpcxafd7u== on November 2022 with 56K transactions.

One of the anticipated paths to improve Terra by its developers is Terra Expedition

==The Terra Expedition is a four-year program aimed at growing the Terra ecosystem through a series of initiatives with three main objectives, namely: incentivizing developers to build on Terra, deepening liquidity on Terra and onboarding users to Terra==

Link

Intro

Terra is an open-source blockchain hosting a vibrant ecosystem of decentralized applications (dApps) and top-tier developer tools. Using proof-of-stake consensus and ground-breaking technologies like Mantlemint, Terrain, and Station, the Terra blockchain is one of the fastest chains in existence, giving users an unparalleled DeFi experience. As a permissionless, borderless economy, Terra enables next-generation financial products accessible to anyone with an Internet connection.

Source