Eman-Razklaytn users
Updated 2024-08-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct from_address) as "Total Users"
from kaia.core.fact_transactions
where tx_succeeded='true'
group by 1),
tab2 as (with tab10 as (select from_address, min(block_timestamp::date) as first_tx
from kaia.core.fact_transactions
where tx_succeeded='true'
group by 1)
select date_trunc('{{Time_Frame}}',first_tx) as "Date", count(distinct from_address) as "New Users"
from tab10
group by 1)
select tab1."Date" as "Date", "Total Users", "New Users", "Total Users"-"New Users" as "Active Users"
from tab1 left join tab2 on tab1."Date"=tab2."Date"
where tab1."Date" between '{{Start_Date}}' and '{{End_Date}}'
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived