Returning Customers Each Month for 12 months

[PurplePills555]

Hi All,

I have a data table like this in my script

Customer ID Date

100 2/11/19
100 15/12/18
150 10/5/19
150 15/4/19
200 1/6/19
250 8/9/19
300 1/10/19
350 2/3/19
350 2/4/19

I want to work out on a line chart the % of customers in that month that were a previous customer within 12 months

So for example in Oct 19 if I had 2 customers but 1 customer also bought something in July then 50% would be returning in Oct

Thanks

[Brett_Bleess]

There are quite a few posts along these lines, did you search Community by chance?  Here is one of them, not exactly what you are trying to do but very similar, and there were quite a few others, so I would suggest searching as well and checking out the other posts too.  I simply searched on Returning Customers I believe...

https://community.qlik.com/t5/New-to-Qlik-Sense/Count-returning-Customers-with-set-analysis/m-p/1630...

Regards,
Brett