Creating a Bucket

[Gaetano_B]

Hello,

could you please help me create the 3 buckets (column E of the attached).

Thanks very much in advance,

Gaetano

[CharlieS]

Hi @Gaetano_B 

I'm sure there's something we can figure out, but could you help us understand the logic you'd like used to assign those bucket values. The "to bucket or not to bucket" is in the Excel, but why are the breaks at 7 nad 30?? This will help the Community guide how to replicate those methods within Designer. 

The Tile tool might be one place to start: 

https://help.alteryx.com/current/designer/tile-tool 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Tile/ta-p/30235 

I've attached what a general bucket workflow might look like.Obviously we can update that container once we finalize a bucketing method. 

- Assign a Record ID

- Filter based on the rules you provided.

- Assign buckets

- Union those records back together

- Re-sort by Record ID and move on.

EDIT: Here's the filter expression I used for bucket assignment:

!isnull([Colt Overall Comment Created On])
AND
!Contains([Current Status],'0')
AND
!Contains([Current Status],'2')
AND
!Contains([Current Status],'3')
AND
!Contains([Current Status],'10')

[atcodedog05]

Hi @Gaetano_B 

As per the explanation i was able to create till here.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍