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