nitsTransaction Failure
    Updated 2022-03-20
    SELECT day,
    count(*)as total_txs,
    sum(tx_status_int) as success_txs,
    total_txs-success_txs as failed_txs,
    failed_txs/success_txs*100 as percent_failed_to_sucess,
    failed_txs/total_txs*100 as percent_failed_to_total,
    SUM(failed_txs) OVER(ORDER BY DAY) AS Cumulative_failed_txs,
    sum(total_txs) over(order by day)as cumulative_total_Txs,
    sum(success_txs) over (order by day) as cumulative_success_txs,
    Cumulative_failed_txs/Cumulative_success_txs*100 as Cumulative_percent_failed_to_sucess_txs,
    Cumulative_failed_txs/Cumulative_total_txs*100 as Cumulative_percent_failed_to_total_txs
    from
    (SELECT *,date(block_timestamp) as day, case when TX_STATUS = 'SUCCEEDED' then 1 else 0 end as tx_status_int
    from terra.msgs
    where day > CURRENT_DATE -210 )
    GROUP by 1
    order by 1

    Run a query to Download Data