Comparing Estimated LOE to actual hours by job role | Community
Skip to main content
K
KaitlynGr2
Level 2
August 30, 2023
Question

Comparing Estimated LOE to actual hours by job role

  • August 30, 2023
  • 1 reply
  • 903 views

Hello,

 

I am looking for a way to compare estimated LOE (custom form field) with the actual hours logged by each respective job role in order to let resources easily see what they estimated vs the actual amount of work they performed for the project. The problem is that my organization doesn't log hours under each individual task, but instead have one task (x department's hours) and log time under that task only for work that is being done on all project work tasks. So tracking the hours logged under project work tasks is not an option.

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

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
August 31, 2023

Hi there, I suggest an hour report for this.

In your report, you can have a column for hour owner ID (which you can change to role name in the column text mode), hours (actual hours), owner (person's name), source (task or where hour is logged to), and the LOE custom field - of course I recommend having LOE and Hours columns side by side for easy comparison.

In your report filters, pull in the specific task(s) you want to pull hours on that also have this LOE field.

You can group by owner role or by task name, up to you!

If this helped you, please mark correct to help others : )

If this helped you, please mark correct to help others : )
K
KaitlynGr2Author
Level 2
September 5, 2023

Hi Madalyn 🙂

I am having a bit of trouble getting this to work because we have a custom form field for LOE for each respective department. Ex. Accounting LOE, IT LOE, etc. I want the report to say this person, who is in Accounting worked 50 hours and the Accounting LOE was 30. How do I get the report to match the job role to the correct LOE custom form field? 

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
September 5, 2023

Hi there, if you have multiple LOE fields, you can bring them each in as separate columns, then merge the columns so it's just showing the value of whichever field is present. So a row of user A's time would show just user A's LOE field. 

More on sharing columns here: https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/custom-view-samples/view-merge-columns.html?lang=en 

If this helped you, please mark correct to help others : )
Terms & ConditionsAccessibility statement

Loading footer...