1 Reply Latest reply on Mar 12, 2017 9:04 PM by Chris McClellan

    Yearly Moving Average

    robert.linz

      Hi all,

       

      I have a dimension "Year_Quarter"  (formated as "Abc") with following shaping:

       

      2014_Q1

      2014_Q2

      2014_Q3

      2014_Q4

      2015_Q1

      2015_Q2

      2015_Q3

      2015_Q4

      ....

       

      I will create with this dimension a yearly moving average.

       

      For example:

      Q3/2015 includes 2014_Q4, 2015_Q1, 2015_Q2, 2015_Q3

      or

      Q4/2015 includes 2015_Q1, 2015_Q2, 2015_Q3, 2015_Q4

       

      Because of the moving average it is not possible to use a static aggregation.

       

      In my opinion a calculation is the solution.

       

      Thanks a lot for your help!

       

      Regards, Robert