Query editor
selectCOUNT(casewhen success = truethen 1end) as total_successful_txs, COUNT(casewhen success = falsethen 1end) as total_failed_txs, COUNT(*) as total_transactions, ROUND((COUNT(casewhen success = truethen 1end) * 100.0) / NULLIF(COUNT(*), 0), 2) as overall_success_rate_percentfrom solana.transactionswhere block_date is not null;