tx Sucess rate % | |
|---|---|
1 | 99.8336 |
Mrfti2024-07-24 06:13 PM copy copy
Updated 21 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from 2024-07-24 06:13 PM copy @ https://flipsidecrypto.xyz/studio/queries/3607744d-70e5-458d-83af-4d1e3c3a88ca
with alltx AS
(
SELECT
count (DISTINCT tx_hash) as "Total Transaction"
from swell.core.fact_transactions
)
, succeededtx AS
(
SELECT
count (DISTINCT tx_hash) as "Total Suceeded Transaction"
from swell.core.fact_transactions
where TX_SUCCEEDED = 'TRUE'
)
SELECT
"Total Suceeded Transaction"/"Total Transaction"*100 as "tx Sucess rate %"
from alltx join succeededtx
Last run: about 21 hours agoAuto-refreshes every 12 hours
1
11B
246s