Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Phone screens completed

21
Views
1
Comments
User_HZJPP
User_HZJPP Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Tagged:

Comments

  • Michael Scaduto
    Michael Scaduto Rank 3 - Community Apprentice

    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!