I am trying to build a report that can show if a task was early, late or on-time by checking when the task was marked complete, but still pending issues, rather than just complete.
Anyone have any success doing something like this before?
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @JonGe1,
Statistically speaking (suspecting once a Task is in such a state, it is no longer "touched") you might get away with assuming that the Last Update Date is the one to use.
If that's not a good assumption, let me know; I have another idea, too (but it's a bit more complicated).
Regards,
Doug
Views
Replies
Total Likes
Hi @JonGe1,
Statistically speaking (suspecting once a Task is in such a state, it is no longer "touched") you might get away with assuming that the Last Update Date is the one to use.
If that's not a good assumption, let me know; I have another idea, too (but it's a bit more complicated).
Regards,
Doug
Views
Replies
Total Likes
Hey Doug,
That could work potentially, but out of curiosity, what is your other idea? I'd love to hear it!
Jon
Views
Replies
Total Likes
Certainly @JonGe1,
My other idea would be to adapt this Targeted Auditing technique to capture an optional calculated date parameter to track (if and when it happens) the date(s) "a task was marked complete, but still pending issues, rather than just complete."
Regards,
Doug
Views
Replies
Total Likes
Views
Likes
Replies