rolling avergae for 6 months

[koolbachi]

Hi All,

I need to add a rolling 6 month revenue average, where in
its always looking at the last 6 months of revenue from the current month.

if current month is July , it should take an average of the 6 most recent complete months of revenue, which would be Jan,Feb, Mar, April,May,June.

Thanks in advance!!

Gops

[DRL]

To achieve rolling six month window you will first need to create a data item in your query using the date to parse month year combination.

If you don't have a data item with Month year combination, create a new data item in query to parse the date that will give you month year combination. Let's cal lit Month Year

ex: to_char([date], upper('mon - yyyy'))

Using the new data item, Month Year , create two filters in your query to look like this

[Month Year] > add_months ({sysdate}, -7)

[Month Year] <= add_months ({sysdate},-1)


Use this Month year data item in your table/chart display to show six months rolling window

-DRL

[koolbachi]

Hi ,

Thanks for the tip , I will try it and comeback!!


Regards
Gops

[peritas-chris]

Are you using a dimensional or relational source?