Categories
- All Categories
- 166 Oracle Analytics News
- 33 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Getting a Month over Month Visual
Summary
I have a months view of data and need to get a Month over Month calculation added
Content
Based on the image I need to create a calculated field taking comparing October to November. The formula would be November/October -1.
Need it for each of the pay channels listed. How can that be created in the calculated option?
Answers
-
Hi Craig, assuming your data is not from an OAC RPD with a time hierarchy defined in it.
That is, data is from direct simple flat source (file, db). You can achieve this calculation using an MSUM formula. Check this brief video about it : Oracle DV - How to Calculate Period Ago Without A Time Hierarchy.
however, if you are using this in combination with other dimension (your table below), you need to introduce a 'by' clause in the formula. here is another small video showing you that syntax : https://youtu.be/LkRHUlXvTbQ
Hope that helps
Philippe
0
