jeudi 30 avril 2020

Random sampling and assigning values to each sample set in Tableau

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