Query editor
WITH ss (tx_month, failed_txs, success_txs) AS (SELECT *FROM (SELECTtx_month,SUM(CASE WHEN NOT success THEN 1 ELSE 0 END) AS failed_txs,SUM(CASE WHEN success THEN 1 ELSE 0 END) AS success_txsFROM query_3203448 AS txsWHERE '{{network}}' = 'all' OR network = '{{network}}'GROUP BY tx_monthORDER BYtx_month DESC NULLS FIRST) AS txsUNIONSELECT"month" AS tx_month,0,0FROM query_3093463 AS time_series)SELECTtx_month,SUM(failed_txs) AS failed_txs,SUM(success_txs) AS success_txsFROM ssGROUP BY tx_monthORDER BY tx_month DESC NULLS FIRST