Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i have the chart attached to this post.
In this same chart i need also to calculate for each week the average value of the last 4 weeks.
Can you please help me?
Thanks,
LB.
like this?
Update : For average
Avg({<WeekID = {">=$(=Max(WeekID)-3)"}>}k)
Here it is an example
Hi and thx for the answers..
but i need to see both the expression:
- sum(k)
- avg (sum(k) last 4 weeks)
Add one more expression of avg with my given file
Please see the attached file
Regards
Alan