I have a dimension "Year_Quarter" (formated as "Abc") with following shaping:
I will create with this dimension a yearly moving average.
Q3/2015 includes 2014_Q4, 2015_Q1, 2015_Q2, 2015_Q3
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!
Time formatted as text always worries me, but I would use a WINDOW_AVG function :
Don't create a dimension with Q3/2015 and Q4/2015, just use the dimension you have and use the arguments to WINDOW_AVG to choose the current month and the 2 previous.