Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Evenly Assigning workload

Highlighted
7 - Meteor

I am trying to find away to evenly assign workload throughout a team. Each person is assigned a store per day. However, I need them to be assigned the same amount of store or close to the same per day. Which store assigned does not matter but the amount of workload does. 

Capture3.PNG

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
This looks like a schoolyard pick. You have three captains and you need to assign the stores to the captains. Start at the top and assign 1 to 3 to each store and then relate them to the names.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
7 - Meteor

Thanks but I am talking about a scope of thousands of stores and 5 days a week for 52 weeks. I was overly simplifying it when I made the example. The example is how the data is provided to me. I need to find away to assign them the same amount a day. 

Highlighted
16 - Nebula
16 - Nebula

If you are wanting to evenly spread the total of Store then I suggest an iterative macro assigning the highest remaining store to the lowest total for employee. I have attached a sample doing this.

 

As @MarqueeCrew if you want to assign equal number of records then his approach should work well.

 

 

7 - Meteor

Thank you both for your time with this. I am unable to download your workflow because I am unable to upload the latest version of Alteryx. I am using 11.7.4.43055

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
How about just using the tile tool with equal records?
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
16 - Nebula
16 - Nebula

Interesting case - I tried both @MarqueeCrew and found the greedy iterative felt like a better allocation engine.

 

NameGreedyTile
Amanda123111
CJ110127
Cathy10766
John111147

 

@TJ1 I have attached a new sample adjusted down to 11.7

 

 

Labels