I have a case where my IDs for the month are with respect to a bucket.
Find attached data for reference.
I need to count as follows:
-- Bifurcation of Buckets:
a) New IDs moved in the month from previous
b) Same IDs in the same Bucket
For example:In January i have 4 ids in 1-30 bucket and from 4 how many have moved to 31-60 bucket in the month of february and from 61-90 how many have moved to March bucket.In same way if for the month of february 5 are in 1-30 bucket and from that how many have moved to march month in 31-60 buckets