Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

Task Report Actual Completion date VS Planned Completion Date

Avatar

Level 1

Hello,

 

I'm trying to build a basic task report that will pull all tasks that were completed after the planned completion date. Essentially actualCompletionDate > plannedCompletionDate. However, I want to exclude the time from the calculation. I tried playing with the CLEARTIME, but I was unsuccessful. Any help would be appreciated!

 

Thanks

3 Replies

Avatar

Community Advisor

we had a similar need a while back and if I recall correctly, you can't really do this in a report filter. We ended up making a calculated field that would just ping "late" based on our specific needs at the time, and then ran reports on everything that was "late".

 

(our needs at the time was we only wanted to look at stuff that was more than 2 days late, so the calculated field was basically actual > planned+2... might have had a cleartime in there as well)

Avatar

Level 2

This article helped me build a similar task report. https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/fil...

 

  1. Go to a list of tasks.

  2. From the Filter drop-down menu, select New Filter.

  3. Click Add Filter Rule and add Actual Completion Date >Greater Than  > Select a date.

    TIP
    Choose the filter modifier you want to use for the selected field, if available.
  4. Click Switch to Text Mode.

  5. In the Set Filter Rules for your Report area, add the following code:

    actualCompletionDate=FIELD:plannedCompletionDate<br>actualCompletionDate_Mod=gt
    Copy
    Toggle Text Wrapping
  6. Click Done, then Save Filter.

Avatar

Level 1

If I could just cleartime from the below I'd be in business!


actualCompletionDate=FIELD:plannedCompletionDate
actualCompletionDate_Mod=gt