04-24-2018 01:02 PM
I need your help to calculate running avearages of transaction amount (tran_amt)backward from current day (t) to last 1day , last7days and last15 days by account number (acc_id). please use the below data and sample calculations are shown in the columns Avg_L1D ( average(t + t-1), Avg_L7d (average( t, t-1,t-2,t-3,t-4,t-5,t-6,t-7) ) if any of lag transactions missing it shoud discard say if t-6 is missing then average will be average(t,t-1,t-2,t-3,t-4,t-5,t-7) etc. similarly for Avg_L15D...
CSV file attached for rawdata and the sample calcuation
thanks for your help
04-24-2018 01:43 PM
If you could please explain the calculation in terms of your numbers in the sample rather than algebraically, I would like to attempt .
04-25-2018 02:11 AM