I've got this dilemma... There is a project plan created for managing the process itself for processing hundreds/thousands of assets from Step 1 to Step N. After those steps are complete, we need to have a reporting mechanism to inform the team that X number of assets have been processed and completed. Have you had a similar case in your company? Please share your approach.
For example, there are 1000 widgets. For widget 1-100, we execute Step 1 thru Step N and complete the processing (creating, updating, uploading, approving, deleting, etc.) of those 100 widgets. Then, we need to track that 100 out of 1000 widgets have been completed, e.g. 10%. A report on a dashboard need to display that 10%. The challenge here is...instead of using an excel file with 1000 lines, how can we do this tracking in Workfront? Of course, we can layout the process from Step 1 thru Step N in Workfront as a series of tasks. However, it doesn't make sense to do it 1000 times.
Any idea on how to approach this asset completion tracking challenge? Thank you.
Topics help categorize Community content and increase your ability to discover relevant content.
interesting one Pavlin,
If it suits your requirements, I’d suggest several components:
This approach allows appropriate granularity to track each Batch independently and accurately, ensures the Batch Units are only “counted” once all child Step 1-N tasks are complete, thereby presenting accurate Batch % at both the Project and Task levels, minimizes the repetition of the Step 1-N tasks per project, but still allows for extra steps / issues, Batch Unit adjustments, etc.
And (personal preference) it also lends itself to charting and/or fancier logic to illustrate work in progress, or % complete of Batch math (eg 100 units all done step 4 of 5 could be counted as 100*80% complete = “80 units”...in theory).
Thanks for the puzzle: keep me posted on what you end up getting going!
Hi Doug, Thank you for the idea. I can definitely use it in my case. Ultimately, my real scenario is much more complicated but your solution can be used as a foundation of calculating sub-total and total amount(s) as we move along through the project. Thank you.