shadilWhen Do Flow Transactions Fail? (Part II) - Solana
    Updated 2022-06-07
    select
    date_trunc('hour', block_timestamp) as datetime,
    count(
    case
    when succeeded = 'FALSE' then succeeded
    end
    ) as fails,
    count(
    case
    when succeeded = 'TRUE' then succeeded
    end
    ) as success,
    count(DISTINCT tx_id) as tx_count,
    success / (tx_count) as success_rate
    from
    flipside_prod_db.solana.fact_transactions
    where
    block_timestamp::date >= '2022-05-11'
    group by
    datetime
    order by
    datetime
    Run a query to Download Data