Skip to main content
FernandaPa
June 26, 2025
Respondido

Timesheet report summarized by month/year

  • June 26, 2025
  • 6 respostas
  • 680 Visualizações

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.

Este tópico foi fechado para respostas.
Melhor resposta por JustinRenteria2

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 Respostas

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
June 26, 2025

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

  • hours
  • work items/assignments

The latter gives you the sum, see example here 

FernandaPaAutor
June 27, 2025

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

JustinRenteria2
JustinRenteria2Resposta
Level 6
June 26, 2025

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

    JustinRenteria2
    JustinRenteria2
    Level 6
    June 26, 2025

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

      FernandaPaAutor
      June 27, 2025

      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.

      Termos e condiçõesAccessibility statement

      Loading footer...