Hi guys, I'm new to alteryx and I'm facing difficulties in trying to allocate my data evenly. I have a set of data that I have to split in 2 rounds. In the 1st round, I'll have to filter out "apple" and split it evenly among Amy and Andy. The 2nd round requires me the filter out everything but "apple" and split it evenly to Amy, Andy, Rachel, Ahmad and Eve. However, I have to take it into consideration that Amy and Andy have already the "apple" data on hand, hence they should not be overloaded. Everyone should have equal number of data at the end of the day. I have attached a sample data, please help me!!!! Thank you 🙂
Solved! Go to Solution.
It works! Thank you so much 😊
User | Count |
---|---|
63 | |
32 | |
28 | |
24 | |
23 |