Dear colleagues:
I have a counter key figure to display the number of purchase items delivered on time on a monthly basis (the month of 0DSDEL_DATE).
However, I need to calculate a moving average from the 3 months before each Characteristic Value on 0DSDEL_DATE.
By doing this, the bar diagram will be able to show the on time delivered items and also a line diagram showing the 3 monthly moving average.
The question is:
<b>What is the best procedure to calculate such moving average key figure? </b>
Best regards
Waldemar