flipside

    harsh-apricot
    Mrftiharsh-apricot
    Updated 21 hours ago
    SELECT
    COUNT(DISTINCT REGEXP_SUBSTR(fee_msg['transition']['outputs'][0]['value'], 'aleo[\\w]+')) AS "Total unique users"
    FROM aleo.core.fact_transactions
    WHERE tx_succeeded = TRUE;

    Last run: about 21 hours agoAuto-refreshes every 12 hours
    Total unique users
    1
    		1861181
    1
    11B
    30s