0 Replies Latest reply: Jun 21, 2016 1:01 AM by May Javier RSS

    Moving 31-Day Sales with Week Number as a Dimension

      Hi Guys!


      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:



      Moving 31 Day Sales.PNG


      Is it attainable to insert a set analysis? or would it be better to code in the data load?