Creating a Bucket
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
could you please help me create the 3 buckets (column E of the attached).
Thanks very much in advance,
Gaetano
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 😀👍
