Put my UBD months in buckets of 3 months

[rpinxt]

I have a calculated column that gives my UBD in months (days divided by (365/12) )

Set it that everything below 1 gets 0 and everything above 24 gets 25 (wanted >24 but think to make groups bins that is not convenient).

So looks like this :

Now I want to used this values to get the Aging Bucket from this list :

So 1,xxx goes into "1-3", 10,32 goes into "10-12" etc.

And 0 goes to "0 Expired" and 25 is ">24"

What would be best practise for this?

[rpinxt]

Ah thanks @Ritaf1983 this indeed helped me a lot.

Unfortunately you need to do it in Query editor and I cannot see my calculated column there.

So I deleted my calculated column and made that UBD Mth colunn in the editor first.

Then with the conditional column I was able to make my Aging Bucket "easily".

Just a small reminder that you need to be carefull what you type :

So 13-15 was no problem but if you type 10-12 it will want to convert it to a date.

Not direct but when you finish your column so suddenly you see dates and think....🤔

Then when I went back in I saw the conversion to dates.

Simple fix is for those you type '10-12 so with an apostrophe.

[Ritaf1983 · Accepted solution]

Hi @rpinxt 
Please refer to the linked video about bins:
https://www.youtube.com/watch?v=PjHgi7X3_Bw&t=2s

If my answer was helpful please give me a Kudos and accept as a Solution.