Recently I wanted to do a short demo on how to use Time Series functions in My Calculations in Oracle Analytics , more specifically how to create a new calculation using Ago function in Data Visualization workbook . Very straightforward, one would say, however, it is not. There is a known bug , quite well documented in Oracle Support, however, let me describe it briefly and provide a short workaround. Let’s start with this simple report: Now, let’s create a new calculation that uses AGO function, which has the following notation: Ago(<<Measure>>, <<Level>>, <<Number of Periods>>) There is no secret about that, right? Well, there might be some … As I mentioned, when you create a new calculation in Data Visualization workbook, you need to be careful when typing the <<Level>> part of the formula. For example, if you follow the standard notation, then the formula should look like this: Note: in the formula above I added extra space b...
Oracle Analytics & Data Science