Total call Date report using increment date

[dbajay]

Hello,

I would like to know a clue about the following report

Churn

This report produces, for the calls received on the last date, how many of them called for the first time on the start date, how many on the start date + 1, start date + 2, etc.
The changes we need are:
We need to show only totals for this report. Currently, there's a row for every customer, but we only care how many of them called x days ago.
For example, the query should return something like this:
Active Life (days) Qty
62 84
63 135
62 211
... ...
1 12453
0 34128

Please find the script for generating tables with sample data

SQL>create table calls
2 as
3 select 441132394629 cli, to_date('02102006','ddmmyyyy') call_date from dual union all
4 select 441132394629, to_date('05102006','ddmmyyyy') from dual union all
5 select 441132533793, to_date('04102006','ddmmyyyy') from dual union all
6 select 441132533793, to_date('05102006','ddmmyyyy') from dual union all
7 select 441142373223, to_date('04102006','ddmmyyyy') from dual union all
8 select 441142373223, to_date('05102006','ddmmyyyy') from dual union all
9 select 441227763301, to_date('02102006','ddmmyyyy') from dual union all
10 select 441227763301, to_date('04102006','ddmmyyyy') from dual union all
11 select 441227763301, to_date('05102006','ddmmyyyy') from dual union all
12 select 441227763301, to_date('08102006','ddmmyyyy') from dual

Your help would be highly appreciated.

Thanks in advance.

Jayesh

[davey23uk]

posting peoples phone numbers on here isn't such a great idea

[dbajay]

That's correct. I'll take care when I submit data as sample. But, I di not mean to circulate these numbers. It was just provided for testing purpose only.

Anway, thanks for your notice.

Jayesh

[dbajay]

Hi,

Can I have any update on this query?

Thnx
jayesh