Query editor
with daily as (selectDATE_TRUNC('{{period}}', "date") as "date", chain, rn, sum(volume) as volume, sum(swaps) as swapsfrom query_5560259 -- AUDD DEX Trading - overtime (Multichain)group by 1, chain, rn),ovr as (selectDATE_TRUNC('{{period}}', "date") as "date",volume,chain,rn,swaps,sum(volume) over (partition by chain order by "date") as vol_ovr_chain,sum(swaps) over (partition by chain order by "date") as swp_ovr_chain,sum(volume) over (order by "date") as vol_ovr_all,sum(swaps) over (order by "date") as swp_ovr_allfrom daily)select *from ovrwhere rn = 1order by 1 desc