kiacryptoThe number of fail transaction of each flow addresses
    Updated 2022-06-04
    select payer, count(*) as fail_tx
    from flow.core.fact_transactions
    where tx_succeeded = false
    group by 1 having fail_tx > 100
    order by 2 desc

    Run a query to Download Data