Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Count of submissions from the past 24 hours
Content
I am trying to measure the number of candidates that apply within the past 24 hours. I have tried both variables but I am not getting the complete list. I am not getting candidates that applied today, only candidates that applied the day before. I am looking for all candidates within the past 24 hours (which includes today).
Can someone take a look at the variables I created and let me know if I am on the right path?
Any feedback would be greatly appreciated.
Candidates within the past 24 hours
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Submission Dates"."Submission Completed Date", CURRENT_TIMESTAMP) > 0 AND TIMESTAMPDIFF(SQL_TSI_HOUR,"Submission Dates"."Submission Completed Date", CURRENT_TIMESTAMP) < 24.01 THEN '1 day ago' END
Tagged:
- Analyses
- Business Objects
- Custom Formulas
- Dashboards
- Embedded Reporting BIP
- OBI Answers
- Prompts
- Report Sharing Center
- SQL
- Taleo Enterprise
- Data Models
- Report Output
- Reports
- OTBI
- Report Delivery
- Report Layouts
- Customizing Reports
- Customizing Layout
- Reporting and Analytics
- Talent Acquisition
- High Volume Hiring
- Recruiting
- OBIEE Answers
- Candidate
- Candidates
1