Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Average for last 7 days

916305Apr 20 2012 — edited Apr 21 2012

I am trying to calculate Deviation Measure for the Reports and the formula to calculate is –

(average(last 7 days count ) – today’s count/100 )*10

Problem here is to calculate average for last 7 days .
I am using moving average but if I apply a filter , Moving average is calculated for the number of rows displayed whereas I want it for the number of days.

Formula for Moving average is - MAVG(Row Count,n) where n is number of rows displayed and not number of days. Is there any possible way to do it.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2012

Added on Apr 20 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

371 views