Aggregate Counts for Step Status and Historical Step Status Detail Not Working
Content
I am trying to produce 2 different filters to count 2 different scenerios.
Formula 1
count (distinct case when "Submission CSW Status - Historical"."Historical Step/Status Details" LIKE 'Candidate was hired for requisition%' AND "Submission CSW Status - Historical"."Historical Step Name" IN ('Pre-Offer Check','Offer')
AND "Submission CSW Status - Historical"."Historical Status Name" IN ('Rejected','Candidate Withdrawn') then "Submission General Info"."Submission Identifier" end )
Formula 2
count (distinct case when "Submission CSW Status - Historical"."Historical Step/Status Details" NOT LIKE 'Candidate was hired for requisition%' AND "Submission CSW Status - Historical"."Historical Step Name" IN ('Pre-Offer Check','Offer')
Tagged:
0