Number of Txns | Number of Users | Percentage of Users | |
|---|---|---|---|
1 | 1<n<=5 Txns | 160172 | 27.419% |
2 | n>100 Txns | 160033 | 27.396% |
3 | 5<n<=10 Txns | 70824 | 12.124% |
4 | 10<n<=20 Txns | 70760 | 12.113% |
5 | n=1 Txn | 55447 | 9.492% |
6 | 20<n<=50 Txns | 54160 | 9.272% |
7 | 50<n<=100 Txns | 12761 | 2.185% |
Eman-RazDistribution of Users By Transaction
Updated 2025-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with classification as (with tab1 as (select signers[0] as user, count(distinct tx_id) as txns_count, case
when count(distinct tx_id)=1 then 'n=1 Txn'
when count(distinct tx_id)>1 and count(distinct tx_id)<=5 then '1<n<=5 Txns'
when count(distinct tx_id)>5 and count(distinct tx_id)<=10 then '5<n<=10 Txns'
when count(distinct tx_id)>10 and count(distinct tx_id)<=20 then '10<n<=20 Txns'
when count(distinct tx_id)>20 and count(distinct tx_id)<=50 then '20<n<=50 Txns'
when count(distinct tx_id)>50 and count(distinct tx_id)<=100 then '50<n<=100 Txns'
when count(distinct tx_id)>100 then 'n>100 Txns'
end as "Number of Txns"
from eclipse.core.fact_transactions
where succeeded='TRUE'
group by 1)
select "Number of Txns", count(distinct user) as "Number of Users"
from tab1
group by 1),
total_users as (select count(distinct signers[0]) as "Total Users"
from eclipse.core.fact_transactions
where succeeded='TRUE')
select "Number of Txns", "Number of Users", round((("Number of Users"/"Total Users")*100),3) || '%' || '' as "Percentage of Users"
from classification, total_users
order by 2 desc
Last run: 3 months ago
7
227B
491s