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
1 reply
Subscribers
5 subscribers
Views
853 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
79201 - no subject - Hi,\n\nI have a task-based portal report
dylanf
over 10 years ago
Hi,
I have a task-based portal report, and on this report, among others, are columns for Task Assigned Time and Task Completion Time.
For Task Assignment Time, I am using the expression:
=if(or(task_status()=1,task_status()=2),task_assignment_time()-Lag(),task_assignment_time())
to calculate, since tasks that have been accepted use the acceptance time for the task_assignment_time() metric.
For Completion Time, I am using the task_completion_time() metric.
However, in some rare cases, the assignment time of a given task is earlier thant the completion time of the prior task, and I wanted to see if anyone might be able to tell me why this might be happening. In most cases, it works great, but I can't for the life of me understand why it's not working in all cases.
Thanks as always in advance....
OriginalPostID-79201
Discussion posts and replies are publicly visible
Parents
0
venkateshr
over 10 years ago
Dylan, can you elaborate on what you mean by "assignment time of a given task is earlier than the completion time of a prior task"? Looks like you have some logic here that tasks are sequential? That said, are you filtering your report to only have tasks that are completed, accepted or assigned?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
venkateshr
over 10 years ago
Dylan, can you elaborate on what you mean by "assignment time of a given task is earlier than the completion time of a prior task"? Looks like you have some logic here that tasks are sequential? That said, are you filtering your report to only have tasks that are completed, accepted or assigned?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data