Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to do comparison with a baseline period?
Hi,
I am trying to create a report where user is prompted to select which is their baseline period. The sales number will be compared with the baseline year (the trend column in the table below).
For example,
| Year | Sales | Trend |
|---|---|---|
| 2010 | $150,000 | 100% |
| 2011 | $175,000 | 117% |
| 2012 | $165,000 | 110% |
| 2013 | $185,000 | 123% |
2014 | $200,000 | 133% |
I have tried to use AGO function. However, the AGO cannot accept number of periods in between as a calculation. So, some like CURRENT_YEAR - BASELINE_YEAR as the number of periods in AGO function.
Is there any other function that I can use to compare sales numbers with a baseline sales number?
Thanks,
Sean
Answers
-
Hello,
First, use analytics functions, and make the formula that you should to use for your percentage:
Oracle BI EE 11g - Calling Database Analytic Functions - EVALUATE - Rittman Mead Consulting
Kind Regards,
0 -
Thank you Cesar for pointing me to the direction. I have tried it. Comparing to AGO function, it seems to be much faster.
The only thing I need to be careful of is the "order by". I need to make sure I have the right dimensions included in the "order by" clause and they are in the proper order.
Thanks,
Sean
0