Get Cummulative Unique Contacts

Asked Apr 29 '20 at 11:01

Active Apr 29 '20 at 13:02

Viewed 44 times

I am wondering how to go about returning number of unique contact added on a daily basis

    leads       callDates
    000125324   2020-04-01
    00059926437 2020-04-01
    00040129160 2020-04-01
    00041834922 2020-04-01
    00057585341 2020-04-01
...               ...        ...
    00055846603 2020-04-27
    00042104902 2020-04-27
    00049923128 2020-04-27
    00092871326 2020-04-27
    0003642000  2020-04-27

Assuming I have a list of leads that keeps growing on a daily basis and there is a possibility of lead duplication, how do I keep track of growth of only unique lead values in my list over time?

Expected Output

    callDate  leadsGrowth 
    2020-04-01      2
    2020-04-02      4
    2020-04-03      5
    2020-04-04      5

where leadsGrowth is the sum of unique leads from preceding/days plus any new leads added today.

edited Apr 29 '20 at 12:00

asked Apr 29 '20 at 11:01

Tito Lulu

Can there be more than 1 leads per day? – yatu Apr 29 '20 at 11:08
@jezrael, yes more less – Tito Lulu Apr 29 '20 at 11:08
@TitoLulu - Can you create [minimal, complete, and verifiable example](http://stackoverflow.com/help/mcve) ? Add mainly duplicated datetimes. – jezrael Apr 29 '20 at 11:09
OK, so I think solution bellow should working nice. – jezrael Apr 29 '20 at 11:32
I think it was quite obvious from the question statement @jezrael , not a simple cumsum dupe. Also I had already answered the question – yatu Apr 29 '20 at 11:36
@yatu - ya, I am sorry. – jezrael Apr 29 '20 at 11:37
Please update your question with the new data sample you've provided, which makes it much clearer – yatu Apr 29 '20 at 11:38
Please add the expected output too for the new example so I can update my answer too – yatu Apr 29 '20 at 11:51
@yatu thanks this was the closest solution to what I was looking for – Tito Lulu May 08 '20 at 15:03

Get Cummulative Unique Contacts

0 Answers0