Query editor
with base_data as (selectdate_trunc('day', ts_source) as date,count(*) as messages,sum(coalesce(usd_value, 0)) as usd_volumefrom layerzero.messageswhere project = '{{Project Analyzer Project Name}}'group by 1), cumulative_data as (selectdate,messages,usd_volume,sum(messages) over (order by date) as cumulative_messages,sum(usd_volume) over (order by date) as cumulative_usd_volume,avg(messages) over (order by date rows between 29 preceding and current row) as messages_30d,avg(usd_volume) over (order by date rows between 29 preceding and current row) as usd_volume_30dfrom base_data) select *from cumulative_datawhere date > date '1970-01-01'order by 1 desc;