Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
4 subscribers
Views
2061 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
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!
OriginalPostID-152128
OriginalPostID-152128
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