Moving 31-Day Sales with Week Number as a Dimension
I want to create a column chart with week number as a dimension and the measure of each would be each week's accumulated sales 31 days back. (e.g WK25 = Sum of May 20 until Jun 19 2016 Sales, WK24 = May 13 to Jun 12 2016 Sales, so on.)
I imagine it to be like this:
Is it attainable to insert a set analysis? or would it be better to code in the data load?