Random Group Assignments of 4-5 students based on 2-3 criterias

[triplej8a]

Hi, 

I wanted to create a flow that takes a student roster and randomly assigns them to a group (group max is 4-5). Ideally, the groups must have students from different locations and concentrations so that each group is diverse. I've attached a sample document and removed the names for confidentiality.

It'd be a bonus if the groups won't repeat every time I run the flow. I recently started learning designer and didn't know where to start. 

Thanks in advance for any input. 

[mceleavey]

Hi @triplej8a ,

This was an interesting one.

In the end, I tried a fairly simply approach and I'm happy with the results. I used the combination of the three cohorts to create a compound key. I then sorted the records by the key, essentially grouping the like for like combinations in order. I then used a multi row formula to create a counting ID field up to the number of the total records divided by 5 (5 per group).

This meant the most similar combinations will be given different numbers.

We then group by numbers.

I've attached the workflow, let me know if that's close to what you're looking for.

M.

[triplej8a]

Thank you for the workflow! I think this is a great start. Is there a way to add randomization to it so that every time I run the flow different groups are in the output? 

Thanks again! 

[sravanbyreddy]

Hi guys, mceleavey - MACRO 

I have struck with the problem where the data is 

Input:
1: First input contains a list of transactions which include the [Client_Number], [Month], & [Finance Amount]. Customers only appear on months that they have made a purchase. 
2: Second input contains [Client_Numers] and [Client_Names]. 

Output:
1: include current customers in the data set with:
2: add "finance amount" of 0 for the missing months  
3: include Client Names 
4: present them a table with the different months as column header.

here I am trying this a long time but i couldn't figure that out, hope you guys help me this problem. I am facing difficulty as I am newly learning about this Designer/Tool.

Hope you guys help me out,

Thanks a lot in advance. and appreciate any kind of suggestion or input for learning.

Thanks & Regards,

Sravan