The Flow blockchain network has been gaining significant momentum in recent years, with an increasing number of users joining the network to build and deploy decentralized applications (dApps) and digital assets.

This dashboard is an important tool for understanding the impact of user activity on the Flow network. By tracking the number of active users, the dashboard provides valuable insights into user engagement, network usage patterns, and overall health.

The effect of active users on the Flow blockchain is significant. As more users join the network and engage with dApps and digital assets, the network becomes more robust and resilient. Increased user activity can also lead to greater liquidity and trading volume, making the network more attractive to developers and investors.

Furthermore, this dashboard helps to promote transparency and accountability on the Flow network. By providing real-time data on user activity, the dashboard enables users to monitor the health and growth of the network, and to identify any potential issues or areas for improvement.

In summary, the daily active users dashboard is a critical tool for understanding the impact of user activity on the Flow blockchain. As more users join the network and engage with dApps and digital assets, the network will become increasingly robust and resilient, and the potential for innovation and growth will continue to expand.

For gathering the data around to create this dashboard, i used Flipsidecrypto database and Flow.core schema to do my analysis.

I mainly used fact_transactions table and in some queries i joined it with fact_events to gather the user data.

For calcuating the active users on Flow i used the method below:

lag(block_timestamp, 1) ignore nulls over (partition by users order by block_timestamp) as previous_txn, datediff('day',previous_txn, block_timestamp) as time_between_txs,

Then, I Filtered daily active users with this method:

Time_between_txs <= 1 days as daily active users.

What is Flow?

Flow is a public blockchain network that is designed to enable the creation and deployment of decentralized applications (dApps) and digital assets. It was created by Dapper Labs, the team behind the popular CryptoKitties game, and was designed with a focus on scalability, usability, and security.

One of the key features of Flow is its unique architecture, which is designed to enable high throughput and low latency, making it well-suited for building large-scale dApps and handling high volumes of transactions. Flow also supports a variety of programming languages, which makes it more accessible for developers with different backgrounds and skill sets.

Flow also has its own native cryptocurrency, known as FLOW, which is used to pay for transaction fees and other network operations. The FLOW token is also used as a governance mechanism for the network, enabling token holders to participate in the decision-making process for network upgrades and other important decisions.

Overall, Flow is a promising blockchain network that has gained significant traction in the blockchain community. Its unique architecture, focus on usability and security, and support for a variety of programming languages make it a compelling platform for developers and entrepreneurs looking to build decentralized applications and digital assets.

Flow Website

Flow Scan