ValiMohammadiTransaction on Solana network in the 2022 (Daily chart)
    Updated 2022-07-13
    SELECT block_timestamp::DATE AS Dates, COUNT(tx_id) AS "Number of Transaction", COUNT(CASE WHEN SUCCEEDED = true then 1 else null end) as "Number of Success Transaction", COUNT(CASE WHEN SUCCEEDED != true then 1 else null end) as "Total of Transaction Failed", COUNT(DISTINCT signers[0]) as "Number of Users" FROM solana.core.fact_transactions
    WHERE block_timestamp::DATE <= CURRENT_DATE - 1 AND block_timestamp::DATE >= '2022-01-01'
    GROUP BY Dates
    ORDER BY Dates
    Run a query to Download Data