Ambient on Blast || Power vs. Normie Users

    This dashboard delves into users on Ambient Finance by tracking their transactions and retention rates. It also distinguishes users using a Pareto approach to identify power and normie users.

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    New Users and Retention Rate
    Loading...
    Loading...
    Loading...
    Loading...
    Pareto Charts
    Loading...
    Loading...
    Loading...
    Overview

    Creating a Pareto Chart

    Group the data by the launch date, which is 2024-02-29, to calculate the total traded volume for each address.

    Calculate the cumulative count of addresses, starting with the address having the highest volume.

    Normalize the cumulative sum of each address by dividing it by the total volume of all addresses.

    Apply labels: Addresses representing less than 0.8% of the total sum are labeled as "Power," while others are labeled as "Normie."

    Optional: Utilize dense_rank() to rank addresses by total volume in descending order and generate a chart for validation.

    Fee
    Loading...
    Loading...
    Loading...
    Loading...
    Power Users in Ethereum Mainnet Space
    Loading...
    Loading...
    Loading...