Forum Discussion
Ben83
10 years agoAdvocate IV
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...
- 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.
kcantor
10 years agoCommunity Champion
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.
- Ben8310 years agoAdvocate IV
Awesome! That's what I am looking for. Thank you very much for the usefull help!