par_rnSwell 05
    Updated 2025-02-01
    WITH transaction_status AS (
    SELECT
    COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = TRUE THEN TX_HASH END) AS successful_transactions,
    COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = FALSE THEN TX_HASH END) AS failed_transactions
    FROM swell.core.fact_transactions
    )
    SELECT
    'Successful' AS transaction_status, successful_transactions AS total_transactions
    FROM transaction_status
    UNION ALL
    SELECT
    'Failed' AS transaction_status, failed_transactions AS total_transactions
    FROM transaction_status

    Last run: 24 days ago
    TRANSACTION_STATUS
    TOTAL_TRANSACTIONS
    1
    Successful3089007
    2
    Failed3333
    2
    40B
    1s