Count of Potential and Non-Potential Customers

sidhiq91 — Wed, 06 Dec 2023 10:02:06 GMT

Hello Guys,

Could anyone help me with the below scenario? I wanted to count the number of Potential and Non-Potential Customers date-wise.

Definitions for Potential and Non-Potential are as follows:

Potential: Potential customers are the ones who have made a purchase.

Non-Potential: Non-Potential Customers are the ones who are visiting the shop but have never made the purchase.

Note: If customers just visit the store after the first purchase and does not make any purchase is still considered Potential Customer.

I have attached the screenshot of the sample data for your reference.

Please do help.

Output Table
Date	No of Potential Customers	No of Non-Potential Customers
01-Dec-23	0	1
02-Dec-23	0	1
03-Dec-23	1	0
04-Dec-23	2	0
05-Dec-23	1	1

Re: Count of Potential and Non-Potential Customers

sidhiq91 — Wed, 06 Dec 2023 17:21:50 GMT

Hello Everyone,

Can I get some help on the above request?

Regards,

Sidhiq