Custom Report - Random sampling of 5% Incidents created in a specified time period.
We have four customer quality assurance analysts that evaluate 5% of incidents created for a period of one month. So far, I have a report that displays the number of incidents created, how many to evaluate to meet 5% and how many four analysts will each need to evaluate.
incidents.created between -1 Months Rounded to 0 Months Rounded
Random (Hidden column):
5% of Incidents:
Divided by 4 Analysts:
I would like a drill down to display and view only a randomized 5% vs viewing all incidents created when drilling down on a randomized 5% of incidents created.