Forum Discussion
ChayceDuncan2
Qrew Cadet
I've done something exactly like that in a similar situation and that solution is the one I employed. One thing to consider is that you probably want to re-sequence each day to reset the counts. Basically if Person 1 is just faster - and they do 10 more than person 2 each day - within a couple of days Person 2 is going to be pretty far behind.
An easy solution is to have a daily 'reset' almost - where you assign a number from 1 to n that lets you reset the assignments. So:
[Feedback Type]="Complaint" and
Mod(if( [Resequence #] > 0, [Resequence #],[Record ID#]),ToNumber([Number of people]) ) = 0,
if you've assigned a new Resequence # - use that number for your Mod calc, otherwise RID
ToUser("person1@companyemail.com")
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
An easy solution is to have a daily 'reset' almost - where you assign a number from 1 to n that lets you reset the assignments. So:
[Feedback Type]="Complaint" and
Mod(if( [Resequence #] > 0, [Resequence #],[Record ID#]),ToNumber([Number of people]) ) = 0,
if you've assigned a new Resequence # - use that number for your Mod calc, otherwise RID
ToUser("person1@companyemail.com")
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
EvanBohan
5 years agoQrew Cadet
Okay but if I only get one complaint every few days, wouldn't it always assign to the first person on the list?