feyikemiFlow Q1 count
Updated 2024-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
COUNT(DISTINCT TX_ID) AS Total_Transactions,
COUNT(DISTINCT Authorizers[0]) AS Total_Users
FROM flow.core.fact_transactions
WHERE
DATE_PART('quarter', block_timestamp) 1
AND
DATE_PART('year', block_timestamp) = 2024
AND
Tx_succeeded = 'True'
QueryRunArchived: QueryRun has been archived