Forum Discussion
Randomizer allocation of Data
Updated pbix uploaded to https://1drv.ms/u/s!Akd5y6ruJhvhuWhgv10sl6bguDbP?e=z99tuN
Hi Vijay,
Thanks for your swift reply, when checked i see only 3 Auditors has been assigned to the Handlers every day. where in i have 3 Auditors for 1st May, 6 Auditors for 2nd May and 4 Auditors for 3rd May.
Is it something to do with Inserted Modulo in Handlers data?
Regards,
Kiran
Yes, I had forgotten to replace 3 with List.Count(ListOfAuditors).
The file has been uploaded to https://1drv.ms/u/s!Akd5y6ruJhvhuWXwAK0Dh1u8P3W3?e=vJ6LJM
Hi Vijay,
That was really helpful thank you so much.
Now i wanted to assign available Auditors to Handlers with the combination of Date and Product
Example the avilable Auditors for 1sth May with Product "MT Motor" has to be assigned to 1st May Handler with "MT Motor"
the Logic of assigning Auditors remain same but it has to be a combination of Date and Product.
Sample Data for your reference:
Date Handlers Product 5/1/2022 Ebrahim Abrahams MT Motor 5/1/2022 Kayla Adamson MT Motor 5/1/2022 Zeenat Ally MT Motor 5/2/2022 Thimna Rapiya MT Motor 5/2/2022 Fadwa Rasdien MT Motor 5/1/2022 Thomas Faragher Affinity Home 5/1/2022 Rob Hall Affinity Home 5/2/2022 Angela Holman Affinity Home 5/2/2022 Saffron Jordan Affinity Home 5/2/2022 Keith Lakeman Affinity Home 5/3/2022 Vera Potter Affinity Home 5/3/2022 Rachel Robinson Affinity Home 5/1/2022 Leigha Powley JL Home 5/1/2022 Mohammed Qasam JL Home 5/1/2022 Jill Smith JL Home 5/2/2022 Cynthia Steadman JL Home 5/2/2022 Umarah Tariq JL Home 5/2/2022 Isabelle Whitehead JL Home 5/3/2022 Mark Browell JL Home 5/3/2022 Enola Clish JL Home Date Auditors Product 5/1/2022 Pooja Raut MT Motor 5/1/2022 Shanthi Vijayaraghavan Affinity Home 5/1/2022 Vasudev Murthy MT Motor 5/1/2022 Shivanand Kadakol JL Home 5/1/2022 Bindushree Panduranga JL Home 5/1/2022 Daphne D'Silva Affinity Home 5/2/2022 Meghna Gaurishankar Gaud JL Home 5/2/2022 Nanditha Panduranga MT Motor 5/2/2022 Naveen Kumar Affinity Home 5/2/2022 Nikitha Manjunath JL Home 5/2/2022 Deepika Anish Affinity Home 5/3/2022 Keerthi Kumar MT Motor 5/3/2022 Kushmanjali Ramachandra Affinity Home 5/3/2022 Maria Harry MT Motor 5/3/2022 Meena Kumari JL Home 5/3/2022 Touseefa Naaz JL Home 5/3/2022 Yashas Raaj Affinity Home Updated pbix uploaded to https://1drv.ms/u/s!Akd5y6ruJhvhuWhgv10sl6bguDbP?e=z99tuN