Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
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

  • TonyToniTone's avatar
    TonyToniTone
    Icon for OneStream Employee rankOneStream Employee
    5 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