Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to get a running aggregate for the last 12 months

Accepted answer
51
Views
3
Comments
User_OBCXC
User_OBCXC Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Hi everyone,

I have an analysis where I calculate the win and losses (in percentage) for every month.
The screenshots are the criteria and the results of my analysis.

Picture1.png Picture1.png

Is it possible to somehow create another column (called "aggregate") to get the running aggregate of the last 12 months? If yes, how should I proceed?


Thank you in advance for your support.

Best Regards

Tagged:

Best Answer

Answers