Hi all. I have the following dataset: Account_no Date Status A123 15-Mar-16 Canceled A123 15-Mar-16 Declined A123 07-Feb-17 Declined A123 10-Apr-17 Finalized A134 20-Apr-16 Canceled A134 04-May-17 Canceled A134 05-Oct-17 Declined A134 06-Mar-18 Finalized I would like to calculate the amount of applications, per account_no , made 1 day before the application,1 week before the application and 1 year before the application ,also the amount of canceled applications 1 day before the application,1 week before the application and 1 year before the application . I hope this makes sense. Thank you for your help .
... View more