Flipside Axelar AnalystsTotal Number of Transactions By Type
    Updated 2024-05-27
    with tab1 as (
    select count(distinct id) as "TXs Count", 'GMP' as "Type"
    from axelar.axelscan.fact_gmp
    where created_at::date>=current_date-{{Time_Interval}}),

    tab2 as (select count(distinct id) as "TXs Count", 'Transfers' as "Type"
    from axelar.axelscan.fact_transfers
    where created_at::date>=current_date-{{Time_Interval}})

    select * from tab1 union all
    select * from tab2
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived