Flipside TeamNEP245 - Count Metrics
    Updated 20 hours ago
    with source_data as (
    select
    *
    from
    $query('f7283bcc-2a59-45fe-8173-276bc7031ad0')
    ),
    metrics as (
    select
    count(distinct tx_hash) as tx_ct,
    count(distinct blockchain) as blockchain_ct,
    count(distinct token_id_raw) as token_ct,
    count(distinct receipt_id) as receipt_ct
    from
    source_data
    ),
    user_ct as (
    select
    count(distinct account_id) as account_ct
    from
    (
    select
    distinct owner_id as account_id
    from
    source_data
    union
    select
    distinct old_owner_id as account_id
    from
    source_data
    union
    select
    distinct new_owner_id as account_id
    from
    source_data
    )
    )
    Last run: about 20 hours agoAuto-refreshes every 24 hours
    TX_CT
    RECEIPT_CT
    BLOCKCHAIN_CT
    TOKEN_CT
    ACCOUNT_CT
    1
    237522378113631764
    1
    26B
    2s