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
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.
Thanx @Marc_Dillon Will try this out
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
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |