flipside

    Untitled Query
    MahrooUntitled Query
    select 'July Success rate' as status , block_timestamp::date as day, count(DISTINCT tx_id) as trans
    from solana.core.fact_transactions
    where SUCCEEDED = 'TRUE'
    group by status , day
    UNION
    select 'Other month success rate' as status , block_timestamp::date as day , count(DISTINCT tx_id) as trans
    from solana.core.fact_transactions
    where block_timestamp >= '2022-06-01' and SUCCEEDED = 'FALSE'
    group by status , day
    Run a query to Download Data