I am looking to create a dynamic period, over which I can calculate a rolling average.
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.
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
I have created an input cube for the daily usage period by location.