Forum Discussion

Ben83's avatar
Ben83
Advocate IV
10 years ago
Solved

Trend calculation

I hope you can help me to find a solution for my problem. I want to visualize the trend of my companies delivery reliability (OTIF - on time in full). I have a table which contains every single deliv...
  • kcantor's avatar
    10 years ago

     

    I did something similar in our data to show a moving averege of quantiy sold over the past three months. I followed the advice on the following blog in order to capture and quantify the appropriate averages.

     

    http://www.powerpivotpro.com/2013/07/moving-averages-sums-etc/

     

    It was very easy to follow along with this particular blog.