sem1d5 - Active users on consecutive days

    Loading...
    Loading...
    1 - Get each user daily txs
    2 - Find the Start and End Date of each user streak
    3 - Find Max streak and Count of streaks
    Loading...
    4 - How many users where active on at least 5 consecutive days
    Loading...

    One solution to @sam_bearsuit twitter question

    https://twitter.com/sem1d5/status/1682054860425007105

    With the use of RANK this can be used on any definition of 'Active Users' with the added benefit of having access to a lot of stats of user behaviour.

    Queries are filtered for only 3 addresses to make it easier to check the results each CTE produces.

    PS: Huge thank you to 0xdatawolf that mentioned 'Gaps and Islands Problem' and lead me in the correct path.