kentogrim-gold
Updated 2024-11-01
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
25
26
27
›
⌄
SELECT
'Successful Transactions' AS slice_name,
CASE
WHEN SUM(TRANSACTION_COUNT) > 0 THEN
(SUM(TRANSACTION_COUNT_SUCCESS) / SUM(TRANSACTION_COUNT)) * 100
ELSE 0
END AS percentage
FROM sei.stats.ez_core_metrics_hourly
WHERE BLOCK_TIMESTAMP_HOUR >= '2024-10-01'
AND BLOCK_TIMESTAMP_HOUR < '2024-11-01'
UNION ALL
SELECT
'Failed Transactions' AS slice_name,
CASE
WHEN SUM(TRANSACTION_COUNT) > 0 THEN
(SUM(TRANSACTION_COUNT_FAILED) / SUM(TRANSACTION_COUNT)) * 100
ELSE 0
END AS percentage
FROM sei.stats.ez_core_metrics_hourly
WHERE BLOCK_TIMESTAMP_HOUR >= '2024-10-01'
AND BLOCK_TIMESTAMP_HOUR < '2024-11-01';
QueryRunArchived: QueryRun has been archived