Is there a text mode solution for filtering projects when the actual duration is greater than the planned duration? | Community
Skip to main content
Jared_Mauch
Jared_Mauch
Level 6
March 1, 2021
Solved

Is there a text mode solution for filtering projects when the actual duration is greater than the planned duration?

  • March 1, 2021
  • 1 reply
  • 1408 views

I'm trying to filter completed projects in a report when the actual duration is greater than the planned duration but I'm not having success in text mode. I've tried:

actualDuration=FIELD:duration

actualDuration_Mod=gt

actualDuration=FIELD:plannedDuration

actualDuration_Mod=gt

Applying either of those makes the report show no data, but it'll show data when either of those are not applied. Can someone tell me what I'm doing wrong and point me in the right direction? Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

Hi Jared, looking at the API Explorer (which is a treasure when doing text mode https://one.workfront.com/s/api-explorer) I'm not seeing actualDuration, duration, or plannedDuration as field that exist on a project object type.

I would try...

actualDurationMinutes=FIELD:durationMinutes

actualDurationMinutes_Mod=gt

See if that works for you :)

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
March 1, 2021

Hi Jared, looking at the API Explorer (which is a treasure when doing text mode https://one.workfront.com/s/api-explorer) I'm not seeing actualDuration, duration, or plannedDuration as field that exist on a project object type.

I would try...

actualDurationMinutes=FIELD:durationMinutes

actualDurationMinutes_Mod=gt

See if that works for you :)

    A
    andreadmw
    October 18, 2022

    Hi! this just helped me so thank you! I also wanted to ask a follow-up. If I wanted to refine further to show outliers. So lets say Projects where the actual duration was over the planned duration by 2 weeks or more.

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    July 12, 2023

    Hi there, were you able to figure this out? I'm trying to do the same thing, I want to only pull when the difference in durations was anything over 1 week into the report...

     

    Also want same thing in a different report for when planned vs actual hours is difference of X... @imgrund do you know what I could use for this?


    Hi Madalyn - 

     

    For your instance, I would do a calculated field on tasks that does the calculation of how many days difference you have, and then do the filter on that. 

     

    The calculation I tend to use is 

    IF(!ISBLANK({actualCompletionDate}),PROD(WORKMINUTESDIFF(CLEARTIME({actualCompletionDate}),CLEARTIME({plannedCompletionDate})),IF(CLEARTIME({actualCompletionDate}) < CLEARTIME({plannedCompletionDate}), -1, 1))/480,"")

    Not sure how your setup is for your instance, but this would require that all tasks have a custom form attached to them. 

     

    Then for your report, you will run a task report where the Duration Slippage (or whatever you called the calculated field) is greater than 5. That will then show you all the tasks overdue more than a week. 

    It is also nice to have this number on the form because then you can also do the average duration slippage by various components to help identify issues that might need to be addressed or templates that need to be updated. 😎

    Terms & ConditionsAccessibility statement

    Loading footer...