Time - (Age | Aging) Report

1 - About

An aging or age report shows a metrics by the age of something where the date of birth is generally the start date of a process.

3 - Example

3.1 - Retention Rate

Customer - Retention

The metrics on week3 shows the number that are using the product and have signed-up three weeks ago.

3.2 - Age calculation in Oracle


create table t ( x date );


Table created.


insert into t values ( to_date( '15-mar-1965', 'dd-mon-yyyy' ) );


1 row created.


select ( systimestamp - cast( x as timestamp ) ) year to month from t;


(SYSTIMESTAMP-CAST(XASTIMESTAMP))YEARTOMONTH
---------------------------------------------------------------------------
+44-01


select 
        trunc(months_between(sysdate,x)/12) years,
        months_between(sysdate,x)-12*trunc(months_between(sysdate,x)/12) months
from t;


YEARS     MONTHS
---------- ----------
        44 1.05426971

4 - Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap