• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

(Average) Time in Status

checkner

New Member
Hello,

I have an applicant workflow and would like to measure how long a candidate has spent in which status (per job and average across all jobs). I want to visualize it in PowerBI. I have the following table:

Job Req IDApplication IDApplication StatusApplication Status CategoryCreated Date (Timestamp)Is Current StatusSkipped Status
300384123456Personal AssessmentASSESSMENT22.05.2023 06:21Skipped by user
300384123456Cultural fit assessmentASSESSMENT22.05.2023 06:21Skipped by user
300384123456Manager ReviewASSESSMENT22.05.2023 06:21Not Skipped
300384123456Rejected - Direct RejectedCLOSED22.05.2023 09:23YESNot Skipped
300384123456ScreeningSCREENING22.05.2023 06:21Skipped by user
300384123456DefaultAPPLIED19.05.2023 14:34Not Skipped
300384123456Recruiter InterviewSCREENING22.05.2023 06:21Skipped by user

If the status is "Skipped by user", the applicant was not in this status, if it is "not skipped", the applicant was in this status. For the case shown, I would want to know how long the applicant was in the status "Default" and "Manager Review". If "CLOSED", then I do not need any time.

I would be very grateful if anyone can help.

Kind regards
Christoph
 
Back
Top