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

    Moving 31-Day Sales with Week Number as a Dimension

    May Javier

      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?

       

      Thanks!