Revisit calculation

[ajsjoshua]

Dear all,

I want to calculate the count of customers who revisited again.In this case customerid 1 purchased 3 products on same date but on different time i dont want to calculate revisits in same day.Revisit should be based on different date.

My output should be

count of revisit is 2.(only customerid 1 and 2 revisited again)

PFA for app

customerid	Date	Product	revenue
1	1/1/2017	dfg	4000
1	1/1/2017	ass	3000
1	1/1/2017	rer	1000
2	23/1/2017	wes	6000
2	25/1/2017	tre	2000
3	4/2/2017	ewe	5000
4	5/2/2017	asa	7000
1	7/2/2017	adas	10000

[sunny_talwar]

What is the expected output?

[ajsjoshua]

Hi Sunny,

In this case out of 9 customer visits there is 3 revisits (customerid 1 once and customerid 2 twice)

so (3/9)*100=33.33%

[sunny_talwar]

This

Num((Count({<customerid *= {"*"}>}DISTINCT customerid&Date) - Count(DISTINCT customerid))/Count(customerid), '##.##%')

[ajsjoshua]

Dear Sunny,

Thank You very much.

Regards,

Joshua.