Weighted Average by variable number of weeks
I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable amount of weeks
For example, a user selects the number of weeks they want to average the results by and based on that amount of weeks, there is different weighting by percentage..
Module: Made up of 2 lists(Weekly Percentages; Number of Weeks Average') and 1 line item (Percent)
I have set up a list for 'Number of weeks average' to select the # of weeks we want to average, and a list for 'weekly percentages' for the % needed for the corresponding week.. i.e. if you choose a 5 week average, week 1 will be weighted at 24%, week 2 at 22% and so on..If you choose 6 weeks, those percentages change according to what percentage is in the module
Can assist me with this? Have any examples or can you point me in the right direction? I am drawing a blank and I feel like it shouldn’t be that complicated...