Thanks for tagging me Katherine,
If it was warranted, I see an angle here for our UberCalc solution (or Fusion); but short of that, it is both Some Assembly Required, and some Care And Feeding.
Unlike SQL, there is no concept of TOP within Workfront. Furthermore, in order to filter down to only certain (e.g. top 5) Projects greater than some total actual hours, Workfront requires the criteria to either be persisted in the database (e.g. a custom numeric field at the Portfolio or Company level) or hard coded in the filter of the report.
Accordingly, Manuel, I'd suggest you:
- Create a Project report that returns all of the reports of interest, sorted descending by Actual Hours
- Note the Actual Hours on the 5th Project ("The Number")
- Adjust the filter on that report to include only Projects with Actual Hours >= The Number
- Since Actual Hours typically go "up", monitor the report, so as the 6th (7th, etc.) gradually pass The Number, repeat the above steps to keep the report at the Top 5 Projects
Regard,
Doug
P.S. The UberCalc angle I mentioned to automatically calculate and set The Number (e.g. daily) so you needn't worry about the last step
P.P.S. (CHEAT CODE) if you place the report on a dashboard and size it "just right", only the first 5 rows will be visible, which might be sufficient for the casual observer
