Skip to Content

Runningaverage 10 weeks

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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
    Add comment
    10|10000 characters needed characters exceeded

  • Aug 30, 2017 at 03:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 30, 2017 at 04:12 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded