Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Custom Report - Random sampling of 5% Incidents created in a specified time period. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Report - Random sampling of 5% Incidents created in a specified time period.

Question
10
Views
0
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!