Oracle Transactional Business Intelligence

Phone screens completed
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!