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.

Dashboards

1 Reply

Sort By
  • TonyToniTone's avatar
    TonyToniTone
    Contributor II
    4 years ago

    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