I have a dataset as below where we want to follow snapshot based approach( that is as of 3 snapshot dates in the dataset, what is the performance)
|Cust ID||Reporting Date||Snapshot date||Number of debits||Number of credits|
Here there is 12 month(June’21-May’22) reporting data & 3 snapshots month merged into the data( Sep, oct & nov’21). For multiple variables I need to find 3 month growth rates as of every snapshot(standing in snapshot date sep’21 — what is the 3 month growth rate of cust id), similarly for october & november snapshot.
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.