Skip to main content
Solved

Reported Time Per Day Reporting


CoryJ
Silver Active Participant
Forum|alt.badge.img+1
  • Silver Active Participant

We have a department-wide project with multiple resources each assigned their own task under 1 milestone.

 

The project spans several months.

 

Each resource records their time on their timesheet whenever they work on the task. At this stage, a lot of the work is filler work. Staff works on this project whenever time allows.

 

I’ve been asked to create a monthly report to see each resources’ weekly timesheet activity.

 

Example:

June

Resource 1 (1.75 Hrs)

  • 6/04: .25 hrs
  • 6/05: .5 hrs
  • 6/18: 1 hr

 

Resource 2 (9 hrs)

  • 6/11: 3 hrs
  • 6/21: 5 hrs
  • 6/25: 1 hr

 

I cannot edit any out of the box Time Tracking reports, and I’m struggling to create it myself. Any help and suggestions would be appreciated.

 

Thank you,

Cory

Best answer by bkrutiy

Cory, 

This can be done by creating a report on Timesheets. General steps:

  1. Go to Reports and create a new report
  2. Give Report a name and specify Report on: “Timesheets”. If you do not see it, it needs to be included in the settings. 
  3. Add related data for the report (e.g. Work Item or Reported by dataset)
  4. Choose Columns to include (date reported, reported by, duration,work item, etc.)
  5. Group by Resource name
  6. add any other parameters...Save & Run
View original

bkrutiy
Platinum Top Contributor
Forum|alt.badge.img+3
  • Platinum Top Contributor
  • July 8, 2024

Cory, 

This can be done by creating a report on Timesheets. General steps:

  1. Go to Reports and create a new report
  2. Give Report a name and specify Report on: “Timesheets”. If you do not see it, it needs to be included in the settings. 
  3. Add related data for the report (e.g. Work Item or Reported by dataset)
  4. Choose Columns to include (date reported, reported by, duration,work item, etc.)
  5. Group by Resource name
  6. add any other parameters...Save & Run

CoryJ
Silver Active Participant
Forum|alt.badge.img+1
  • Silver Active Participant
  • July 10, 2024

Thank you Boris - that was exactly what I was looking for! 😃


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings