flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
BOBA 03
par_rn
BOBA 03
Updated 2025-03-03
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
ROUND
(
(
COUNT
(
CASE
WHEN
TX_SUCCEEDED
=
TRUE
THEN
TX_HASH
END
)
*
100.0
)
/
COUNT
(
DISTINCT
TX_HASH
)
,
2
)
AS
success_rate
FROM
boba
.
core
.
fact_transactions
WHERE
BLOCK_TIMESTAMP
>=
'2024-01-01'
Results
Last run: 17 days ago
SUCCESS_RATE
1
99.85
1
1
9B
2s