mamad-5XN3k3New Users 2
Updated 2024-10-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with new as (
select
min(block_timestamp::date) as days,
from_address
from kaia.core.fact_transactions
where TX_SUCCEEDED = 'TRUE'
group by 2)
select
sum(New_Users) as total_users,
avg(New_Users) as avg_new_users
from(
select
date_trunc('week', days) as week,
count(DISTINCT from_address) as New_Users,
sum(New_Users) over (order by date_trunc('week', days) asc) as cum_new_users
from new
where days >= '2024-01-01'
group by 1
)
QueryRunArchived: QueryRun has been archived