Skip to Content
0
Former Member
Mar 26, 2015 at 08:24 PM

Rolling 90 Days for Each Day

333 Views

I am trying to resolve a metric where I have to compute a Rolling 90 days average for each week. The formula needs to determine if it has a complete 90 days. We do not have access to the Universe level because we are using Rich Client 4.1. We also need to be able to use input controls in the report on these 90 day measurements.



For Example:

Report Date: 4/1/2015
Name Metric Date Range Average Calculation
Bob 7.5 1/1/2015-4/1/2015
Billly 9.4 1/1/2015-4/1/2015

Report Date 4/8/2015
Name Metric Date Range Average Calculation
Bob 7.8 1/8/2015-4/8/2015
Billly 9.9 1/8/2015-4/8/2015

Note: The "metric" is an average of the 90 date range. We store our information as follows:
Date Name Metric
4/8/2015 Bob 7
4/7/2015 Bob 16
4/6/2015 Bob 5
4/5/2015 Bob 12
4/4/2015 Bob 2
4/3/2015 Bob 11
4/3/2015 Bob 5
4/1/2015 Bob 10
....

Thank you!