Forum Discussion
Group entries based on defined parameters
still not clear about the logic of data selecting.
why we select user 1, 10,15, 16 and 19 for company 1?
Sorry for the confusion.
I set the example randomly but the logic should check the first 5 choices of a user when assigning them to a company group. For instance, in Company 1, if we were grouping each to company to have 10 users, then for all 10 users to be added in that company group would have selected Company 1 as their top 5 choice. Where this is not possible, for instance, Company one is very popular and almost all users select it in their top 5, then we consider choices 6 to 26 for each individual user and group them that way.
Once a company has the maximum selection of the number of required people, while considering each group has at least 1 people with Consultancy experience, and a mix between males and females, and nationalities, they we continue grouping the other users in the next groups.
As such, if all users who set Company 1 as their first choice were female and or from the same nationalities, and or all or none had Consultancy experience, the algorithm should select other users in the pool of responses, whether or not they selected Company 1 as their top 5, provided they can introduce a mix of people in the group. Where we must have at least 1 Consultant, some males and females, and from different nationalities.
Does that help?
still not clear about the logic. it looks like that the result was randomly to some extent? All 43 users have the number for company 1, so I still don't under why you pick up those 5 users as the result.