I have been working in Mode for some time and have only jus figured out hw to give me the monthly cumulative total as of today for a value. I asked for a little help from somewhere which works. But there is one string I dont understand. Please can someone explain this bit to me..
date_trunc('day', convert_timezone('UTC', a.timezone, oi.timestamp)) between date_trunc('month', convert_timezone('UTC', a.timezone, getdate())) and convert_timezone('UTC', a.timezone, getdate()) the_date,
I would like ot have this broken down and explained but cant figure it out. Any help is much appreciated.