Average Time From One Status To The Next

Content

I am trying to calculate the average time in days it takes our recruiters to move candidates from one status to the next by Requisition. I am able to get the calculation to work fine if I include the candidates in the report but this is a summary report of all requisitions so we do not want the candidates listed. Once I remove the candidate identifier/name from the analysis, the calculation no longer works...it is returning the max value from all of the candidates who have been moved to the new status (e.g. candidate A takes 10 days to move