Phone screens completed

User_HZJPP

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

Michael Scaduto

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!