Afonso_DiazSuccess Rate
    Updated 2025-04-11
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    tx_fee,
    tx_succeeded
    from
    mezo.testnet.fact_transactions
    )

    select
    count(distinct tx_hash) as transactions,
    (count(distinct iff(tx_succeeded, tx_hash, null)) / transactions) * 100 as success_rate
    from
    main



    Last run: 17 days ago
    TRANSACTIONS
    SUCCESS_RATE
    1
    7668995.6943
    1
    17B
    1s