flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
BOBA 03
par_rn
BOBA 03
Updated 2025-05-08
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
QueryRunArchived: QueryRun has been archived