I have a tableau dashboard that provides tasks for auditing based on the date filter we choose. The total number of tasks that we may get for a given date would be around 700. We have 5 team members to do a total of 120 tasks per day (5*25 tasks).
I am trying to assign tasks to the 5 members by doing a random sample of the tasks and then assign 25 tasks each to 5 members.
Trying to implement something similar to rownumber(over() order by random) as proxy select case when proxy >=25 then 'set 1' when proxy >=50 then 'set 2' and so on.
Is that possible in Tableau
Aucun commentaire:
Enregistrer un commentaire