Calculate Duration of Each Stage

Thilina · 12-21-2021 12:30 AM

Hi all, I have a workflow that has a [Stage] column, I have a bot to capture each stage change and record this in another table, this table has the name of the stage and DateTime it was changed, I want to find a way to calculate how long the task was in a particular stage,

Eg:
row 1- [Stage] = “In Dev” , [Timestamp] = “12/21/2021 3:21:02”
row 2- [Stage] = “In QA” , [Timestamp] = “12/21/2021 5:21:02”
row 3- [Stage] = “Completed” , [Timestamp] = “12/21/2021 6:21:02”

So duration in Dev Stage would be 2 hours, in QA stage it would be 1 hour

is there a way to accomplish this,
Any help would be greatly appreciated, Thanks in advance

Marc_Dillon

Perhaps add a new column to the Table that records the duration since the previous record. Use LOOKUP( MAXROW() ... ) to get the timestamp of the previous record.

Thilina

Thanx @Marc_Dillon Will try this out

Thilina

Hi @Marc_Dillon I have tried to get this to work but I’m not quite sure how, could you please elaborate?
I read through the given docs but still a bit confused…

Thanks