# Time Series - Function and Calculation (AGO, YTD, )

Time Series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods. For example, time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

## List

### Ago

Calculates the aggregated value from the current time back to a specified time period.

For example, Ago can produce sales for every month of the current quarter and the corresponding quarter-ago sales.

### YTD Sale

It means the summation of sales from 1st Jan of the current year to the Current Date. The current Date is kind of a misnomer since its value can vary(can have values like day, month, quarter etc) depending on the granularity. We will understand this while going over these functions in detail.

### QTD Sale

It means the summation of sales from first of first month of the current quarter of the current year to the Current Date.

### MTD Sale

It means the summation of sales from first of the current month to the Current Date.

## Others

### Sinusoidal

Trigonometry - Sinusoidal functions: Time by gravitation

Discover More
(Function | Operator | Map | Mapping | Transformation | Method | Rule | Task | Subroutine)

Section computable function. A function is a callable unit that may be called: a procedure, a subrontine a routine, a method (belong to an objectmacrocomputablalgorithreusable blocargumentdevelopment...
Analytic (Data Analyst)

A Data Analyst sees what data he has. A Data Scientist imagines what data he is lacking. Information analysis provides insight into : the past the present and the future of the business. See...
Blog - Obiee 10G - Densification with the OBIEE logical Sql (Sparse to dense data)

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. And it’s also the most problem that you have when you...
Dimensional Data Operation - Data Densification (sparse to dense data) - Preservation of the dimensions

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The densification is also : known as thepreservation...
OBIEE - Densification with logical Sql

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. And it's also the most problem that you have when you work...
OBIEE - Time Series Conversion Functions : AGO and TODATE

Time series functions in OBIEE. The implementation of the time serie function is based on the time dimension. ( See set up time dimensions) At query time, the Oracle BI Server then generates SQL that...
Trigonometry - Sinusoidal functions

A sinusoidal function is a time function and At the left, a cabin moving along a circle. At the right, the height of the cabin against time. ...
What are the LAG and LEAD SQL functions ?

lag and lead are Sql window functions that provide access to a row at a given offset prior to/after the current row position.