Skip to main content
Jun 26, 2025 9:03 PM UTC
Solved

Timesheet report summarized by month/year

Hello,

I'm trying to create a report in WF Global that shows the total hours an employee has entered in a month for a project, without showing entry by entry. So, for example, I'd like to see:

Project 123456 - Employee John Doe - Month June 2025 - Total hours 56

 

I've tried using the Total Hours option, but it still shows time entry by time entry. How could I force the report o summarize by month not using Matrix?

 

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
JustinRenteria2
JustinRenteria2Accepted solution
Level 6
Jun 26, 2025 9:16 PM UTC

You should use an Hour Report instead.  Group the Hour report in Matrix mode by:
Row Grouping:  Owner > Name,  Project > Name
Column Grouping:  Hour > Entry Date (select the summarize by month option).

6 replies

Sven-iX
Community Advisor
Community Advisor
Jun 26, 2025 9:16 PM UTC

This might fit the bill - so you can either report on 

  • hours
  • work items/assignments

The latter gives you the sum, see example here 

Translate
Jun 27, 2025 1:27 PM UTC

Thank you, but what I need is a data dump of the hours by month/project/owner. A table without groupings. Is it possible?

Translate
JustinRenteria2
JustinRenteria2Accepted solution
Level 6
Jun 26, 2025 9:16 PM UTC

You should use an Hour Report instead.  Group the Hour report in Matrix mode by:
Row Grouping:  Owner > Name,  Project > Name
Column Grouping:  Hour > Entry Date (select the summarize by month option).

Translate
JustinRenteria2
Level 6
Jun 26, 2025 9:19 PM UTC

Just saw that you wanted Project first so just switch the two fields in the Row grouping above

Translate
Jun 27, 2025 1:28 PM UTC

Thank you, but I don't want the matrix view. I'd like the details tab to be a table with  hours by month/project/owner, without using the groupings. The idea is to be able to extract that and send to clients.

Translate