Query editor
SELECTDATE_TRUNC('month', date) as month,SUM(successful_transactions) as successful_txs,SUM(failed_transactions) as failed_txs,SUM(total_transactions) as total_txs,ROUND(100.0 * SUM(successful_transactions) / NULLIF(SUM(total_transactions), 0), 2) as success_rate_percentFROM solana.blocksWHERE date >= DATE '2025-10-01'AND total_transactions > 0GROUP BY 1ORDER BY 1