AnsweredAssumed Answered

Dynamic Rolling Average

Question asked by kellygoldsworthy on May 17, 2018
Latest reply on May 18, 2018 by pdicino

I am looking to create a dynamic period, over which I can calculate a rolling average.

For example:

Daily usage period = 7

Average sales over period will then be from today, backward looking for 7 days.

 

The problem is that the period may be different for every sales location, and could be changed daily.

For example:

 

location: 1234      date: 17.05.2018      Daily usage period: 7

location: 1234      date: 20.05.2018      Daily usage period: 4

 

location: 9632      date: 17.05.2018      Daily usage period: 7

location: 9632      date: 20.05.2018      Daily usage period: 7

 

Any suggestions?

 

I have created an input cube for the daily usage period by location. 

Outcomes