Cumulative new contacts in graph

[Anonymous]

Hi

I need to make a graph which shows cumulative count of new contacts over time. 

For exampe:

customer A contacts 3 times in Jan

customer B contacts 4 times in Jan

customer A contacts 3 times in Feb

customer C contacts 1 times in Feb

customer A,B and C contacts 3 times in Mar

customer D contacts 1 times in Apr

The graph shoud show

- 2 cumulative contacts in Jan

- 3 cumulative contacts in Feb

- 3 cumulative contacts in Mar

- 4 cumulative contacts in Apr

See the attached example.

Looks like quite common situation.  I tried combinations of aggr and above functions, but with no luck.  Hopefully someone can give me a hand.

Best regards Pertti

[SunilChauhan]

if i am not wrong cumulative means it will include old data also

ex : if i have 2 customers in jan and 3 in feb then it will show 2 in jan and 5 in Feb using accumlation.

if i am wrong please correct me?

[Anonymous · Accepted solution]

Hi

Thanks for Your quick answer.  In this case I cumulate only new contacts.  If customer A and B contacts once or more often in Jan, the cumulative number of new customers is 2.  If customer A contacts in Feb, the cumulative number of new contacts in the time period is still 2.  No new customers.

The solution is found by my colleague.  I use expression: Sum(aggr(Count( distinct Customer), Customer)).