Creating Aging Buckets with a range in each

[rkeenan125]

Hi all, hope everyone is doing well.

I am trying to create aging bucket columns. For example:

My Sample input:

Customer	Document Number	Age
Company 1	A	5
Company 2	B	10
Company 3	C	49
Company 4	D	456
Company 5	E	390
Company 6	F	76

My goal output:

Customer	Document Number	Age 0-30	Age 31-365	Age 365+
Company 1	A	5	0	0
Company 2	B	10	0	0
Company 3	C	0	49	0
Company 4	D	0	0	450
Company 5	E	0	0	390
Company 6	F	0	76	0

Any help is appreciated!

[Bren_Spill · Accepted solution]

Hi @rkeenan125 - see attached workflow

[rkeenan125]

Thank you for this!
Would this work if customer showed up multiple times due to have multiple documents and each document has a different age?

[apathetichell]

if (and only if) you are looking at equal interval or equal records - you can use the delightly pointless multi-field binning tool. @Bren_Spill 's workflow would have no issues with duplicate lines (assuming you wanted them each counted).

[Bren_Spill]

Yes - as long as the document numbers are different for that customer then it'll work

[rkeenan125]

Thank you both for the help!