Query editor
with tx_base as (select date_trunc('{{time}}', action_time) as time,case when chain_id='1' then 'Ethereum'when chain_id='5' then 'Goerli'when chain_id='10' then 'Optimism'when chain_id='56' then 'BNB'when chain_id='100' then 'Gnosis'when chain_id='137' then 'Polygon'when chain_id='169' then 'Manta'when chain_id='324' then 'zkSync'when chain_id='420' then 'Optimism Goerli'when chain_id='1088' then 'Metis'when chain_id='1101' then 'Polygon zkEVM'when chain_id='7000' then 'Zeta'when chain_id='7700' then 'Kanto'when chain_id='8453' then 'Base'when chain_id='34443' then 'Mode'when chain_id='42161' then 'Arbitrum'when chain_id='42220' then 'Celo'when chain_id='43114' then 'Avalanche'when chain_id='59144' then 'Linea'when chain_id='80001' then 'Mumbai'when chain_id='80085' then 'Bera'when chain_id='84531' then 'Base Goerli'when chain_id='421613' then 'Agor'when chain_id='534352' then 'Scroll'when chain_id='7777777' then 'Zora'when chain_id='1313161554' then 'Aurora'when chain_id='Solana' then 'Solana'when chain_id='13371' then 'Immutable'when chain_id='252' then 'Fraxtal'when chain_id='7560' then 'Cyber'when chain_id='690' then 'Redstone'when chain_id='122' then 'Fuse'when chain_id='81457' then 'Blast'when chain_id='167000' then 'Taiko'when chain_id='5000' then 'Mantle'when chain_id='196' then 'X Layer'when chain_id='128123' then 'Etherlink'when chain_id='11155111' then 'Thanos'when chain_id='53302' then 'Superspeed'when chain_id='250' then 'Fantom'end as chain_text,count(distinct address) as users,count(distinct tx_hash) as txsfrom dune.l3.dbt_dune_attributable_txswhere chain_id not in('5', '420', '84531')group by 1,2),users as (select distinct min_time, count(min_time) over(order by min_time) as users from (select date_trunc('{{time}}',min(action_time)) as min_time,addressfrom dune.l3.dbt_dune_attributable_txswhere chain_id not in('5', '420', '84531')group by address))select time,'Total' as blockchain,sum(txs) over(order by time) as txs,