Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Round-Robin Assignment formula

Highlighted
8 - Asteroid

I have a workflow that generates tickets for investigation by QC techs, this generates daily, seven days a week. It contains a few Null() fields that will be worked on by the techs. 

wmcclure_0-1585695509815.png

I've used the formula: DateTimeFormat([DateField],"%u") will give you the day of the week where Monday = 1 and Sunday = 7

To find the day of the week that the report generated. 

 

I have a table that has the Techs names and the weekday they are scheduled to work:

Annotation 2020-03-31 190356.jpg

I need to have it find the day of the week and then assign techs into the Analyst column until filled.

 

Any suggestions on how to accomplish this? 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @wmcclure ,

 

I've create an example based on 4 analyst but you can configure the number as you desire.

fmvizcaino_0-1585696982868.png

 

 

Take a look and let me know if this works for you.

Best,

Fernando Vizcaino

 

Highlighted
8 - Asteroid

Fernando this looks very very good. It was nearly perfect! I had to account for varying number of techs on each day. Easy enough when you gave such a good formula to start!

 

Thank you

Highlighted
5 - Atom

How do you get it to change based on the number of analyst being different each time its run?

Labels