Date | New Users | Total Users | Active Users | |
|---|---|---|---|---|
1 | 2024-08-25 00:00:00.000 | 22 | 22 | 0 |
2 | 2024-08-26 00:00:00.000 | 28 | 32 | 4 |
3 | 2024-08-27 00:00:00.000 | 76 | 83 | 7 |
4 | 2024-08-28 00:00:00.000 | 53 | 56 | 3 |
5 | 2024-08-29 00:00:00.000 | 26 | 33 | 7 |
6 | 2024-08-30 00:00:00.000 | 27 | 30 | 3 |
7 | 2024-08-31 00:00:00.000 | 29 | 35 | 6 |
8 | 2024-09-01 00:00:00.000 | 22 | 29 | 7 |
9 | 2024-09-02 00:00:00.000 | 11 | 22 | 11 |
10 | 2024-09-03 00:00:00.000 | 121 | 132 | 11 |
11 | 2024-09-04 00:00:00.000 | 5 | 9 | 4 |
12 | 2024-09-05 00:00:00.000 | 6 | 15 | 9 |
13 | 2024-09-06 00:00:00.000 | 6 | 17 | 11 |
14 | 2024-09-07 00:00:00.000 | 8 | 14 | 6 |
15 | 2024-09-08 00:00:00.000 | 16 | 20 | 4 |
16 | 2024-09-09 00:00:00.000 | 19 | 28 | 9 |
17 | 2024-09-10 00:00:00.000 | 17 | 41 | 24 |
18 | 2024-09-11 00:00:00.000 | 21 | 30 | 9 |
19 | 2024-09-12 00:00:00.000 | 18 | 32 | 14 |
20 | 2024-09-13 00:00:00.000 | 22 | 38 | 16 |
Eman-RazUsers Over Time
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with table1 as (with tab1 as (select signers[0] as user, min(block_timestamp::date) as first_tx_date
from eclipse.core.fact_transactions
where succeeded='TRUE'
group by 1)
select date_trunc('{{Time_Frame}}',first_tx_date) as "Date", count(distinct user) as "New Users"
from tab1
group by 1
order by 1),
table2 as (select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct signers[0]) as "Total Users"
from eclipse.core.fact_transactions
where succeeded='TRUE'
group by 1)
select table1."Date", "New Users", "Total Users", "Total Users"-"New Users" as "Active Users"
from table1 left join table2 on table1."Date"=table2."Date"
order by 1
Last run: 6 days ago
...
219
9KB
716s