Skip to Content
0

Runningaverage 10 weeks

Aug 30, 2017 at 07:51 AM

31

avatar image

Hi,

I have year-week dimension and actuals for each month.

Runningsum on week-to-week basis works fine

with: =RunningAverage([Query 365].[1 Incident count])

I would like to have a runningsum counted on 10 weeks period.

Webi 4.2 SP3

/Henrik

10 |10000 characters needed characters left characters exceeded

Sorry, I have of course actuals for each week!

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Aug 30, 2017 at 11:02 AM
0

A little ugly, but try:

=([Query 365].[1 Incident count]+Previous([Query 365].[1 Incident count];1)+Previous([Query 365].[1 Incident count];2)+Previous([Query 365].[1 Incident count];3)+Previous([Query 365].[1 Incident count];4)+Previous([Query 365].[1 Incident count];5)+Previous([Query 365].[1 Incident count];6)+Previous([Query 365].[1 Incident count];7)+Previous([Query 365].[1 Incident count];8)+Previous([Query 365].[1 Incident count];9))/10
Share
10 |10000 characters needed characters left characters exceeded
Henrik Englesson Aug 30, 2017 at 03:40 PM
0

Hi,

Thank you, it works i guess. Have to double check. The ugly part is that it calculates a value at week 1-9 and of course dousens give correct answer. But it is a good start.

Thank you!

Br,

Henrik

Share
10 |10000 characters needed characters left characters exceeded
Henrik Englesson Aug 30, 2017 at 04:12 PM
0

Look's fine! The data for week 1-9 is hidden by checking the weeknumber for week-10w, or actually hide week 1-9 by checking if week previous 10w is null. Thank you again!

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Excellent. Glad it worked.

0