Skip to main content
Solved

Reported Time Per Day Reporting

  • July 1, 2024
  • 2 replies
  • 248 views

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
This topic has been closed for replies.

2 replies

bkrutiy
Bronze Product Expert
Forum|alt.badge.img+4
  • Bronze Product Expert
  • Answer
  • 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
  • Author
  • Silver Active Participant
  • July 10, 2024

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