Time Series - Function and Calculation (AGO, YTD, ...)
Table of Contents
1 - About
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.
2 - Articles Related
3 - List
3.1 - 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.
3.2 - 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.
3.3 - 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.
3.4 - MTD Sale
It means the summation of sales from first of the current month to the Current Date.
4 - Others
4.1 - Sinusoidal
Trigonometry - Sinusoidal functions: Time by gravitation