Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.
SOLVED

Timesheet report summarized by month/year

Avatar

Level 1

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 6

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).

View solution in original post

6 Replies

Avatar

Community Advisor

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

  • hours
  • work items/assignments

The latter gives you the sum, see example here 

Avatar

Level 1

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

Avatar

Correct answer by
Level 6

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).

Avatar

Level 6

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

Avatar

Level 1

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.

Avatar

Community Advisor

I read that as OP asked for "not using matrix" 

Your report thought gives exactly what OP described, neat!

SveniX_0-1751011841447.png