Time - (Age | Aging) Report

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.

Example

Retention Rate

Customer - Retention

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

Retention Rate Aging Report

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

Reference





Discover More
Retention Rate
Customer - Retention

retention is a term to represent how many customer are still using the product. It's a measure of growth. Retention rate is an aging report. It shows the number of customer that is using the product...
Cannon Man Graph Time
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...



Share this page:
Follow us:
Task Runner