Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago

how to calculate an average of Prior 8 or 12 quarters on a rolling basis? has anyone done it? please share.

Originally posted by Ashok Amresh

I am trying get rolling average of an Account (i.e. average of prior 8 OR 12 quarters  ). i am New to Onestream and really finding hard to find function etc. any help is appreciated.

1 Reply

  • I would suggest to try using a combination of the Time Dimension and the View Dimension to potentially resolve this.  Try using T#QuarterPrior8():V#QuarterAvg