Elprognerd4-tot performance
Updated 2023-01-04
9
1
2
3
4
5
6
7
8
›
⌄
select
--block_timestamp::date as date,
count(TX_HASH) as "Number of Total Txs",
count(case when tx_STATUS = 'Success' then TX_HASH end) as "Number of Successful Txs",
("Number of Successful Txs" / "Number of Total Txs")*100 as "Successful Txs Rate",
(100 - "Successful Txs Rate") as "Failed Txs Rate"
from near.core.fact_transactions
--group by 1
Run a query to Download Data