abbasian34Untitled Query
    Updated 2023-01-23
    with Table1 as (
    select tx_sender as New_User,
    min (block_timestamp) as mindate
    from terra.core.fact_transactions
    where tx_succeeded = 'TRUE'
    group by 1),

    New_Users as (
    select block_timestamp,
    tx_id,
    tx_sender
    from terra.core.fact_transactions t1 join Table1 t2 on t1.tx_sender = t2.new_user
    where mindate >= '2023-01-14')

    select project_name,
    count (distinct t1.tx_id) as TX_Count,
    count (Distinct tx_sender) as Users_Count
    from terra.core.fact_msgs t1 join terra.core.dim_address_labels t2 on t1.msg:attributes[0]:value = t2.address
    join New_Users t3 on t1.tx_id = t3.tx_id
    where tx_succeeded = 'TRUE'
    and t1.block_timestamp >= '2023-01-07'
    group by 1
    Run a query to Download Data