We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Aged Reqs

Received Response
36
Views
2
Comments
edited Feb 10, 2017 2:06PM in Reporting and Analytics Taleo Enterprise 2 comments

Content

Plan is to count the no of aged reqs over 40days and then remove any req that has the following submision statuses Hire/Accepted,Awaiting....

I did this but it is still including those submissions. How can I do this?

FILTER(count(cast(case when (CASE WHEN DAYOFWEEK("Requisition First Sourcing Date"."Req. First Sourcing Date") > DAYOFWEEK(NOW()) THEN CASE WHEN DAYOFWEEK("Requisition First Sourcing Date"."Req. First Sourcing Date") = 7 THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2)-1 ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2)-2 END ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2) END-("Requisition Process Time"."Req. Total Days On Hold")*0.7143) > 39 then '1' end as integer)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!