Oracle Transactional Business Intelligence

Products Banner

Phone screens completed

21
Views
1
Comments

Summary

Looking to add the number of phone screens completed to report

Content

I have a current report that I am needing to add the number of phone screens that have been completed.  I have found the historical steps and status I am looking for but need help configuring report to count/total these numbers for me.  Need some guidance.

Thanks,
Paul

Comments

  • Paul,

    There are two ways to approach this, see examples below (where 'step' = your step and 'status' = your status):

    FILTER("Candidate Counts"."# Submissions" USING (("Submission CSW Status - Historical"."Historical Step Name" = 'step') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'status')))

    or

    COUNT(DISTINCT CASE WHEN ("Submission CSW Status - Historical"."Historical Step Name" = 'step') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'status') THEN "Submission General Info"."Submission Identifier" END)

    Please let me know if you have any questions.  Thanks!