Skip to main content
JonGe1
Level 2
Apr 5, 2023 1:07 PM UTC
Solved

Reporting on task status change to "complete - pending issues"

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Doug_Den_Hoed_AtAppStore
Doug_Den_Hoed_AtAppStoreAccepted solution
Community Advisor
Apr 5, 2023 3:17 PM UTC

 

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

Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
View in thread

3 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
Apr 5, 2023 3:17 PM UTC

 

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

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
JonGe1Author
Level 2
Apr 12, 2023 2:27 PM UTC

Hey Doug, 

 

That could work potentially, but out of curiosity, what is your other idea? I'd love to hear it!

 

Jon

Translate
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
Apr 12, 2023 4:38 PM UTC

 

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

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
Terms & ConditionsAccessibility statement

Loading footer...