I have a form that I use for recruiting. It follows the applicant through various stages of the process. I want to display on a page report how many running days an applicant is in a current status. For example, let's say there are four levels of the Process: Intake, In Progress, Awaiting Interview, and Hired. I would like to count how many days each client is in each of these levels.
I have already made date stamp workflows to enter the date when a level status has changed. I have also already made a page to show how many current applicants are in each of these levels. I would like to add the average amount of days (Rounded to the nearest whole day) in a panel next to the total amount of clients at that level.
For example, there are 4 clients Awaiting Interview. Client#1 has been waiting 4 days, Client#2 has been waiting 4 days, Client#3 has been waiting 2 days, and Clinet#4 has been waiting 1 day.
What I would like to see is something like:
Applicants Awaiting Interview: 4
Average Days Awaiting Interview: 3