Custom Report - Random sampling of 5% Incidents created in a specified time period.
Content
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.
For Example:
Filters:
incidents.created between -1 Months Rounded to 0 Months Rounded
Columns:
Random (Hidden column):
rand()
Incidents created:
count(*)
5% of Incidents:
count(incidents.created)/20
Divided by 4 Analysts:
round(count(*)/20/4,0)
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.
Tagged:
0