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

Is it possible to show # of submissions only for previous day?

Accepted answer
34
Views
6
Comments
edited Dec 13, 2022 7:11AM in Taleo Enterprise 6 comments

Summary:

Looking to display number of submissions submitted on previous day for each requisition

Content (required):

Hi all--we've been asked to try and provide a report that shows the total number of submissions on a requisition submitted the previous calendar day (the team want to see the amount of change on a report they receive daily via an agent). The existing report is attached.

Is this something that's possible with SQL and the existing Candidate Facts (e.g. "Candidate Counts"."# Submissions Complete"), or is anyone aware of a better approach to this? We had thought it might be possible via a CASE statement but couldn't make this work.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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