TOTAL_SUCCESSFUL_TRANSACTIONS | TOTAL_FAILED_TRANSACTIONS | OVERALL_SUCCESS_PERCENTAGE | OVERALL_FAILURE_PERCENTAGE | |
---|---|---|---|---|
1 | 3376310 | 37772 | 98.893641 | 1.106359 |
crypto_gostshivering-copper
Updated 2025-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
SUM(successful_transactions) AS total_successful_transactions,
SUM(failed_transactions) AS total_failed_transactions,
SUM(successful_transactions) * 100.0 / NULLIF(SUM(successful_transactions) + SUM(failed_transactions), 0) AS overall_success_percentage,
SUM(failed_transactions) * 100.0 / NULLIF(SUM(successful_transactions) + SUM(failed_transactions), 0) AS overall_failure_percentage
FROM (
SELECT
COUNT(CASE WHEN tx_succeeded = TRUE THEN 1 END) AS successful_transactions,
COUNT(CASE WHEN tx_succeeded = FALSE THEN 1 END) AS failed_transactions
FROM
ALEO.core.fact_transactions
WHERE
block_timestamp >= DATEADD(DAY, -30, GETDATE())
) AS daily_totals;
Last run: about 2 months ago
1
36B
2s