Hello, I am on Appian version 7.8. I have a tempo report i

tapans over 9 years ago

Hello,

I am on Appian version 7.8.

I have a tempo report in which one grid column is fetching task acceptance time from one portal report. In the portal report, I am using this condition to get the acceptance time : =if( task_status() = 0, null, task_assignment_time() + Lag())

My scenario in which I am getting wrong acceptance time :
- I have accepted one task at 4:00 PM
- As per the business need, I have reassigned that task to team mate Tom at 4:15 PM
- Tom has accepted the task at 4:30 PM

So in the tempo report, acceptance time should display 4:30 PM but in place of that it is displaying 5 PM (adding 30 minutes more from first acceptance). getTaskAcceptedTimestamp function is not working in portal.

Could any one please suggest me any alternative I can apply in portal to get accurate task acceptance time?
Please let me know if any additional detail is requited.

Thanks!

Discussion posts and replies are publicly visible

Parents

0 davidm415 over 9 years ago

Lag() seems to take the very first assignment time for a given task and in your formula adds it to the most recently assigned time for that task. This seems to work fine when a task is not reassigned. However it can create some strange scenarios when a task is reassigned. Taking a task originally assigned 10 days ago and reassigning it to another user would give you a task acceptance time of 10 days into the future. Depending on your use case, the process start time from the task metrics list might be more accurate.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 davidm415 over 9 years ago

Lag() seems to take the very first assignment time for a given task and in your formula adds it to the most recently assigned time for that task. This seems to work fine when a task is not reassigned. However it can create some strange scenarios when a task is reassigned. Taking a task originally assigned 10 days ago and reassigning it to another user would give you a task acceptance time of 10 days into the future. Depending on your use case, the process start time from the task metrics list might be more accurate.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data