I am trying to create a rolling 4 week average conversion rate. The column LTA is the conversion rate and equals (Appts/Leads). RIght now, LTA is week by week. I need to create a new column that is a 4 rolling conversion rate.
Here is the data.
So if we started at the bottom, the RollingAvg for May 29 would be (19+19+32+38)/(25+45+60+82) = 50.943 %
For the week may 22, the numbers would roll back one week, so itd be (19+32+38+0)/(45+60+82+117) = 29.276 %
Help would be appricated.