Moving Average

Avatar
JP

I have a line graph in Wrike Analyze with month-year plotted on the x axis and Actual Cost plotted in the y axis. Is there any way to show to Actual Cost as a rolling 3 month average for each month plotted? 

For Sep-2024, y axis would show the average Actual Cost for Jul, Aug, and Sep 2024. 

For Aug-2024, y axis would show the average Actual Cost for  Jun, Jul, and Aug 2024. 

Thank you

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 comment
Avatar
Pietro Poli

Hi JP,
in date fields you can filter for Last 2 Months


Then clic on Advanced and select put 3 on count field > It will takes last 3 months.
If you set "offset" on 1 it will remove actual month - September



Here I removed september and august (offset=2).


It can works for you?

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Moving Average
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post