Creating multiple overlapping time buckets for data

JanLo

Hi all, I'm new to the Alteryx world and need some expert help.

Similar to a question asked back in 2020 (the solution was very helpful) but I have an added requirement

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-Aging-Bucket-Based-On-Days/td-p/537846

I need to assign time buckets to similar data, but the time buckets overlap.

Eg. Time buckets are in days - 1-30, 2-31, 3-33, 4-34 etc.  So if the item happened on day 3, it would be assigned to 3 of the time buckets

1-30, 2-31& 3-33

Following the solution from the previous post I've managed to assign one time bucket to a row.  But how would I be able to assign all the time buckets applicable?

Any help is greatly appreciated

My time buckets go up 1000 days

DataNath

Very interesting challenge @JanLo! I'm not sure if this is exactly what you're after but should hopefully get the ball rolling nicely - let me know if the requirement is drastically different and can revisit this.

Assign time buckets.yxmd