akbaridriaosmosis transactions 2
Updated 2022-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with data_tx as (
select
tx_status,
'osmosis' as labeling,
count(*) as total
from
osmosis.core.fact_transactions
where
block_timestamp::date >= CURRENT_DATE - 120
group by 1
),
data_all as (
select 'osmosis' as labeling, sum(total) as total from data_tx
)
select
(a.total/b.total)*100 as percentage
from data_tx a join data_all b on a.labeling = b.labeling and a.tx_status = 'FAILED'
Run a query to Download Data