flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
All Time stats
feyikemi
All Time stats
Updated 2024-12-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
With
Total_stats
AS
(
SELECT
COUNT
(
DISTINCT
Authorizers
[
0
]
)
AS
Total_Users
,
COUNT
(
DISTINCT
TX_ID
)
AS
Total_Txn
FROM
flow
.
core
.
fact_transactions
WHERE
Tx_succeeded
=
'True'
)
SELECT
Total_Users
,
Total_Txn
FROM
Total_stats
Results
QueryRunArchived: QueryRun has been archived