S
sabrown
I need a function or query to allow me to collect data for overlapping
time periods. The idea is to collect sales data for a series of time
frames N days in length on a rolling basis. For example... with N =
21, Day 1 forward 21 days, then day 2 forward 21 days, then day 3
forward 21 days etc. till the end of the data set. The purpose is to
develop an average and standard deviation for these results. The data
must be overlapping because all 21 day periods are valid. Consecutive
(non-overlapping) 21 day periods is not adequate.
In excel this is easy using the Offset function. But the data sets I
need to process are too big.
Scott
time periods. The idea is to collect sales data for a series of time
frames N days in length on a rolling basis. For example... with N =
21, Day 1 forward 21 days, then day 2 forward 21 days, then day 3
forward 21 days etc. till the end of the data set. The purpose is to
develop an average and standard deviation for these results. The data
must be overlapping because all 21 day periods are valid. Consecutive
(non-overlapping) 21 day periods is not adequate.
In excel this is easy using the Offset function. But the data sets I
need to process are too big.
Scott