Forum Discussion

checkner's avatar
checkner
Frequent Visitor
2 years ago
Solved

Average time spent in status

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 have the following table: Job Req ID ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi checkner ,

    It seems that you are trying to create a measure not a calculated column. If you want to apply the formula which provided by rubayatyasmin , you need to create a calculated column instead of measure. 

    Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi checkner ,

    It seems that you are trying to create a measure not a calculated column. If you want to apply the formula which provided by rubayatyasmin , you need to create a calculated column instead of measure. 

    Best Regards

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    2 years ago

    checkner sorry I had lost this thread. You can create an Calculated Column as suggested by Anonymous . 

     

    Thanks