[Feature] Reports | Group Weekly Limit report

[ariefgp]

Related document:

• Document 1
• Document 2

---

As a manager, I want to group the Weekly Limit Report data by different categories, so I can analyze time usage from various perspectives.

Note

1.1 Purpose

The Weekly Limit Report is designed to provide managers with comprehensive insights into their team's time allocations on a weekly basis. This feature aims to enhance productivity tracking, resource management, and adherence to established time limits within the organization.

1.2 Scope

This PRD outlines the requirements for implementing the Weekly Limit Report feature within our task and project management product. The report will be accessible to managers and will integrate with our existing time tracking functionality.

1.3 Definitions

• Weekly Limit: The maximum number of hours a team member is allocated to work in a week.
• Time Spent: The actual number of hours worked by a team member in a given period.
• Percentage Used: The proportion of the weekly limit that has been utilized.
• Remaining Hours: The number of hours left within the weekly limit.

Detailed Flow:

1. Manager accesses grouping options in the Weekly Limit Report
2. System provides grouping categories: Date, Week, Member
3. Manager selects one or two categories to group by
4. System reorganizes the report data based on selected grouping
5. Report title and data presentation adjust based on grouping selection

Acceptance Criteria:

• Grouping options for Date, Week, and Member are available
• Up to two categories can be selected for grouping simultaneously
• Report data reorganizes immediately when grouping is applied or changed
• When grouped by member and date, daily limit values are shown
• When grouped by member and week, weekly limit values are shown
• Grouping affects all data and calculations in the report

Additional Information

Sample UI for Group by Date

Sample Ui for group by Member

Technical

Available:

• API for Timesheet : https://api.gauzy.co/swg#/TimeLog/TimeLogController_getTimeLimitReport
• Method : GET
• Sample Request URL: /api/timesheet/time-log/time-limit
• Sample Payload:

organizationId: 7fac8f69-2721-42c6-a3df-25dfa8a88bda
tenantId: 5049a039-4104-49dc-9356-ba005b0ed7e9
startDate: 2024-10-20 21:00:00
endDate: 2024-10-27 20:59:59
timeZone: Asia/Famagusta
duration: day

• We don't have options to grouping the report view. We have to enhance existing API to support the grouping.