I have a setup where I have a project as Item level and the tasks related to the project are at a sub-item level. The team logs their time at sub-item level and there is no way today to report how much time the team is spending each week / month / quarter. The only time I can report on this is when the sub-item is marked completed.
Is there a way to do this rather than having to extract time log information using API? Very basic reporting that is missing in the tool.
there is a nice new app out there that does exactly what you are looking for. It’s called sumUp for monday and has two really powerful dashboard gadgets and reports:
Group By Widget: a one-dimensional widget, perfect for streamlined metrics grouping
Two Dimensional Widget: offers a comprehensive overview of complex data relationships.
Might be worth keeping an eye on. I think it will definitely help you with your first problem mentioned here. And best of all, it’s totally free.
Hey there. My team actually created a custom coded solution in this domain. It’s a board view that allows you to choose time tracking columns on multiple boards to pull excel reports from where the time is grouped by person/board. Maybe it’ll help some teams out. It’s a private app and just a prototype for now but you can install it with this link. Let me know if you find it useful.
The app has 2 kinds of reports that help to retrieve the data over a specific period of time you indicate in the automation rule:
On a board/project level:
New and updated tasks
Status updates
Budget, Costs, Revenue changes
Timeline and deadline overdue
Time Tracking changes
On an item/task level:
Updates by a specific employee
Updates mentioning a specific employee
Updates containing attachments
Status updates
Last updates
In you case, we need Time Tracking report. This is how the automation rule looks:
You will get a summary of changes in the time tracking column over the number of days you indicated in the rule with a detailed xls-report as an attachment: