Best Practices for Time to Complete Application
SummaryOBI Reporting: Time To Complete Application for Retail Hourly Applications
We are looking for best practices on reporting on time to complete application.
Currently our formula is the time (in minutes) between Submission Created Date and Submission Completed Date with a date range prompt on Submission Created Date. We are searching for the average time to complete (in minutes) over 12 months, however, we are running into instances where applicants start an application in one month and do not fully submit until months later, which causes our time to complete application to be longer than we anticipated.
Formula for Time to Complete: (TIMESTAMPDIFF(SQL_TSI_MINUTE, "Submission Dates"."Submission Created Date", "Submission Dates"."Submission Completed Date"))