DataBeingTransaction Failure - Withas
Updated 2022-03-23
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
28
29
30
31
32
›
⌄
-- 3 select statement as with as - failed & succeeded with block_timestamp trunc day - make a table that joins these and does calculation of percentage
with failed as (
SELECT date_trunc('day', block_timestamp) as day, count(block_id) as failed_transactions
FROM terra.transactions
WHERE tx_status = 'FAILED'
GROUP BY 1
),
succeeded as (
SELECT date_trunc('day', block_timestamp) as day, count(block_id) as successful_transactions
FROM terra.transactions
WHERE tx_status = 'SUCCEEDED'
GROUP BY 1
),
total as (
SELECT date_trunc('day', block_timestamp) as day, count(block_id) as transactions
FROM terra.transactions
GROUP BY 1
)
SELECT t.transactions, f.failed_transactions, t.day
FROM total t
LEFT JOIN failed f
ON t.day = f.day
GROUP BY 1, 2, 3
-- ROUND((SELECT sum(swaps) from bots) * 100/ count (*), 1) as percentage_bots,
-- date_trunc('month', block_timestamp) as Month
Run a query to Download Data